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); }