/// <summary>
/// 获得预算科目
/// </summary>
/// <param name="yskmCode"></param>
/// <returns></returns>
public Bill_Yskm GetYskmByCode(string yskmCode)
{
string sql = "select * from Bill_Yskm where yskmCode=@yskmCode";
SqlParameter[] sps = { new SqlParameter("@yskmCode", yskmCode) };
using (SqlDataReader dr = DataHelper.GetDataReader(sql, sps))
{
if (dr.Read())
{
Bill_Yskm yskm = new Bill_Yskm();
yskm.Gjfs = Convert.ToString(dr["Gjfs"]);
yskm.KmStatus = Convert.ToString(dr["KmStatus"]);
yskm.Tblx = Convert.ToString(dr["Tblx"]);
yskm.Tbsm = Convert.ToString(dr["Tbsm"]);
yskm.YskmBm = Convert.ToString(dr["YskmBm"]);
yskm.YskmCode = Convert.ToString(dr["YskmCode"]);
yskm.YskmMc = Convert.ToString(dr["YskmMc"]);
yskm.KmLx = Convert.ToString(dr["kmlx"]);
yskm.GkFy = Convert.ToString(dr["gkfy"]);
yskm.XmHs = Convert.ToString(dr["xmhs"]);
yskm.BmHs = Convert.ToString(dr["bmhs"]);
yskm.RyHs = Convert.ToString(dr["ryhs"]);
yskm.dydj = Convert.ToString(dr["dydj"]);
return(yskm);
}
else
{
return(null);
}
}
}
/// <summary>
/// 插入预算科目
/// </summary>
/// <param name="yskm"></param>
public void InsertYskm(Bill_Yskm yskm)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (GetYskmByCode(yskm.YskmCode) != null)
{
DeleteYskm(yskm.YskmCode, tran);
}
InsertYskm(yskm, tran);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
private IList <Bill_Yskm> ListMaker(string sql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Yskm> list = new List <Bill_Yskm>();
foreach (DataRow dr in dt.Rows)
{
Bill_Yskm yskm = new Bill_Yskm();
yskm.Gjfs = Convert.ToString(dr["Gjfs"]);
yskm.KmStatus = Convert.ToString(dr["KmStatus"]);
yskm.Tblx = Convert.ToString(dr["Tblx"]);
yskm.Tbsm = Convert.ToString(dr["Tbsm"]);
yskm.YskmBm = Convert.ToString(dr["YskmBm"]);
yskm.YskmCode = Convert.ToString(dr["YskmCode"]);
yskm.YskmMc = Convert.ToString(dr["YskmMc"]);
yskm.dydj = Convert.ToString(dr["dydj"]);
string iszyys = Convert.ToString(dr["iszyys"]);
iszyys = iszyys.Equals("") ? "1" : iszyys;
yskm.iszyys = iszyys;
list.Add(yskm);
}
return(list);
}
public void InsertYskm(Bill_Yskm yskm, SqlTransaction tran)
{
string sql = @"INSERT INTO bill_yskm(yskmCode,yskmBm,yskmMc,gjfs,tbsm,tblx,kmStatus,kmlx,xmhs,bmhs,ryhs,dydj) VALUES(@yskmCode,@yskmBm,@yskmMc,@gjfs,@tbsm,@tblx,@kmStatus,@kmlx,@xmhs,@bmhs,@ryhs,@dydj)";
SqlParameter[] parameters =
{
new SqlParameter("@yskmCode", SqlNull(yskm.YskmCode)),
new SqlParameter("@yskmBm", SqlNull(yskm.YskmBm)),
new SqlParameter("@yskmMc", SqlNull(yskm.YskmMc)),
new SqlParameter("@gjfs", SqlNull(yskm.Gjfs)),
new SqlParameter("@tbsm", SqlNull(yskm.Tbsm)),
new SqlParameter("@tblx", SqlNull(yskm.Tblx)),
new SqlParameter("@kmStatus", SqlNull(yskm.KmStatus)),
new SqlParameter("@kmlx", SqlNull(yskm.KmLx)),
new SqlParameter("@gkfy", SqlNull(yskm.GkFy)),
new SqlParameter("@xmhs", SqlNull(yskm.XmHs)),
new SqlParameter("@bmhs", SqlNull(yskm.BmHs)),
new SqlParameter("@ryhs", SqlNull(yskm.RyHs)),
new SqlParameter("@dydj", SqlNull(yskm.dydj))
};
DataHelper.ExcuteNonQuery(sql, tran, parameters, false);
}
/// <summary>
/// 获得预算科目名称
/// </summary>
/// <param name="yskmCode"></param>
/// <returns></returns>
public string GetYskmNameCode(string yskmCode)
{
Bill_Yskm yskm = GetYskmByCode(yskmCode);
return("[" + yskm.YskmCode + "]" + yskm.YskmMc);
}
