public Dictionary <string, object> GetCLXCInfo(string CLBH)
{
Dictionary <string, object> r = new Dictionary <string, object>();
try
{
DataSet ds = db.GetCLXCInfo(CLBH);
CLBXModel model = GetUpdateModel(ds.Tables[0], ds.Tables[1]);
r["code"] = 2000;
r["items"] = model;
r["message"] = "success";
}
catch (Exception e)
{
r["code"] = -1;
r["message"] = e.Message;
}
return(r);
}
public CLBXModel GetUpdateModel(DataTable dt, DataTable dt1)
{
CLBXModel model = new CLBXModel();
foreach (DataRow dr in dt.Rows)
{
if (!IsNull(dr["CLBH"]))
{
model.CLBH = dr["CLBH"].ToString();
}
if (!IsNull(dr["DWBM"]))
{
model.DWBM = dr["DWBM"].ToString();
}
if (!IsNull(dr["CCXM"]))
{
model.CCXM = dr["CCXM"].ToString();
}
if (!IsNull(dr["CCSY"]))
{
model.CCSY = dr["CCSY"].ToString();
}
if (!IsNull(dr["CCKSSJ"]))
{
model.CCKSSJ = Convert.ToDateTime(dr["CCKSSJ"]);
}
if (!IsNull(dr["CCJSSJ"]))
{
model.CCJSSJ = Convert.ToDateTime(dr["CCJSSJ"]);
}
if (!IsNull(dr["CCTS"]))
{
model.CCTS = Convert.ToDecimal(dr["CCTS"]);
}
if (!IsNull(dr["HJJE"]))
{
model.HJJE = Convert.ToDecimal(dr["HJJE"]);
}
if (!IsNull(dr["HJDX"]))
{
model.HJDX = dr["HJDX"].ToString();
}
if (!IsNull(dr["YJCLF"]))
{
model.YJCLF = Convert.ToDecimal(dr["YJCLF"]);
}
if (!IsNull(dr["YTBJE"]))
{
model.YTBJE = Convert.ToDecimal(dr["YTBJE"]);
}
if (!IsNull(dr["REMARK"]))
{
model.REMARK = dr["REMARK"].ToString();
}
if (!IsNull(dr["SKRXM"]))
{
model.SKRXM = dr["SKRXM"].ToString();
}
if (!IsNull(dr["CJR"]))
{
model.CJR = dr["CJR"].ToString();
}
if (!IsNull(dr["CJSJ"]))
{
model.CJSJ = Convert.ToDateTime(dr["CJSJ"]);
}
if (!IsNull(dr["BJR"]))
{
model.BJR = dr["BJR"].ToString();
}
if (!IsNull(dr["BJSJ"]))
{
model.BJSJ = Convert.ToDateTime(dr["BJSJ"]);
}
if (!IsNull(dr["IS_DELETE"]))
{
model.IS_DELETE = Convert.ToInt32(dr["IS_DELETE"]);
}
if (!IsNull(dr["XMBH"]))
{
model.XMBH = dr["XMBH"].ToString();
}
if (!IsNull(dr["XMMC"]))
{
model.XMMC = dr["XMMC"].ToString();
}
if (!IsNull(dr["DWMC"]))
{
model.DWMC = dr["DWMC"].ToString();
}
model.XCList = new List <CLXCModel>();
GetCLXCList(model, dt1);
}
return(model);
}
public void GetCLXCList(CLBXModel model, DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
CLXCModel XVXC = new CLXCModel();
if (!IsNull(dr["XCID"]))
{
XVXC.XCID = dr["XCID"].ToString();
}
if (!IsNull(dr["CLBH"]))
{
XVXC.CLBH = dr["CLBH"].ToString();
}
if (!IsNull(dr["CFRQ"]))
{
XVXC.CFRQ = Convert.ToDateTime(dr["CFRQ"]);
}
if (!IsNull(dr["DDRQ"]))
{
XVXC.DDRQ = Convert.ToDateTime(dr["DDRQ"]);
}
if (!IsNull(dr["CCDD"]))
{
XVXC.CCDD = dr["CCDD"].ToString();
}
if (!IsNull(dr["CQTS"]))
{
XVXC.CQTS = Convert.ToDecimal(dr["CQTS"]);
}
if (!IsNull(dr["CQBZ"]))
{
XVXC.CQTS = Convert.ToDecimal(dr["CQBZ"]);
}
if (!IsNull(dr["BZJE"]))
{
XVXC.BZJE = Convert.ToDecimal(dr["BZJE"]);
}
if (!IsNull(dr["BFB"]))
{
XVXC.BFB = dr["BFB"].ToString();
}
if (!IsNull(dr["TS"]))
{
XVXC.TS = Convert.ToInt32(dr["TS"]);
}
if (!IsNull(dr["HCFY"]))
{
XVXC.HCFY = Convert.ToDecimal(dr["HCFY"]);
}
if (!IsNull(dr["HCFY"]))
{
XVXC.HCFY = Convert.ToDecimal(dr["HCFY"]);
}
if (!IsNull(dr["FCLB"]))
{
XVXC.FCLB = dr["FCLB"].ToString();
}
if (!IsNull(dr["FCXB"]))
{
XVXC.FCXB = dr["FCXB"].ToString();
}
if (!IsNull(dr["FCJE"]))
{
XVXC.FCJE = Convert.ToDecimal(dr["FCJE"]);
}
if (!IsNull(dr["ZFLB"]))
{
XVXC.ZFLB = dr["ZFLB"].ToString();
}
if (!IsNull(dr["ZFJE"]))
{
XVXC.ZFJE = Convert.ToDecimal(dr["ZFJE"]);
}
if (!IsNull(dr["CJR"]))
{
XVXC.CJR = dr["CJR"].ToString();
}
if (!IsNull(dr["CJSJ"]))
{
XVXC.CJSJ = Convert.ToDateTime(dr["CJSJ"]);
}
if (!IsNull(dr["BJR"]))
{
XVXC.BJR = dr["BJR"].ToString();
}
if (!IsNull(dr["BJSJ"]))
{
XVXC.BJSJ = Convert.ToDateTime(dr["BJSJ"]);
}
if (!IsNull(dr["IS_DELETE"]))
{
XVXC.IS_DELETE = Convert.ToInt32(dr["IS_DELETE"]);
}
if (!IsNull(dr["CFDD"]))
{
XVXC.CFDD = dr["CFDD"].ToString();
}
model.XCList.Add(XVXC);
}
}
