/// <summary>
/// 第一个金额是年预算金额，第二个是根据过程编号取得的季度或(月度,年度)总金额
/// </summary>
/// <param name="gcbh">过程编号</param>
/// <param name="deptcode">部门编号</param>
/// <param name="kmcode">科目编号</param>
/// <returns></returns>
public decimal[] GetYsMaxJe(string gcbh, string deptcode, string kmcode)
{
IDictionary <string, string> dic = new SysconfigDal().GetsysConfigBynd(gcbh.Substring(0, 4));
Bill_Ysgc ysgc = ysgldal.GetYsgcByCode(gcbh);
decimal[] arr = new decimal[2];
if (ysgc.YsType == "0")//年预算
{
arr[0] = -1;
arr[1] = ysgldal.GetYsje("0", ysgc.Nian, deptcode, kmcode);
}
else//季度预算,月度预算
{
if (dic["YearBudget"] == "0")
{
arr[0] = -1;
}
else
{
arr[0] = ysgldal.GetYsje("0", ysgc.Nian, deptcode, kmcode);
}
arr[1] = ysgldal.GetYsje(ysgc.YsType, ysgc.Nian, deptcode, kmcode);
}
return(arr);
}
public IList <Bill_Ysgc> GetYsgcByType(string type)
{
string sql = "select * from bill_ysgc where ystype=@type";
SqlParameter[] sps =
{
new SqlParameter("@type", type)
};
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Ysgc> list = new List <Bill_Ysgc>();
foreach (DataRow dr in dt.Rows)
{
Bill_Ysgc ysgc = new Bill_Ysgc();
ysgc.Fqsj = Convert.ToString(dr["Fqsj"]);
ysgc.Fqr = Convert.ToString(dr["Fqr"]);
ysgc.Gcbh = Convert.ToString(dr["Gcbh"]);
ysgc.Jzsj = Convert.ToDateTime(dr["Jzsj"]);
ysgc.Kssj = Convert.ToDateTime(dr["Kssj"]);
ysgc.Nian = Convert.ToString(dr["Nian"]);
ysgc.Status = Convert.ToString(dr["Status"]);
ysgc.Xmmc = Convert.ToString(dr["Xmmc"]);
ysgc.YsType = Convert.ToString(dr["YsType"]);
ysgc.Yue = Convert.ToString(dr["Yue"]);
list.Add(ysgc);
}
return(list);
}
public Bill_Ysgc GetYsgcByCode(string code)
{
string sql = "select * from bill_ysgc where gcbh=@gcbh";
SqlParameter[] sps = { new SqlParameter("@gcbh", code) };
SqlDataReader dr = DataHelper.GetDataReader(sql, sps);
Bill_Ysgc ysgc = new Bill_Ysgc();
if (dr.Read())
{
ysgc.Fqsj = Convert.ToString(dr["Fqsj"]);
ysgc.Fqr = Convert.ToString(dr["Fqr"]);
ysgc.Gcbh = Convert.ToString(dr["Gcbh"]);
ysgc.Jzsj = Convert.ToDateTime(dr["Jzsj"]);
ysgc.Kssj = Convert.ToDateTime(dr["Kssj"]);
ysgc.Nian = Convert.ToString(dr["Nian"]);
ysgc.Status = Convert.ToString(dr["Status"]);
ysgc.Xmmc = Convert.ToString(dr["Xmmc"]);
ysgc.YsType = Convert.ToString(dr["YsType"]);
ysgc.Yue = Convert.ToString(dr["Yue"]);
return(ysgc);
}
else
{
return(null);
}
}
public IList <Bill_Ysgc> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <Bill_Ysgc> list = new List <Bill_Ysgc>();
foreach (DataRow dr in dt.Rows)
{
Bill_Ysgc model = new Bill_Ysgc();
model.Gcbh = dr["gcbh"].ToString();
model.YsType = dr["ysType"].ToString();
model.Xmmc = dr["xmmc"].ToString();
if (!DBNull.Value.Equals(dr["kssj"]))
{
model.Kssj = DateTime.Parse(dr["kssj"].ToString());
}
if (!DBNull.Value.Equals(dr["jzsj"]))
{
model.Jzsj = DateTime.Parse(dr["jzsj"].ToString());
}
model.Status = dr["status"].ToString();
model.Fqr = dr["fqr"].ToString();
model.Fqsj = dr["fqsj"].ToString();
model.Nian = dr["nian"].ToString();
model.Yue = dr["yue"].ToString();
list.Add(model);
}
return(list);
}
public void InsertYsgcDal(Bill_Ysgc ysgc)
{
string sql = @"insert into bill_ysgc(gcbh, xmmc, kssj, jzsj, status, fqr, fqsj, nian, yue, ysType) values (@gcbh, @xmmc, @kssj, @jzsj, @status, @fqr, @fqsj, @nian, @yue, @ysType)";
SqlParameter[] sps =
{
new SqlParameter("@gcbh", SqlNull(ysgc.Gcbh)),
new SqlParameter("@xmmc", SqlNull(ysgc.Xmmc)),
new SqlParameter("@kssj", SqlNull(ysgc.Kssj)),
new SqlParameter("@jzsj", SqlNull(ysgc.Jzsj)),
new SqlParameter("@status", SqlNull(ysgc.Status)),
new SqlParameter("@fqr", SqlNull(ysgc.Fqr)),
new SqlParameter("@fqsj", SqlNull(ysgc.Fqsj)),
new SqlParameter("@nian", SqlNull(ysgc.Nian)),
new SqlParameter("@yue", SqlNull(ysgc.Yue)),
new SqlParameter("@ysType", SqlNull(ysgc.YsType))
};
DataHelper.ExcuteNonQuery(sql, sps, false);
}
/// <summary>
/// 根据部门求对应部门经费申请预算
/// </summary>
/// <param name="gcbh"></param>
/// <param name="deptCode"></param>
/// <returns></returns>
//public decimal GetYueYsje_dept(string gcbh, string deptCode)
//{
// return ysDal.GetYueYsje_dept(gcbh, deptCode);
//}
/// <summary>
/// 获得预算过程编号+名称
/// </summary>
/// <param name="gcbh"></param>
/// <returns></returns>
public string GetYsgcCodeName(string gcbh)
{
Bill_Ysgc ysgc = ysDal.GetYsgcByCode(gcbh);
return(ysgc == null ? "" : "[" + ysgc.Gcbh + "]" + ysgc.Xmmc);
}
