80 lines
2.8 KiB
C#
80 lines
2.8 KiB
C#
using System.Collections.Generic;
|
|
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
public class PriceSchemeService
|
|
{
|
|
public static Model.Base_PriceScheme GetPriceSchemeById(string priceSchemeId)
|
|
{
|
|
return Funs.DB.Base_PriceScheme.FirstOrDefault(e => e.PriceSchemeId == priceSchemeId);
|
|
}
|
|
|
|
public static List<Model.Base_PriceScheme> GetPriceSchemeList()
|
|
{
|
|
return (from x in Funs.DB.Base_PriceScheme orderby x.PriceScheme select x).ToList();
|
|
}
|
|
|
|
public static void AddPriceScheme(Model.Base_PriceScheme priceScheme)
|
|
{
|
|
Model.Base_PriceScheme newPriceScheme = new Model.Base_PriceScheme();
|
|
newPriceScheme.PriceSchemeId = priceScheme.PriceSchemeId;
|
|
newPriceScheme.PriceScheme = priceScheme.PriceScheme;
|
|
newPriceScheme.Remark = priceScheme.Remark;
|
|
Funs.DB.Base_PriceScheme.InsertOnSubmit(newPriceScheme);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
public static void UpdatePriceScheme(Model.Base_PriceScheme priceScheme)
|
|
{
|
|
Model.Base_PriceScheme newPriceScheme = Funs.DB.Base_PriceScheme.FirstOrDefault(e => e.PriceSchemeId == priceScheme.PriceSchemeId);
|
|
if (newPriceScheme!=null)
|
|
{
|
|
newPriceScheme.PriceScheme = priceScheme.PriceScheme;
|
|
newPriceScheme.Remark = priceScheme.Remark;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
public static void DeletePriceSchemeById(string priceSchemeId)
|
|
{
|
|
Model.Base_PriceScheme priceScheme = Funs.DB.Base_PriceScheme.FirstOrDefault(e => e.PriceSchemeId == priceSchemeId);
|
|
if (priceScheme!=null)
|
|
{
|
|
Funs.DB.Base_PriceScheme.DeleteOnSubmit(priceScheme);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
public static bool IsExitPriceScheme(string priceScheme, string id)
|
|
{
|
|
var q = Funs.DB.Base_PriceScheme.FirstOrDefault(x => x.PriceScheme == priceScheme && x.PriceSchemeId != id);
|
|
if (q != null)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 常量表下拉框
|
|
/// </summary>
|
|
/// <param name="dropName">下拉框名字</param>
|
|
/// <param name="isShowPlease">是否显示请选择</param>
|
|
public static void InitDropDownList(FineUIPro.DropDownList dropName, bool isShowPlease)
|
|
{
|
|
dropName.DataValueField = "PriceSchemeId";
|
|
dropName.DataTextField = "PriceScheme";
|
|
dropName.DataSource = GetPriceSchemeList();
|
|
dropName.DataBind();
|
|
if (isShowPlease)
|
|
{
|
|
Funs.FineUIPleaseSelect(dropName);
|
|
}
|
|
}
|
|
}
|
|
}
|