internal static void DeleteFpmx(FpmxList_tyfp fpmx)
{
string sql = "delete from FpmxList_tyfp where Ywzh=@Ywzh ";
List <DbParameter> list = new List <DbParameter>();
Sql_ListAdd(list, "@Ywzh", fpmx.Ywzh);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Other);
dbHelper.ExecuteNonQuery(MyDBType.Other, System.Data.CommandType.Text, sql, list.ToArray());
}
}
internal static void UpdateFpmx(FpmxList_tyfp fpmx)
{
string sql = "update FpmxList_tyfp set 实收费用=@ssfy,IsNew=@IsNew where Ywzh=@Ywzh and 类型=@lx";
List <DbParameter> list = new List <DbParameter>();
Sql_ListAdd(list, "@ssfy", fpmx.实收费用);
Sql_ListAdd(list, "@IsNew", fpmx.IsNew);
Sql_ListAdd(list, "@Ywzh", fpmx.Ywzh);
Sql_ListAdd(list, "@lx", fpmx.类型);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Other);
dbHelper.ExecuteNonQuery(MyDBType.Other, System.Data.CommandType.Text, sql, list.ToArray());
}
}
internal static void InsertFpmx(FpmxList_tyfp fpmx)
{
string sql = "insert into FpmxList_tyfp (Ywzh,类型,实收费用,IsNew) " +
"values(@Ywzh,@lx,@ssfy,@IsNew)";
List <DbParameter> list = new List <DbParameter>();
Sql_ListAdd(list, "@Ywzh", fpmx.Ywzh);
Sql_ListAdd(list, "@lx", fpmx.类型);
Sql_ListAdd(list, "@ssfy", fpmx.实收费用);
Sql_ListAdd(list, "@IsNew", fpmx.IsNew);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Other);
dbHelper.ExecuteNonQuery(MyDBType.Other, System.Data.CommandType.Text, sql, list.ToArray());
}
}
public static List <FpmxList_tyfp> GetFpmxList_tyfp(string slbh)
{
List <FpmxList_tyfp> list = new List <FpmxList_tyfp>();
//DJ_SFD sfd = FCSFDAL.GetSFD(param.PrjId);
List <DJ_SFD_FB> sfd_fb = FCSFDAL.GetSFDFB(slbh);
if (null != sfd_fb && sfd_fb.Count > 0)
{
foreach (var sfd in sfd_fb)
{
FpmxList_tyfp fpmx = new FpmxList_tyfp();
fpmx.IsNew = "1";
fpmx.Ywzh = sfd.SLBH;
fpmx.实收费用 = sfd.HSJE;
fpmx.类型 = sfd.SFXM;
list.Add(fpmx);
}
}
return(list);
}
