private string initPageData(string company)
{
pageData dataInfo = new pageData();
string sqlStr = "select * from K_info_Company where Co_company='" + company + "' order by Co_abbreviation select Tp_id,Tp_name from k_ProductType where Tp_company='" + company + "' and Tp_type='零件' order by Tp_name";
DbSql ds = new DbSql();
DataSet dset = new DataSet();
dset = ds.FillDs(sqlStr);
return(JsonConvert.SerializeObject(dset, new DataSetConverter()));
}
private string getData(Data data)
{
//获取期间每天的进账金额
string sqlStr = "select Ic_payDate as frDate,sum(Ic_money) as money from K_Income where Ic_isValid='1' and Ic_state='进账' and Ic_payDate<='" + data.endDate +
"' and Ic_payDate>='" + data.startDate + "' and Ic_company='" + data.company + "' group by Ic_payDate order by Ic_payDate ";
//获取期间每天的出账金额
sqlStr += "select Ol_payDate as frDate,sum(Ol_money) as money from K_Outlay where Ol_isValid='1' and Ol_state='出账' and Ol_payDate<='" + data.endDate +
"' and Ol_payDate>='" + data.startDate + "' and Ol_company='" + data.company + "' group by Ol_payDate order by Ol_payDate ";
sqlStr += "select sum(Ic_money) as money from K_Income where Ic_isValid='1' and Ic_state='待进账' and Ic_company='" + data.company + "' ";
sqlStr += "select sum(Ol_money) as money from K_Outlay where Ol_isValid='1' and Ol_state='待出账' and Ol_company='" + data.company + "' ";
sqlStr += "select SUM(Cp_inventory*Cp_price) as money from K_Component WHERE Cp_isValid='1' and Cp_company='" + data.company + "'";
DbSql ds = new DbSql();
DataSet dset = new DataSet();
dset = ds.FillDs(sqlStr);
return(JsonConvert.SerializeObject(dset, new DataSetConverter()));
}
private string getComponent(Data data)
{
string sqlStr = "select * from K_Component where Cp_company='" + data.company + "' and Cp_isValid='1'";
if (data.Cp_manufacturerId != "")
{
sqlStr += "and Cp_manufacturerId='" + data.Cp_manufacturerId + "'";
}
if (data.Cp_typeId != "")
{
sqlStr += " and Cp_typeId='" + data.Cp_typeId + "'";
}
sqlStr += "order by Cp_editDate";
DbSql ds = new DbSql();
DataSet dset = new DataSet();
dset = ds.FillDs(sqlStr);
return(JsonConvert.SerializeObject(dset, new DataTableConverter()));
}
private string addFinancial(Data data)
{
DbSql ds = new DbSql();
//根据供应商id和零件类型id获取，供应商公司名字和类型名字
string sqlStr = "select Co_abbreviation from K_info_Company where Co_company='" + data.company + "' and Co_id='" + data.Pc_manufacturerId + "' ";
sqlStr += "select Tp_name from k_ProductType where Tp_company='" + data.company + "' and Tp_id='" + data.Pc_typeId + "'";
DataSet dset = new DataSet();
dset = ds.FillDs(sqlStr);
//将数据自动添加进财务管理的进账
if (data.Pc_Method.IndexOf("月结") > -1)
{
data.Ol_state = "待出账";
}
sqlStr = " insert into K_Outlay (Ol_payDate,Ol_payee,Ol_payMethod,Ol_money,Ol_content,Ol_operator,Ol_remarks,Ol_company,Ol_state) values ('"
+ data.Pc_date + "','" + dset.Tables[0].Rows[0][0] + "','" + "现金" + "','" + (Double.Parse(data.Pc_unitPrice) * Double.Parse(data.Pc_quantity)).ToString("0.00") + "','" +
"【采购】【" + dset.Tables[1].Rows[0][0] + "】" + data.Pc_parameter + "|数量：" + data.Pc_quantity + "|单价：" + data.Pc_unitPrice + "|用途:" + data.Pc_purpose + "','" + data.Pc_operator + "','" + data.Pc_remarks + "','" + data.company + "','" + data.Ol_state + "')";
return(sqlStr);
}
