105 lines
3.4 KiB
C#
105 lines
3.4 KiB
C#
|
using Model;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
|
|||
|
|
namespace BLL
|
|||
|
|
{
|
|||
|
|
public static class Base_MediumService
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
///获取安装组件信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static Model.Base_Medium GetMediumByMediumId(string mediumId)
|
|||
|
|
{
|
|||
|
|
return Funs.DB.Base_Medium.FirstOrDefault(e => e.MediumId == mediumId);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 增加安装组件信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="medium"></param>
|
|||
|
|
public static void AddMedium(Model.Base_Medium medium)
|
|||
|
|
{
|
|||
|
|
Model.HJGLDB db = Funs.DB;
|
|||
|
|
Model.Base_Medium newMedium = new Base_Medium
|
|||
|
|
{
|
|||
|
|
MediumId = medium.MediumId,
|
|||
|
|
MediumCode = medium.MediumCode,
|
|||
|
|
MediumName = medium.MediumName,
|
|||
|
|
MediumAbbreviation = medium.MediumAbbreviation,
|
|||
|
|
Remark = medium.Remark,
|
|||
|
|
};
|
|||
|
|
db.Base_Medium.InsertOnSubmit(newMedium);
|
|||
|
|
db.SubmitChanges();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改安装组件信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="medium"></param>
|
|||
|
|
public static void UpdateMedium(Model.Base_Medium medium)
|
|||
|
|
{
|
|||
|
|
Model.HJGLDB db = Funs.DB;
|
|||
|
|
Model.Base_Medium newMedium = db.Base_Medium.FirstOrDefault(e => e.MediumId == medium.MediumId);
|
|||
|
|
if (newMedium != null)
|
|||
|
|
{
|
|||
|
|
newMedium.MediumCode = medium.MediumCode;
|
|||
|
|
newMedium.MediumName = medium.MediumName;
|
|||
|
|
newMedium.MediumAbbreviation = medium.MediumAbbreviation;
|
|||
|
|
newMedium.Remark = medium.Remark;
|
|||
|
|
db.SubmitChanges();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 根据安装组件Id删除一个安装组件信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="mediumId"></param>
|
|||
|
|
public static void DeleteMediumByMediumId(string mediumId)
|
|||
|
|
{
|
|||
|
|
Model.HJGLDB db = Funs.DB;
|
|||
|
|
Model.Base_Medium delMedium = db.Base_Medium.FirstOrDefault(e => e.MediumId == mediumId);
|
|||
|
|
if (delMedium != null)
|
|||
|
|
{
|
|||
|
|
db.Base_Medium.DeleteOnSubmit(delMedium);
|
|||
|
|
db.SubmitChanges();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 按类型获取安装组件项
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="MediumType"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public static List<Model.Base_Medium> GetMediumList()
|
|||
|
|
{
|
|||
|
|
var list = (from x in Funs.DB.Base_Medium
|
|||
|
|
orderby x.MediumCode
|
|||
|
|
select x).ToList();
|
|||
|
|
|
|||
|
|
return list;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#region 安装组件下拉项
|
|||
|
|
/// <summary>
|
|||
|
|
/// 安装组件下拉项
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="dropName">下拉框名称</param>
|
|||
|
|
/// <param name="isShowPlease">是否显示请选择</param>
|
|||
|
|
/// <param name="MediumType">耗材类型</param>
|
|||
|
|
public static void InitMediumDropDownList(FineUIPro.DropDownList dropName, bool isShowPlease,string itemText)
|
|||
|
|
{
|
|||
|
|
dropName.DataValueField = "MediumId";
|
|||
|
|
dropName.DataTextField = "MediumCode";
|
|||
|
|
dropName.DataSource = GetMediumList();
|
|||
|
|
dropName.DataBind();
|
|||
|
|
if (isShowPlease)
|
|||
|
|
{
|
|||
|
|
Funs.FineUIPleaseSelect(dropName,itemText);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
}
|
|||
|
|
}
|