public void DeleteRela(DataGridView ddv) { SqlDBConnect sqldb = new SqlDBConnect(); int indexid = 0; indexid = ddv.CurrentRow.Index; string sqlcustid = "select CustID " + "from T_CustomerInf where CustName='" + ddv.Rows[indexid].Cells[0].Value.ToString().Trim() + "'"; string custid= (new SqlDBConnect()).Ret_Single_val_Sql(sqlcustid); string sqlparentcustid = "select CustID " + "from T_CustomerInf where CustName='" + ddv.Rows[indexid].Cells[1].Value.ToString().Trim() + "'"; string parentcustid = (new SqlDBConnect()).Ret_Single_val_Sql(sqlparentcustid); string sql = "delete from T_Customer_Rela where CustID='" + custid + "' and ParentID='" + parentcustid + "'"; try { sqldb.ExecuteNonQuery(sql); MessageBox.Show("数据更新成功!"); ddv.Rows.RemoveAt(ddv.CurrentRow.Index); ddv.Refresh(); } catch { MessageBox.Show("数据更新失败!"); } finally { } }
public void update_delete() { SqlDBConnect sqldbc = new SqlDBConnect(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(); SqlCommandBuilder scb = new SqlCommandBuilder(sda); sda.Update(ds); }
/// <summary> /// 获得RoleId表总的全部数据 /// </summary> /// <returns></returns> public static DataTable GetDatas() { string strSql = "select RoleId as 角色编号, RoleName as 角色名,Rmemo as 备注 from T_Roles"; SqlDBConnect db = new SqlDBConnect(); return db.Get_Dt(strSql); }
public static DataTable GetDatasByParentPIdAndPid(string strParentPId, string strPid) { string strSql = "select * from T_UserRelation where ParentPId='{0}' and Pid='{1}'"; strSql = string.Format(strSql, strParentPId, strPid); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); return dt; }
public static DataTable GetDatas() { string strSql = "select T_Users.UserName as 人员, T_UsersView.UserName as 上级人员, T_UserType.UtypeName as 人员类型, T_UserGrade.Gname as 人员等级, T_UserRelation.CanRepair as 可维修机型 " + "from T_UserRelation,T_Users,T_UsersView,T_UserType,T_UserGrade " + "where T_UserRelation.Pid=T_Users.UserId and T_UserRelation.ParentPId=T_UsersView.UserId " + "and T_UserRelation.Utype=T_UserType.TypeId and T_UserRelation.Gid=T_UserGrade.Gid"; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); return dt; }
public static DataTable GetDatasByUserId(string userId) { string strSql = "select T_Users.UserName as 用户名,T_Roles.RoleName as 角色名 from T_Users,T_Roles,T_User_Role " + "where T_User_Role.UserId = '{0}' and T_User_Role.UserId=T_Users.UserId and T_User_Role.RoleId=T_Roles.RoleId"; strSql = string.Format(strSql, userId); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); return dt; }
public static bool IsExistData(string tableName, string sqlWhere) { string strSql = "select * from {0} {1}"; strSql = string.Format(strSql, tableName, sqlWhere); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); if (dt.Rows.Count <= 0) return false; return true; }
private void button1_Click(object sender, EventArgs e) { SqlDBConnect cn = new SqlDBConnect(); string sq = ""; for (int i = 0; i < textBox2.Lines.Count(); i++) { sq = "select T_SelItems values(" + textBox1.Text + textBox2.Lines[i] + ")"; } List<string> list = new List<string>(); list.Add(sq); cn.Exec_Tansaction(list); }
public static DataTable GetDatasByParentPId(string strParentPId) { string strSql = "select T_Users.UserName as 下级人员, T_UserType.UtypeName as 人员类型, T_UserGrade.Gname as 人员等级, T_UserRelation.CanRepair as 可维修机型 " + "from T_UserRelation inner join T_Users " + "on T_UserRelation.ParentPId='{0}' and T_UserRelation.Pid=T_Users.UserId left outer join T_UserType " + "on T_UserRelation.Utype=T_UserType.TypeId left outer join T_UserGrade " + "on T_UserRelation.Gid=T_UserGrade.Gid"; strSql = string.Format(strSql, strParentPId); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); return dt; }
/// <summary> /// 检查是否存在数据 /// </summary> /// <param name="sql_">select语句</param> /// <returns></returns> public bool yn_exist_data(string sql_) { SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(sql_); if (dt != null && dt.Rows.Count > 0) { return(true); } else { return(false); } }
/// <summary> /// 取得某一数据表中和某一字段对应的一相应字段的值 /// </summary> /// 传入SQL语句 /// <returns></returns> public string Get_Single_val(string strSql) { string retStr = ""; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); if (dt != null && dt.Rows.Count > 0) { retStr = dt.Rows[0][0].ToString().Trim(); } return(retStr); }
public static DateTime getServerTime() { //DateTime now_ = System.DateTime.Now; DateTime now_ = Convert.ToDateTime("1900-01-01 23:59:59"); string sql_ = "select getdate()"; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(sql_); if (dt != null && dt.Rows.Count > 0) { now_ = Convert.ToDateTime(dt.Rows[0][0].ToString()); } return(now_); }
/// <summary> /// 检查一个表中的某一个字段是否存在一个对应的值 /// </summary> /// <param name="tableName">数据表</param> /// <param name="filedName">数据表中的某一字段(字符型)</param> /// <param name="filedValue">要查找的值</param> /// <returns></returns> public bool Is_Exist_Data(string tableName, string filedName, string filedValue) { string strSql = "select * from {0} where {1}='{2}'"; strSql = string.Format(strSql, tableName, filedName, filedValue); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); if (dt.Rows.Count <= 0) { return(false); } return(true); }
/// <summary> ///报表通用连接查询语句 /// </summary> public void Connect(string strSql, string receiname) { SqlDBConnect db = new SqlDBConnect(); DataTable dt = new DataTable(); dt = db.Get_Dt(strSql); string count = dt.Rows.Count.ToString(); //通过sql条件显示报表窗体 PublicDetailForm form = new PublicDetailForm(); form.MdiParent = this; form.Show(); form.ReiceName = receiname; form.Username = userName; form.strSql = strSql; form.count = count; form.ShowReport(); }
/// <summary> /// 初始化CheckBoxList(将码表中的数据绑定到CheckBoxList控件) /// </summary> /// <param name="cb"></param> /// <param name="lx_"></param> public void InitCheckedListBox(CheckedListBox clb, string itemVal) { clb.Items.Clear(); string sql_ = "select ItemVal from T_SelItems where ItemType='" + itemVal + "'"; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(sql_); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { clb.Items.Add(dr["ItemVal"].ToString().Trim()); } } }
/// <summary> /// 取得某一数据表中和某一字段对应的一相应字段的值 /// </summary> /// <param name="tableName">要操作的表名</param> /// <param name="d_zdm">目的字段</param> /// <param name="s_zdm">原字段名称(整型字段)</param> /// <param name="s_zdz">原字段值</param> /// <returns></returns> public string Get_Single_val(string tableName, string d_zdm, string s_zdm, int s_zdz) { string retStr = ""; string strSql = "select {0} from {1} where {2}={3}"; strSql = string.Format(strSql, d_zdm, tableName, s_zdm, s_zdz); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); if (dt != null && dt.Rows.Count > 0) { retStr = dt.Rows[0][d_zdm].ToString().Trim(); } return(retStr); }
public static List<string> GetFunctionById(string roleId) { List<string> listFunctions = new List<string>(); string strSql = "select [Function] from T_Role_Rights where RoleId='{0}'"; strSql = string.Format(strSql, roleId); SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(strSql); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { listFunctions.Add(dr["Function"].ToString().Trim()); } } return listFunctions; }
/// <summary> /// 初始化ComboBox(将码表T_SelItems中的数据绑定到ComboBox控件) /// </summary> /// <param name="comBox"></param> /// <param name="lx_"></param> public void InitComboBox(ComboBox comBox, string itemVal) { comBox.Items.Clear(); comBox.Items.Add("--请选择--"); string sql_ = "select distinct ItemVal from T_SelItems where ItemType='" + itemVal + "'"; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(sql_); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { comBox.Items.Add(dr["ItemVal"].ToString().Trim()); } } comBox.Items.Add(""); comBox.SelectedIndex = 0; }
public void Delete(DataGridView ddv) { SqlDBConnect sqldb = new SqlDBConnect(); int indexid = 0; indexid = ddv.CurrentRow.Index; string sql = ""; sql = "delete from T_CustomerCall where BargId='" + ddv.Rows[indexid].Cells["合同编号"].Value.ToString() + "'"; try { sqldb.ExecuteNonQuery(sql); //MessageBox.Show("数据更新成功!"); ddv.Rows.RemoveAt(ddv.CurrentRow.Index); ddv.Refresh(); } catch { MessageBox.Show("数据更新失败或存在外码约束!"); } finally { } }
//type_:单据类型(2个字符) //month_:月份(年月201107) public static string Produce_Bill_Id(string type_, string month_, ref string UpdateSql) { //转换服务器时间为特定格式(如2011-07-01转化为201107) DateTime dateTime = Convert.ToDateTime(month_); month_ = dateTime.Year.ToString().Trim() + dateTime.Month.ToString().Trim().PadLeft(2, '0'); int maxno_ = 0; string BillId_ = "", tmp = ""; string SqlTmp = ""; string sql_ = "select maxno from t_ReceiptRule where ReceiptType='" + type_ + "' and whichmonth='" + month_ + "'"; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(sql_); if (dt == null || dt.Rows.Count <= 0) //本月第1张 { maxno_ = 1; SqlTmp = "insert into t_ReceiptRule(ReceiptType,whichMonth,MaxNo) values('{0}','{1}',{2})"; SqlTmp = string.Format(SqlTmp, type_.Trim(), month_.Trim(), maxno_.ToString()); } else { maxno_ = Convert.ToInt16(dt.Rows[0]["maxno"]) + 1; SqlTmp = "update t_ReceiptRule set MaxNo={0} where ReceiptType='{1}' and whichMonth='{2}'"; SqlTmp = string.Format(SqlTmp, maxno_.ToString(), type_.Trim(), month_.Trim()); } //处理成固定个数的字符 tmp = maxno_.ToString(); while (tmp.Length < 5) { tmp = '0' + tmp; } // BillId_ = type_.Trim() + month_ + tmp; UpdateSql = SqlTmp; return(BillId_); }
public void Delete(DataGridView ddv) { SqlDBConnect sqldb = new SqlDBConnect(); int indexid = 0; indexid = ddv.CurrentRow.Index; string sql = ""; sql = "delete from T_CustContacts where CName='" + ddv.Rows[indexid].Cells["联系姓名"].Value.ToString().Trim () + "'"; try { sqldb.ExecuteNonQuery(sql); MessageBox.Show("删除成功!"); ddv.Rows.RemoveAt(ddv.CurrentRow.Index); ddv.Refresh(); } catch { MessageBox.Show("更新失败!"); } finally { } }
/// <summary> /// 保存 /// </summary> private void btnSave_Click(object sender, EventArgs e) { //输入数据有效性验证 if (s_AttachName.Text.Trim() == "") { MessageBox.Show("附件名称不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string strSqlSel = ""; string strSql = ""; DBUtil dbUtil = new DBUtil(); SqlDBConnect db = new SqlDBConnect(); if (this.Type == "add") { //判断该资料原件记录是否已存在 strSqlSel = "select * from T_BargAttach where barsysid={0} and AttachName='{1}'"; strSqlSel = string.Format(strSqlSel, this.barsysid, this.s_AttachName.Text.Trim()); strSql = (new InitFuncs()).Build_Insert_Sql(this.panel1, "T_BargAttach"); } else if (this.Type == "edit") { int SysId = Convert.ToInt32(this.dataGridView1.SelectedRows[0].Cells["附件编号"].Value.ToString().Trim()); strSqlSel = "select * from T_BargAttach where BarSysId like {0} and Ltrim(Rtrim(AttachName)) like '{1}' and Ltrim(Rtrim(SysId)) not like {2}"; strSqlSel = string.Format(strSqlSel, this.barsysid, this.s_AttachName.Text.Trim(), SysId); string strWhere = "where SysId=" + SysId; strSql = (new InitFuncs()).Build_Update_Sql(this.panel1, "T_BargAttach", strWhere); } bool isExist = dbUtil.yn_exist_data(strSqlSel); if (isExist) { MessageBox.Show("当前合同已存在该附件名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } db.ExecuteNonQuery(strSql); //MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); initdataGridview(); }
/// <summary> /// 显示对应单据报表 /// </summary> /// <param name="rowHeaderName">行头名</param> /// <param name="columnName">列头名</param> public void SqlToReport(string rowHeaderName, string columnName) { string TypeName = ""; string sql = "SELECT ReceiptId 单据号,InvoiceNo 发票编号, ReceiptTypeID 单据类别," + "CustomerReceiptNo 自定义编号,CurWorkMonth 工作年月,OccurTime 单据日期," + "CustName 客户名称,MatId 商品编号 ,MatName 商品名称,SourceStoreH 仓库," + "MatType 类型,num 数量,price 含税单价,Amount 含税金额,TTaxPurchPrice 成本金额," + "ML 毛利, lotCode 批号,VerifyPerson 验收员,BillUser 操作员,Memo 备注 " + "FROM T_JXDetail where SourceStoreH='" + columnName + "' and "; string strsql = ""; switch (rowHeaderName) { case "01": TypeName = "JHDetail"; strsql = sql + " ReceiptTypeID='01'"; break; case "03": TypeName = "JHDetail"; strsql = sql + " ReceiptTypeID='03'"; break; case "20": TypeName = "JHDetail"; strsql = sql + " ReceiptTypeID='20'"; break; case "51": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='51'"; break; case "52": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='52'"; break; case "53": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='53'"; break; case "54": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='54'"; break; case "55": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='55'"; break; case "56": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='56'"; break; case "75": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='75'"; break; case "88": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='88'"; break; case "90": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='90'"; break; default: break; } SqlDBConnect db = new SqlDBConnect(); DataTable dt = new DataTable(); strsql += " and (OccurTime between '" + dateTimeFrom + "' and '" + dateTimeTo + "')"; dt = db.Get_Dt(strsql); string count = dt.Rows.Count.ToString(); //通过sql条件显示报表窗体 PublicDetailForm form = new PublicDetailForm(); form.MdiParent = this.MdiParent as MainForm; form.Show(); form.strSql = strsql; form.count = count; form.ReiceName = TypeName; form.Username = (this.MdiParent as MainForm).userName; form.ShowReport(); }
private DataTable GetDataTable() { SqlDBConnect db = new SqlDBConnect(); string storeHouseId = "J"; int matType = 0; string dateTimeFrom = this.DateTimePickerFrom.Value.ToString("yyyy-MM-dd").Trim(); //"2011-07-01";// string dateTimeTo = this.DateTimePickerTo.Value.ToString("yyyy-MM-dd").Trim(); // "2011-07-31";// string firstDayOfCurMonth = (new DateTime(DateTimePickerFrom.Value.Year, DateTimePickerFrom.Value.Month, 1)).ToString().Trim();//当月第一天 //"2011-07-01";// string curWorkMonth = dateTimeFrom.Substring(0, 7); curWorkMonth = curWorkMonth.Remove(curWorkMonth.IndexOf('-'), 1); //当前工作月 string strSql = "select FirstCount,FirstCostPrice,FirstMoney,BalanceTime from T_Stock_Status " + "where StoreHouseId='{0}' and MatId='{1}' and MatType={2} and BalanceTime='{3}'"; //strSql = string.Format(strSql, storeHouseId, matId, matType, maxBalanceTime); //string strSql = "select T_MatInf.MatId AS 物料编号,T_Receipt_Main.SourceStoreH 仓库编号,T_Receipts_Det.MatType 物料类型, " + // " dbo.T_MatInf.MatName AS 物料名称, dbo.T_MatInf.Specifications AS 型号规格, " + // " dbo.T_MatInf.Units AS 单位, dbo.T_Stock_Status.FirstCount AS 期初数量 " + // " T_Receipt_Main.CurWorkMonth AS 工作年月, T_Receipt_Main.OccurTime AS 单据日期 " + // " into " + TempName + " FROM dbo.T_MatInf " + // " inner join T_Receipts_Det on T_Receipts_Det.MatId=T_MatInf.MatId " + // " inner join T_Receipt_Main on T_Receipt_Main.ReceiptId=T_Receipts_Det.ReceiptId " + // " left JOIN dbo.T_Stock_Status ON dbo.T_Stock_Status.MatId = dbo.T_MatInf.MatId " + // " and T_Stock_Status.StoreHouseId=T_Receipt_Main.SourceStoreH and T_Receipts_Det.MatType=T_Stock_Status.MatType " + // " and T_Stock_Status.BalanceTime='" + maxbatime + "'"; DataTable dt = new DataTable(); DataColumn dc = new DataColumn("类别"); dc.Caption = "类别"; DataColumn dc1 = new DataColumn("佳图"); dc1.Caption = "佳图"; DataColumn dc2 = new DataColumn("佳图空"); dc2.Caption = "佳图空"; DataColumn dc3 = new DataColumn("欣图"); dc3.Caption = "欣图"; DataColumn dc4 = new DataColumn("欣图空"); dc4.Caption = "欣图空"; DataColumn dc5 = new DataColumn("瑞博"); dc5.Caption = "瑞博"; DataColumn dc6 = new DataColumn("瑞博空"); dc6.Caption = "瑞博空"; DataColumn dc7 = new DataColumn("信息"); dc7.Caption = "信息"; DataColumn dc8 = new DataColumn("信息空"); dc8.Caption = "信息空"; DataColumn dc9 = new DataColumn("合计"); dc8.Caption = "合计"; dt.Columns.Add(dc); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); dt.Columns.Add(dc6); dt.Columns.Add(dc7); dt.Columns.Add(dc8); dt.Columns.Add(dc9); int i = -1; //上日列帐 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "上日列帐"; string sqlStockStatus = "select FirstCount,FirstCostPrice,FirstMoney,BalanceTime from T_Stock_Status " + "where BalanceTime='"+ curWorkMonth + "'"; //dt.Rows[i]["佳图"] = sumJOut; //dt.Rows[i]["佳图空"] = sumJKOut; //dt.Rows[i]["欣图"] = sumXOut; //dt.Rows[i]["欣图空"] = sumXKOut; //dt.Rows[i]["瑞博"] = sumROut; //dt.Rows[i]["瑞博空"] = sumRKOut; //dt.Rows[i]["信息"] = sumHOut; //dt.Rows[i]["信息空"] = sumHKOut; //dt.Rows[i]["合计"] = sumJOut + sumJKOut + sumXOut + sumXKOut + sumROut + sumRKOut + sumHOut + sumHKOut; //暂估入库 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "暂估入库"; //发出商品 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "发出商品"; //实际结存 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "实际结存"; //空行 dt.Rows.Add(); i++; //01-进货单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "01-进货单"; #region 01-进货单 double JAmount01 = 0.0, JKAmount01 = 0.0, XAmount01 = 0.0, XKAmount01 = 0.0, RAmount01 = 0.0, RKAmount01 = 0.0, HAmount01 = 0.0, HKAmount01 = 0.0; double JNotTax01 = 0.0, JKNotTax01 = 0.0, XNotTax01 = 0.0, XKNotTax01 = 0.0, RNotTax01 = 0.0, RKNotTax01 = 0.0, HNotTax01 = 0.0, HKNotTax01 = 0.0; double JTax01 = 0.0, JKTax01 = 0.0, XTax01 = 0.0, XKTax01 = 0.0, RTax01 = 0.0, RKTax01 = 0.0, HTax01 = 0.0, HKTax01 = 0.0; double JCost01 = 0.0, JKCost01 = 0.0, XCost01 = 0.0, XKCost01 = 0.0, RCost01 = 0.0, RKCost01 = 0.0, HCost01 = 0.0, HKCost01 = 0.0; string sql01 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '01' and (OccurTime between '{0}' and '{1}')"; sql01 = string.Format(sql01, dateTimeFrom, dateTimeTo); DataTable dt01 = db.Get_Dt(sql01); if (dt01 != null && dt01.Rows.Count > 0) { foreach (DataRow dr in dt01.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") JNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") JTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") JKNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") JKTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") XNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") XTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") XKNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") XKTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") RNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") RTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") RKNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") RKTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") HNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") HTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") HKNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") HKTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //含税金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "含税金额"; dt.Rows[i]["佳图"] = JAmount01; dt.Rows[i]["佳图空"] = JKAmount01; dt.Rows[i]["欣图"] = XAmount01; dt.Rows[i]["欣图空"] = XKAmount01; dt.Rows[i]["瑞博"] = RAmount01; dt.Rows[i]["瑞博空"] = RKAmount01; dt.Rows[i]["信息"] = HAmount01; dt.Rows[i]["信息空"] = HKAmount01; dt.Rows[i]["合计"] = JAmount01 + JKAmount01 + XAmount01 + XKAmount01 + RAmount01 + RKAmount01 + HAmount01 + HKAmount01; //不含税金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "不含税金额"; dt.Rows[i]["佳图"] = JNotTax01; dt.Rows[i]["佳图空"] = JKNotTax01; dt.Rows[i]["欣图"] = XNotTax01; dt.Rows[i]["欣图空"] = XKNotTax01; dt.Rows[i]["瑞博"] = RNotTax01; dt.Rows[i]["瑞博空"] = RKNotTax01; dt.Rows[i]["信息"] = HNotTax01; dt.Rows[i]["信息空"] = HKNotTax01; dt.Rows[i]["合计"] = JNotTax01 + JKNotTax01 + XNotTax01 + XKNotTax01 + RNotTax01 + RKNotTax01 + HNotTax01 + HKNotTax01; //税额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "税额"; dt.Rows[i]["佳图"] = JTax01; dt.Rows[i]["佳图空"] = JKTax01; dt.Rows[i]["欣图"] = XTax01; dt.Rows[i]["欣图空"] = XKTax01; dt.Rows[i]["瑞博"] = RTax01; dt.Rows[i]["瑞博空"] = RKTax01; dt.Rows[i]["信息"] = HTax01; dt.Rows[i]["信息空"] = HKTax01; dt.Rows[i]["合计"] = JTax01 + JKTax01 + XTax01 + XKTax01 + RTax01 + RKTax01 + HTax01 + HKTax01; //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount01; dt.Rows[i]["佳图空"] = JKAmount01; dt.Rows[i]["欣图"] = XAmount01; dt.Rows[i]["欣图空"] = XKAmount01; dt.Rows[i]["瑞博"] = RAmount01; dt.Rows[i]["瑞博空"] = RKAmount01; dt.Rows[i]["信息"] = HAmount01; dt.Rows[i]["信息空"] = HKAmount01; dt.Rows[i]["合计"] = JAmount01 + JKAmount01 + XAmount01 + XKAmount01 + RAmount01 + RKAmount01 + HAmount01 + HKAmount01; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JAmount01; dt.Rows[i]["佳图空"] = JKAmount01; dt.Rows[i]["欣图"] = XAmount01; dt.Rows[i]["欣图空"] = XKAmount01; dt.Rows[i]["瑞博"] = RAmount01; dt.Rows[i]["瑞博空"] = RKAmount01; dt.Rows[i]["信息"] = HAmount01; dt.Rows[i]["信息空"] = HKAmount01; dt.Rows[i]["合计"] = JAmount01 + JKAmount01 + XAmount01 + XKAmount01 + RAmount01 + RKAmount01 + HAmount01 + HKAmount01; #endregion //03-假设进货单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "03-假设进货单"; #region 03-假设进货单 double JAmount03 = 0.0, JKAmount03 = 0.0, XAmount03 = 0.0, XKAmount03 = 0.0, RAmount03 = 0.0, RKAmount03 = 0.0, HAmount03 = 0.0, HKAmount03 = 0.0; double JCost03 = 0.0, JKCost03 = 0.0, XCost03 = 0.0, XKCost03 = 0.0, RCost03 = 0.0, RKCost03 = 0.0, HCost03 = 0.0, HKCost03 = 0.0; string sql03 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '03' and (OccurTime between '{0}' and '{1}')"; sql03 = string.Format(sql03, dateTimeFrom, dateTimeTo); DataTable dt03 = db.Get_Dt(sql03); if (dt03 != null && dt03.Rows.Count > 0) { foreach (DataRow dr in dt03.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount03; dt.Rows[i]["佳图空"] = JKAmount03; dt.Rows[i]["欣图"] = XAmount03; dt.Rows[i]["欣图空"] = XKAmount03; dt.Rows[i]["瑞博"] = RAmount03; dt.Rows[i]["瑞博空"] = RKAmount03; dt.Rows[i]["信息"] = HAmount03; dt.Rows[i]["信息空"] = HKAmount03; dt.Rows[i]["合计"] = JAmount03 + JKAmount03 + XAmount03 + XKAmount03 + RAmount03 + RKAmount03 + HAmount03 + HKAmount03; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JAmount03; dt.Rows[i]["佳图空"] = JKAmount03; dt.Rows[i]["欣图"] = XAmount03; dt.Rows[i]["欣图空"] = XKAmount03; dt.Rows[i]["瑞博"] = RAmount03; dt.Rows[i]["瑞博空"] = RKAmount03; dt.Rows[i]["信息"] = HAmount03; dt.Rows[i]["信息空"] = HKAmount03; dt.Rows[i]["合计"] = JAmount03 + JKAmount03 + XAmount03 + XKAmount03 + RAmount03 + RKAmount03 + HAmount03 + HKAmount03; #endregion //04-盈亏单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "04-盈亏单"; #region 04-盈亏单 double JCost04 = 0.0, JKCost04 = 0.0, XCost04 = 0.0, XKCost04 = 0.0, RCost04 = 0.0, RKCost04 = 0.0, HCost04 = 0.0, HKCost04 = 0.0; string sql04 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '04' and (OccurTime between '{0}' and '{1}')"; sql04 = string.Format(sql04, dateTimeFrom, dateTimeTo); DataTable dt04 = db.Get_Dt(sql04); if (dt04 != null && dt04.Rows.Count > 0) { foreach (DataRow dr in dt04.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost04; dt.Rows[i]["佳图空"] = JKCost04; dt.Rows[i]["欣图"] = XCost04; dt.Rows[i]["欣图空"] = XKCost04; dt.Rows[i]["瑞博"] = RCost04; dt.Rows[i]["瑞博空"] = RKCost04; dt.Rows[i]["信息"] = HCost04; dt.Rows[i]["信息空"] = HKCost04; dt.Rows[i]["合计"] = JCost04 + JKCost04 + XCost04 + XKCost04 + RCost04 + RKCost04 + HCost04 + HKCost04; #endregion //20-假设结账单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "20-假设结账单"; #region 20-假设结账单 double JCost20 = 0.0, JKCost20 = 0.0, XCost20 = 0.0, XKCost20 = 0.0, RCost20 = 0.0, RKCost20 = 0.0, HCost20 = 0.0, HKCost20 = 0.0; string sql20 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '20' and (OccurTime between '{0}' and '{1}')"; sql20 = string.Format(sql20, dateTimeFrom, dateTimeTo); DataTable dt20 = db.Get_Dt(sql20); if (dt20 != null && dt20.Rows.Count > 0) { foreach (DataRow dr in dt20.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost20; dt.Rows[i]["佳图空"] = JKCost20; dt.Rows[i]["欣图"] = XCost20; dt.Rows[i]["欣图空"] = XKCost20; dt.Rows[i]["瑞博"] = RCost20; dt.Rows[i]["瑞博空"] = RKCost20; dt.Rows[i]["信息"] = HCost20; dt.Rows[i]["信息空"] = HKCost20; dt.Rows[i]["合计"] = JCost20 + JKCost20 + XCost20 + XKCost20 + RCost20 + RKCost20 + HCost20 + HKCost20; #endregion //收入小计 dt.Rows.Add(); i++; #region 收入小计 double sumJIn=JAmount01 + JAmount03 + JCost04 + JCost20; double sumJKIn=JKAmount01 + JKAmount03 + JKCost04 + JKCost20; double sumXIn=XAmount01 + XAmount03 + XCost04 + XCost20; double sumXKIn= XKAmount01 + XKAmount03 + XKCost04 + XKCost20; double sumRIn=RAmount01 + RAmount03 + RCost04 + RCost20; double sumRKIn=RKAmount01 + RKAmount03 + RKCost04 + RKCost20; double sumHIn=HAmount01 + HAmount03 + HCost04 + HCost20; double sumHKIn=HKAmount01 + HKAmount03 + HKCost04 + HKCost20; dt.Rows[i]["类别"] = "收入小计"; dt.Rows[i]["佳图"] = sumJIn; dt.Rows[i]["佳图空"] = sumJKIn; dt.Rows[i]["欣图"] = sumXIn; dt.Rows[i]["欣图空"] =sumXKIn; dt.Rows[i]["瑞博"] = sumRIn; dt.Rows[i]["瑞博空"] = sumRKIn; dt.Rows[i]["信息"] = sumHIn; dt.Rows[i]["信息空"] = sumHKIn; dt.Rows[i]["合计"] = sumJIn + sumJKIn + sumXIn + sumXKIn + sumRIn + sumRKIn + sumHIn + sumHKIn; #endregion //空行 dt.Rows.Add(); i++; //51-销售单1 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "51-销售单1"; #region 51-销售单1 double JAmount51 = 0.0, JKAmount51 = 0.0, XAmount51 = 0.0, XKAmount51 = 0.0, RAmount51 = 0.0, RKAmount51 = 0.0, HAmount51 = 0.0, HKAmount51 = 0.0; double JCost51 = 0.0, JKCost51 = 0.0, XCost51 = 0.0, XKCost51 = 0.0, RCost51 = 0.0, RKCost51 = 0.0, HCost51 = 0.0, HKCost51 = 0.0; string sql51 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '51' and (OccurTime between '{0}' and '{1}')"; sql51 = string.Format(sql51, dateTimeFrom, dateTimeTo); DataTable dt51 = db.Get_Dt(sql51); if (dt51 != null && dt51.Rows.Count > 0) { foreach (DataRow dr in dt51.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount51; dt.Rows[i]["佳图空"] = JKAmount51; dt.Rows[i]["欣图"] = XAmount51; dt.Rows[i]["欣图空"] = XKAmount51; dt.Rows[i]["瑞博"] = RAmount51; dt.Rows[i]["瑞博空"] = RKAmount51; dt.Rows[i]["信息"] = HAmount51; dt.Rows[i]["信息空"] = HKAmount51; dt.Rows[i]["合计"] = JAmount51 + JKAmount51 + XAmount51 + XKAmount51 + RAmount51 + RKAmount51 + HAmount51 + HKAmount51; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost51; dt.Rows[i]["佳图空"] = JKCost51; dt.Rows[i]["欣图"] = XCost51; dt.Rows[i]["欣图空"] = XKCost51; dt.Rows[i]["瑞博"] = RCost51; dt.Rows[i]["瑞博空"] = RKCost51; dt.Rows[i]["信息"] = HCost51; dt.Rows[i]["信息空"] = HKCost51; dt.Rows[i]["合计"] = JCost51 + JKCost51 + XCost51 + XKCost51 + RCost51 + RKCost51 + HCost51 + HKCost51; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount51-JCost51; dt.Rows[i]["佳图空"] = JKAmount51-JKCost51; dt.Rows[i]["欣图"] = XAmount51-XCost51; dt.Rows[i]["欣图空"] = XKAmount51-XKCost51; dt.Rows[i]["瑞博"] = RAmount51-RCost51; dt.Rows[i]["瑞博空"] = RKAmount51-RKCost51; dt.Rows[i]["信息"] = HAmount51-HCost51; dt.Rows[i]["信息空"] = HKAmount51-HKCost51; dt.Rows[i]["合计"] = JAmount51 - JCost51 + JKAmount51 - JKCost51 + XAmount51 - XCost51 + XKAmount51 - XKCost51 + RAmount51 - RCost51 + RKAmount51 - RKCost51 + HAmount51 - HCost51 + HKAmount51 - HKCost51; //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount51Add = 0.0, JKAmount51Add = 0.0, XAmount51Add = 0.0, XKAmount51Add = 0.0, RAmount51Add = 0.0, RKAmount51Add = 0.0, HAmount51Add = 0.0, HKAmount51Add = 0.0; double JCost51Add = 0.0, JKCost51Add = 0.0, XCost51Add = 0.0, XKCost51Add = 0.0, RCost51Add = 0.0, RKCost51Add = 0.0, HCost51Add = 0.0, HKCost51Add = 0.0; string sql51Add= "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '51' and (OccurTime between '{0}' and '{1}')"; sql51Add = string.Format(sql51Add, firstDayOfCurMonth, dateTimeTo); DataTable dt51Add = db.Get_Dt(sql51Add); if (dt51Add != null && dt51Add.Rows.Count > 0) { foreach (DataRow dr in dt51Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount51Add; dt.Rows[i]["佳图空"] = JKAmount51Add; dt.Rows[i]["欣图"] = XAmount51Add; dt.Rows[i]["欣图空"] = XKAmount51Add; dt.Rows[i]["瑞博"] = RAmount51Add; dt.Rows[i]["瑞博空"] = RKAmount51Add; dt.Rows[i]["信息"] = HAmount51Add; dt.Rows[i]["信息空"] = HKAmount51Add; dt.Rows[i]["合计"] = JAmount51Add + JKAmount51Add + XAmount51Add + XKAmount51Add + RAmount51Add + RKAmount51Add + HAmount51Add + HKAmount51Add; //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost51Add; dt.Rows[i]["佳图空"] = JKCost51Add; dt.Rows[i]["欣图"] = XCost51Add; dt.Rows[i]["欣图空"] = XKCost51Add; dt.Rows[i]["瑞博"] = RCost51Add; dt.Rows[i]["瑞博空"] = RKCost51Add; dt.Rows[i]["信息"] = HCost51Add; dt.Rows[i]["信息空"] = HKCost51Add; dt.Rows[i]["合计"] = JCost51Add + JKCost51Add + XCost51Add + XKCost51Add + RCost51Add + RKCost51Add + HCost51Add + HKCost51Add; //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = JAmount51Add - JCost51Add; dt.Rows[i]["佳图空"] = JKAmount51Add - JKCost51Add; dt.Rows[i]["欣图"] = XAmount51Add - XCost51Add; dt.Rows[i]["欣图空"] = XKAmount51Add - XKCost51Add; dt.Rows[i]["瑞博"] = RAmount51Add - RCost51Add; dt.Rows[i]["瑞博空"] = RKAmount51Add - RKCost51Add; dt.Rows[i]["信息"] = HAmount51Add - HCost51Add; dt.Rows[i]["信息空"] = HKAmount51Add - HKCost51Add; dt.Rows[i]["合计"] = JAmount51Add - JCost51Add + JKAmount51Add - JKCost51Add + XAmount51Add - XCost51Add + XKAmount51Add - XKCost51Add + RAmount51Add - RCost51Add + RKAmount51Add - RKCost51Add + HAmount51Add - HCost51Add + HKAmount51Add - HKCost51Add; #endregion //52-销售单2 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "52-销售单2"; #region 52-销售单2 double JAmount52 = 0.0, JKAmount52 = 0.0, XAmount52 = 0.0, XKAmount52 = 0.0, RAmount52 = 0.0, RKAmount52 = 0.0, HAmount52 = 0.0, HKAmount52 = 0.0; double JCost52 = 0.0, JKCost52 = 0.0, XCost52 = 0.0, XKCost52 = 0.0, RCost52 = 0.0, RKCost52 = 0.0, HCost52 = 0.0, HKCost52 = 0.0; string sql52 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '52' and (OccurTime between '{0}' and '{1}')"; sql52 = string.Format(sql52, dateTimeFrom, dateTimeTo); DataTable dt52 = db.Get_Dt(sql52); if (dt52 != null && dt52.Rows.Count > 0) { foreach (DataRow dr in dt52.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount52; dt.Rows[i]["佳图空"] = JKAmount52; dt.Rows[i]["欣图"] = XAmount52; dt.Rows[i]["欣图空"] = XKAmount52; dt.Rows[i]["瑞博"] = RAmount52; dt.Rows[i]["瑞博空"] = RKAmount52; dt.Rows[i]["信息"] = HAmount52; dt.Rows[i]["信息空"] = HKAmount52; dt.Rows[i]["合计"] = JAmount52 + JKAmount52 + XAmount52 + XKAmount52 + RAmount52 + RKAmount52 + HAmount52 + HKAmount52; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost52; dt.Rows[i]["佳图空"] = JKCost52; dt.Rows[i]["欣图"] = XCost52; dt.Rows[i]["欣图空"] = XKCost52; dt.Rows[i]["瑞博"] = RCost52; dt.Rows[i]["瑞博空"] = RKCost52; dt.Rows[i]["信息"] = HCost52; dt.Rows[i]["信息空"] = HKCost52; dt.Rows[i]["合计"] = JCost52 + JKCost52 + XCost52 + XKCost52 + RCost52 + RKCost52 + HCost52 + HKCost52; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount52 - JCost52; dt.Rows[i]["佳图空"] = JKAmount52 - JKCost52; dt.Rows[i]["欣图"] = XAmount52 - XCost52; dt.Rows[i]["欣图空"] = XKAmount52 - XKCost52; dt.Rows[i]["瑞博"] = RAmount52 - RCost52; dt.Rows[i]["瑞博空"] = RKAmount52 - RKCost52; dt.Rows[i]["信息"] = HAmount52 - HCost52; dt.Rows[i]["信息空"] = HKAmount52 - HKCost52; dt.Rows[i]["合计"] = JAmount52 - JCost52 + JKAmount52 - JKCost52 + XAmount52 - XCost52 + XKAmount52 - XKCost52 + RAmount52 - RCost52 + RKAmount52 - RKCost52 + HAmount52 - HCost52 + HKAmount52 - HKCost52; //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount52Add = 0.0, JKAmount52Add = 0.0, XAmount52Add = 0.0, XKAmount52Add = 0.0, RAmount52Add = 0.0, RKAmount52Add = 0.0, HAmount52Add = 0.0, HKAmount52Add = 0.0; double JCost52Add = 0.0, JKCost52Add = 0.0, XCost52Add = 0.0, XKCost52Add = 0.0, RCost52Add = 0.0, RKCost52Add = 0.0, HCost52Add = 0.0, HKCost52Add = 0.0; string sql52Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '52' and (OccurTime between '{0}' and '{1}')"; sql52Add = string.Format(sql52Add, firstDayOfCurMonth, dateTimeTo); DataTable dt52Add = db.Get_Dt(sql52Add); if (dt52Add != null && dt52Add.Rows.Count > 0) { foreach (DataRow dr in dt52Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount52Add; dt.Rows[i]["佳图空"] = JKAmount52Add; dt.Rows[i]["欣图"] = XAmount52Add; dt.Rows[i]["欣图空"] = XKAmount52Add; dt.Rows[i]["瑞博"] = RAmount52Add; dt.Rows[i]["瑞博空"] = RKAmount52Add; dt.Rows[i]["信息"] = HAmount52Add; dt.Rows[i]["信息空"] = HKAmount52Add; dt.Rows[i]["合计"] = JAmount52Add + JKAmount52Add + XAmount52Add + XKAmount52Add + RAmount52Add + RKAmount52Add + HAmount52Add + HKAmount52Add; //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost52Add; dt.Rows[i]["佳图空"] = JKCost52Add; dt.Rows[i]["欣图"] = XCost52Add; dt.Rows[i]["欣图空"] = XKCost52Add; dt.Rows[i]["瑞博"] = RCost52Add; dt.Rows[i]["瑞博空"] = RKCost52Add; dt.Rows[i]["信息"] = HCost52Add; dt.Rows[i]["信息空"] = HKCost52Add; dt.Rows[i]["合计"] = JCost52Add + JKCost52Add + XCost52Add + XKCost52Add + RCost52Add + RKCost52Add + HCost52Add + HKCost52Add; //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = JAmount52Add - JCost52Add; dt.Rows[i]["佳图空"] = JKAmount52Add - JKCost52Add; dt.Rows[i]["欣图"] = XAmount52Add - XCost52Add; dt.Rows[i]["欣图空"] = XKAmount52Add - XKCost52Add; dt.Rows[i]["瑞博"] = RAmount52Add - RCost52Add; dt.Rows[i]["瑞博空"] = RKAmount52Add - RKCost52Add; dt.Rows[i]["信息"] = HAmount52Add - HCost52Add; dt.Rows[i]["信息空"] = HKAmount52Add - HKCost52Add; dt.Rows[i]["合计"] = JAmount52Add - JCost52Add + JKAmount52Add - JKCost52Add + XAmount52Add - XCost52Add + XKAmount52Add - XKCost52Add + RAmount52Add - RCost52Add + RKAmount52Add - RKCost52Add + HAmount52Add - HCost52Add + HKAmount52Add - HKCost52Add; #endregion //53-调拨单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "53-调拨单"; #region 53-调拨单 double JAmount53 = 0.0, JKAmount53 = 0.0, XAmount53 = 0.0, XKAmount53 = 0.0, RAmount53 = 0.0, RKAmount53 = 0.0, HAmount53 = 0.0, HKAmount53 = 0.0; double JCost53 = 0.0, JKCost53 = 0.0, XCost53 = 0.0, XKCost53 = 0.0, RCost53 = 0.0, RKCost53 = 0.0, HCost53 = 0.0, HKCost53 = 0.0; string sql53 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '53' and (OccurTime between '{0}' and '{1}')"; sql53 = string.Format(sql53, dateTimeFrom, dateTimeTo); DataTable dt53 = db.Get_Dt(sql53); if (dt53 != null && dt53.Rows.Count > 0) { foreach (DataRow dr in dt53.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount53; dt.Rows[i]["佳图空"] = JKAmount53; dt.Rows[i]["欣图"] = XAmount53; dt.Rows[i]["欣图空"] = XKAmount53; dt.Rows[i]["瑞博"] = RAmount53; dt.Rows[i]["瑞博空"] = RKAmount53; dt.Rows[i]["信息"] = HAmount53; dt.Rows[i]["信息空"] = HKAmount53; dt.Rows[i]["合计"] = JAmount53 + JKAmount53 + XAmount53 + XKAmount53 + RAmount53 + RKAmount53 + HAmount53 + HKAmount53; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost53; dt.Rows[i]["佳图空"] = JKCost53; dt.Rows[i]["欣图"] = XCost53; dt.Rows[i]["欣图空"] = XKCost53; dt.Rows[i]["瑞博"] = RCost53; dt.Rows[i]["瑞博空"] = RKCost53; dt.Rows[i]["信息"] = HCost53; dt.Rows[i]["信息空"] = HKCost53; dt.Rows[i]["合计"] = JCost53 + JKCost53 + XCost53 + XKCost53 + RCost53 + RKCost53 + HCost53 + HKCost53; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount53 - JCost53; dt.Rows[i]["佳图空"] = JKAmount53 - JKCost53; dt.Rows[i]["欣图"] = XAmount53 - XCost53; dt.Rows[i]["欣图空"] = XKAmount53 - XKCost53; dt.Rows[i]["瑞博"] = RAmount53 - RCost53; dt.Rows[i]["瑞博空"] = RKAmount53 - RKCost53; dt.Rows[i]["信息"] = HAmount53 - HCost53; dt.Rows[i]["信息空"] = HKAmount53 - HKCost53; dt.Rows[i]["合计"] = JAmount53 - JCost53 + JKAmount53- JKCost53 + XAmount53 - XCost53 + XKAmount53 - XKCost53 + RAmount53 - RCost53 + RKAmount53 - RKCost53 + HAmount53 - HCost53 + HKAmount53 - HKCost53; #endregion //54-销售单4 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "54-销售单4"; #region 54-销售单4 double JAmount54 = 0.0, JKAmount54 = 0.0, XAmount54 = 0.0, XKAmount54 = 0.0, RAmount54 = 0.0, RKAmount54 = 0.0, HAmount54 = 0.0, HKAmount54 = 0.0; double JCost54 = 0.0, JKCost54 = 0.0, XCost54 = 0.0, XKCost54 = 0.0, RCost54 = 0.0, RKCost54 = 0.0, HCost54 = 0.0, HKCost54 = 0.0; string sql54 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '54' and (OccurTime between '{0}' and '{1}')"; sql54 = string.Format(sql54, dateTimeFrom, dateTimeTo); DataTable dt54 = db.Get_Dt(sql54); if (dt54 != null && dt54.Rows.Count > 0) { foreach (DataRow dr in dt54.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount54; dt.Rows[i]["佳图空"] = JKAmount54; dt.Rows[i]["欣图"] = XAmount54; dt.Rows[i]["欣图空"] = XKAmount54; dt.Rows[i]["瑞博"] = RAmount54; dt.Rows[i]["瑞博空"] = RKAmount54; dt.Rows[i]["信息"] = HAmount54; dt.Rows[i]["信息空"] = HKAmount54; dt.Rows[i]["合计"] = JAmount54 + JKAmount54 + XAmount54 + XKAmount54 + RAmount54 + RKAmount54 + HAmount54 + HKAmount54; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost54; dt.Rows[i]["佳图空"] = JKCost54; dt.Rows[i]["欣图"] = XCost54; dt.Rows[i]["欣图空"] = XKCost54; dt.Rows[i]["瑞博"] = RCost54; dt.Rows[i]["瑞博空"] = RKCost54; dt.Rows[i]["信息"] = HCost54; dt.Rows[i]["信息空"] = HKCost54; dt.Rows[i]["合计"] = JCost54 + JKCost54 + XCost54 + XKCost54 + RCost54 + RKCost54 + HCost54 + HKCost54; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount54 - JCost54; dt.Rows[i]["佳图空"] = JKAmount54 - JKCost54; dt.Rows[i]["欣图"] = XAmount54 - XCost54; dt.Rows[i]["欣图空"] = XKAmount54 - XKCost54; dt.Rows[i]["瑞博"] = RAmount54 - RCost54; dt.Rows[i]["瑞博空"] = RKAmount54 - RKCost54; dt.Rows[i]["信息"] = HAmount54 - HCost54; dt.Rows[i]["信息空"] = HKAmount54 - HKCost54; dt.Rows[i]["合计"] = JAmount54 - JCost54 + JKAmount54 - JKCost54 + XAmount54 - XCost54 + XKAmount54 - XKCost54 + RAmount54 - RCost54 + RKAmount54 - RKCost54 + HAmount54 - HCost54 + HKAmount54 - HKCost54; #endregion //55-销售单3 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "55-销售单3"; #region 55-销售单3 double JAmount55 = 0.0, JKAmount55 = 0.0, XAmount55 = 0.0, XKAmount55 = 0.0, RAmount55 = 0.0, RKAmount55 = 0.0, HAmount55 = 0.0, HKAmount55 = 0.0; double JCost55 = 0.0, JKCost55 = 0.0, XCost55 = 0.0, XKCost55 = 0.0, RCost55 = 0.0, RKCost55 = 0.0, HCost55 = 0.0, HKCost55 = 0.0; string sql55 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '55' and (OccurTime between '{0}' and '{1}')"; sql55 = string.Format(sql55, dateTimeFrom, dateTimeTo); DataTable dt55 = db.Get_Dt(sql55); if (dt55 != null && dt55.Rows.Count > 0) { foreach (DataRow dr in dt55.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount55; dt.Rows[i]["佳图空"] = JKAmount55; dt.Rows[i]["欣图"] = XAmount55; dt.Rows[i]["欣图空"] = XKAmount55; dt.Rows[i]["瑞博"] = RAmount55; dt.Rows[i]["瑞博空"] = RKAmount55; dt.Rows[i]["信息"] = HAmount55; dt.Rows[i]["信息空"] = HKAmount55; dt.Rows[i]["合计"] = JAmount55 + JKAmount55 + XAmount55 + XKAmount55 + RAmount55 + RKAmount55 + HAmount55 + HKAmount55; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost55; dt.Rows[i]["佳图空"] = JKCost55; dt.Rows[i]["欣图"] = XCost55; dt.Rows[i]["欣图空"] = XKCost55; dt.Rows[i]["瑞博"] = RCost55; dt.Rows[i]["瑞博空"] = RKCost55; dt.Rows[i]["信息"] = HCost55; dt.Rows[i]["信息空"] = HKCost55; dt.Rows[i]["合计"] = JCost55 + JKCost55 + XCost55 + XKCost55 + RCost55 + RKCost55 + HCost55 + HKCost55; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount55 - JCost55; dt.Rows[i]["佳图空"] = JKAmount55 - JKCost55; dt.Rows[i]["欣图"] = XAmount55 - XCost55; dt.Rows[i]["欣图空"] = XKAmount55 - XKCost55; dt.Rows[i]["瑞博"] = RAmount55 - RCost55; dt.Rows[i]["瑞博空"] = RKAmount55 - RKCost55; dt.Rows[i]["信息"] = HAmount55 - HCost55; dt.Rows[i]["信息空"] = HKAmount55 - HKCost55; dt.Rows[i]["合计"] = JAmount55 - JCost55 + JKAmount55 - JKCost55 + XAmount55 - XCost55 + XKAmount55 - XKCost55 + RAmount55 - RCost55 + RKAmount55 - RKCost55 + HAmount55 - HCost55 + HKAmount55 - HKCost55; #endregion //56-销售单5 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "56-销售单5"; #region 56-销售单5 double JAmount56 = 0.0, JKAmount56 = 0.0, XAmount56 = 0.0, XKAmount56 = 0.0, RAmount56 = 0.0, RKAmount56 = 0.0, HAmount56 = 0.0, HKAmount56 = 0.0; double JCost56= 0.0, JKCost56 = 0.0, XCost56 = 0.0, XKCost56 = 0.0, RCost56 = 0.0, RKCost56 = 0.0, HCost56 = 0.0, HKCost56 = 0.0; string sql56 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '56' and (OccurTime between '{0}' and '{1}')"; sql56 = string.Format(sql56, dateTimeFrom, dateTimeTo); DataTable dt56 = db.Get_Dt(sql56); if (dt56 != null && dt56.Rows.Count > 0) { foreach (DataRow dr in dt56.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount56; dt.Rows[i]["佳图空"] = JKAmount56; dt.Rows[i]["欣图"] = XAmount56; dt.Rows[i]["欣图空"] = XKAmount56; dt.Rows[i]["瑞博"] = RAmount56; dt.Rows[i]["瑞博空"] = RKAmount56; dt.Rows[i]["信息"] = HAmount56; dt.Rows[i]["信息空"] = HKAmount56; dt.Rows[i]["合计"] = JAmount56 + JKAmount56 + XAmount56 + XKAmount56 + RAmount56 + RKAmount56 + HAmount56 + HKAmount56; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost56; dt.Rows[i]["佳图空"] = JKCost56; dt.Rows[i]["欣图"] = XCost56; dt.Rows[i]["欣图空"] = XKCost56; dt.Rows[i]["瑞博"] = RCost56; dt.Rows[i]["瑞博空"] = RKCost56; dt.Rows[i]["信息"] = HCost56; dt.Rows[i]["信息空"] = HKCost56; dt.Rows[i]["合计"] = JCost56 + JKCost56 + XCost56 + XKCost56 + RCost56 + RKCost56 + HCost56 + HKCost56; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount56 - JCost56; dt.Rows[i]["佳图空"] = JKAmount56 - JKCost56; dt.Rows[i]["欣图"] = XAmount56 - XCost56; dt.Rows[i]["欣图空"] = XKAmount56 - XKCost56; dt.Rows[i]["瑞博"] = RAmount56 - RCost56; dt.Rows[i]["瑞博空"] = RKAmount56 - RKCost56; dt.Rows[i]["信息"] = HAmount56 - HCost56; dt.Rows[i]["信息空"] = HKAmount56 - HKCost56; dt.Rows[i]["合计"] = JAmount56 - JCost56 + JKAmount56 - JKCost56 + XAmount56 - XCost56 + XKAmount56 - XKCost56 + RAmount56 - RCost56 + RKAmount56 - RKCost56 + HAmount56 - HCost56 + HKAmount56 - HKCost56; //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount56Add = 0.0, JKAmount56Add = 0.0, XAmount56Add = 0.0, XKAmount56Add = 0.0, RAmount56Add = 0.0, RKAmount56Add = 0.0, HAmount56Add = 0.0, HKAmount56Add = 0.0; double JCost56Add = 0.0, JKCost56Add = 0.0, XCost56Add = 0.0, XKCost56Add = 0.0, RCost56Add = 0.0, RKCost56Add = 0.0, HCost56Add = 0.0, HKCost56Add = 0.0; string sql56Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '56' and (OccurTime between '{0}' and '{1}')"; sql56Add = string.Format(sql56Add, firstDayOfCurMonth, dateTimeTo); DataTable dt56Add = db.Get_Dt(sql56Add); if (dt56Add != null && dt56Add.Rows.Count > 0) { foreach (DataRow dr in dt56Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount56Add; dt.Rows[i]["佳图空"] = JKAmount56Add; dt.Rows[i]["欣图"] = XAmount56Add; dt.Rows[i]["欣图空"] = XKAmount56Add; dt.Rows[i]["瑞博"] = RAmount56Add; dt.Rows[i]["瑞博空"] = RKAmount56Add; dt.Rows[i]["信息"] = HAmount56Add; dt.Rows[i]["信息空"] = HKAmount56Add; dt.Rows[i]["合计"] = JAmount56Add + JKAmount56Add + XAmount56Add + XKAmount56Add + RAmount56Add + RKAmount56Add + HAmount56Add + HKAmount56Add; //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost56Add; dt.Rows[i]["佳图空"] = JKCost56Add; dt.Rows[i]["欣图"] = XCost56Add; dt.Rows[i]["欣图空"] = XKCost56Add; dt.Rows[i]["瑞博"] = RCost56Add; dt.Rows[i]["瑞博空"] = RKCost56Add; dt.Rows[i]["信息"] = HCost56Add; dt.Rows[i]["信息空"] = HKCost56Add; dt.Rows[i]["合计"] = JCost56Add + JKCost56Add + XCost56Add + XKCost56Add + RCost56Add + RKCost56Add + HCost56Add + HKCost56Add; //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = JAmount56Add - JCost56Add; dt.Rows[i]["佳图空"] = JKAmount56Add - JKCost56Add; dt.Rows[i]["欣图"] = XAmount56Add - XCost56Add; dt.Rows[i]["欣图空"] = XKAmount56Add - XKCost56Add; dt.Rows[i]["瑞博"] = RAmount56Add - RCost56Add; dt.Rows[i]["瑞博空"] = RKAmount56Add - RKCost56Add; dt.Rows[i]["信息"] = HAmount56Add - HCost56Add; dt.Rows[i]["信息空"] = HKAmount56Add - HKCost56Add; dt.Rows[i]["合计"] = JAmount56Add - JCost56Add + JKAmount56Add - JKCost56Add + XAmount56Add - XCost56Add + XKAmount56Add - XKCost56Add + RAmount56Add - RCost56Add + RKAmount56Add - RKCost56Add + HAmount56Add - HCost56Add + HKAmount56Add - HKCost56Add; #endregion //75-借用单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "75-借用单"; #region 75-借用单 double JAmount75 = 0.0, JKAmount75 = 0.0, XAmount75 = 0.0, XKAmount75 = 0.0, RAmount75 = 0.0, RKAmount75 = 0.0, HAmount75 = 0.0, HKAmount75 = 0.0; double JCost75 = 0.0, JKCost75 = 0.0, XCost75 = 0.0, XKCost75 = 0.0, RCost75 = 0.0, RKCost75 = 0.0, HCost75 = 0.0, HKCost75 = 0.0; string sql75 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '75' and (OccurTime between '{0}' and '{1}')"; sql75 = string.Format(sql75, dateTimeFrom, dateTimeTo); DataTable dt75 = db.Get_Dt(sql75); if (dt75 != null && dt75.Rows.Count > 0) { foreach (DataRow dr in dt75.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount75; dt.Rows[i]["佳图空"] = JKAmount75; dt.Rows[i]["欣图"] = XAmount75; dt.Rows[i]["欣图空"] = XKAmount75; dt.Rows[i]["瑞博"] = RAmount75; dt.Rows[i]["瑞博空"] = RKAmount75; dt.Rows[i]["信息"] = HAmount75; dt.Rows[i]["信息空"] = HKAmount75; dt.Rows[i]["合计"] = JAmount75 + JKAmount75 + XAmount75 + XKAmount75 + RAmount75 + RKAmount75 + HAmount75 + HKAmount75; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost75; dt.Rows[i]["佳图空"] = JKCost75; dt.Rows[i]["欣图"] = XCost75; dt.Rows[i]["欣图空"] = XKCost75; dt.Rows[i]["瑞博"] = RCost75; dt.Rows[i]["瑞博空"] = RKCost75; dt.Rows[i]["信息"] = HCost75; dt.Rows[i]["信息空"] = HKCost75; dt.Rows[i]["合计"] = JCost75 + JKCost75 + XCost75 + XKCost75 + RCost75 + RKCost75 + HCost75 + HKCost75; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount75 - JCost75; dt.Rows[i]["佳图空"] = JKAmount75 - JKCost75; dt.Rows[i]["欣图"] = XAmount75 - XCost75; dt.Rows[i]["欣图空"] = XKAmount75 - XKCost75; dt.Rows[i]["瑞博"] = RAmount75 - RCost75; dt.Rows[i]["瑞博空"] = RKAmount75 - RKCost75; dt.Rows[i]["信息"] = HAmount75 - HCost75; dt.Rows[i]["信息空"] = HKAmount75 - HKCost75; dt.Rows[i]["合计"] = JAmount75 - JCost75 + JKAmount75 - JKCost75 + XAmount75 - XCost75 + XKAmount75 - XKCost75 + RAmount75 - RCost75 + RKAmount75 - RKCost75 + HAmount75 - HCost75 + HKAmount75 - HKCost75; #endregion //88-租机单 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "88-租机单"; #region 88-租机单 double JAmount88 = 0.0, JKAmount88 = 0.0, XAmount88 = 0.0, XKAmount88 = 0.0, RAmount88 = 0.0, RKAmount88 = 0.0, HAmount88 = 0.0, HKAmount88 = 0.0; double JCost88 = 0.0, JKCost88 = 0.0, XCost88 = 0.0, XKCost88 = 0.0, RCost88 = 0.0, RKCost88 = 0.0, HCost88 = 0.0, HKCost88 = 0.0; string sql88 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '88' and (OccurTime between '{0}' and '{1}')"; sql88 = string.Format(sql88, dateTimeFrom, dateTimeTo); DataTable dt88= db.Get_Dt(sql88); if (dt88 != null && dt88.Rows.Count > 0) { foreach (DataRow dr in dt88.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["Amount"].ToString().Trim() != "") JKAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["Amount"].ToString().Trim() != "") XKAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["Amount"].ToString().Trim() != "") RKAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost88+= Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["Amount"].ToString().Trim() != "") HKAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount88; dt.Rows[i]["佳图空"] = JKAmount88; dt.Rows[i]["欣图"] = XAmount88; dt.Rows[i]["欣图空"] = XKAmount88; dt.Rows[i]["瑞博"] = RAmount88; dt.Rows[i]["瑞博空"] = RKAmount88; dt.Rows[i]["信息"] = HAmount88; dt.Rows[i]["信息空"] = HKAmount88; dt.Rows[i]["合计"] = JAmount88 + JKAmount88 + XAmount88 + XKAmount88 + RAmount88 + RKAmount88 + HAmount88 + HKAmount88; //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost88; dt.Rows[i]["佳图空"] = JKCost88; dt.Rows[i]["欣图"] = XCost88; dt.Rows[i]["欣图空"] = XKCost88; dt.Rows[i]["瑞博"] = RCost88; dt.Rows[i]["瑞博空"] = RKCost88; dt.Rows[i]["信息"] = HCost88; dt.Rows[i]["信息空"] = HKCost88; dt.Rows[i]["合计"] = JCost88 + JKCost88 + XCost88 + XKCost88 + RCost88 + RKCost88 + HCost88 + HKCost88; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = JAmount88 - JCost88; dt.Rows[i]["佳图空"] = JKAmount88 - JKCost88; dt.Rows[i]["欣图"] = XAmount88 - XCost88; dt.Rows[i]["欣图空"] = XKAmount88 - XKCost88; dt.Rows[i]["瑞博"] = RAmount88 - RCost88; dt.Rows[i]["瑞博空"] = RKAmount88 - RKCost88; dt.Rows[i]["信息"] = HAmount88 - HCost88; dt.Rows[i]["信息空"] = HKAmount88 - HKCost88; dt.Rows[i]["合计"] = JAmount88 - JCost88 + JKAmount88 - JKCost88 + XAmount88 - XCost88 + XKAmount88 - XKCost88 + RAmount88 - RCost88 + RKAmount88 - RKCost88 + HAmount88 - HCost88 + HKAmount88 - HKCost88; #endregion //90-暂估结账销售 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "90-暂估结账销售"; #region 90-暂估结账销售 double JCost90 = 0.0, JKCost90 = 0.0, XCost90 = 0.0, XKCost90 = 0.0, RCost90 = 0.0, RKCost90 = 0.0, HCost90 = 0.0, HKCost90 = 0.0; string sql90 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '90' and (OccurTime between '{0}' and '{1}')"; sql90 = string.Format(sql90, dateTimeFrom, dateTimeTo); DataTable dt90 = db.Get_Dt(sql90); if (dt90 != null && dt90.Rows.Count > 0) { foreach (DataRow dr in dt90.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "JK") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") JKCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "XK") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") XKCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "RK") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") RKCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "HK") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") HKCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost90; dt.Rows[i]["佳图空"] = JKCost90; dt.Rows[i]["欣图"] = XCost90; dt.Rows[i]["欣图空"] = XKCost90; dt.Rows[i]["瑞博"] = RCost90; dt.Rows[i]["瑞博空"] = RKCost90; dt.Rows[i]["信息"] = HCost90; dt.Rows[i]["信息空"] = HKCost90; dt.Rows[i]["合计"] = JCost90 + JKCost90 + XCost90 + XKCost90 + RCost90 + RKCost90 + HCost90 + HKCost90; #endregion //发出小计 dt.Rows.Add(); i++; #region 发出小计 double sumJOut = JCost51 + JCost52 + JCost54 + JCost55 + JCost56 + JCost75 + JCost88 + JCost90; double sumJKOut = JKCost51 + JKCost52 + JKCost54 + JKCost55 + JKCost56 + JKCost75 + JKCost88 + JKCost90; double sumXOut = XCost51 + XCost52 + XCost54 + XCost55 + XCost56 + XCost75 + XCost88 + XCost90; double sumXKOut = XKCost51 + XKCost52 + XKCost54 + XKCost55 + XKCost56 + XKCost75 + XKCost88 + XKCost90; double sumROut = RCost51 + RCost52 + RCost54 + RCost55 + RCost56 + RCost75 + RCost88 + RCost90; double sumRKOut = RKCost51 + RKCost52 + RKCost54 + RKCost55 + RKCost56 + RKCost75 + RKCost88 + RKCost90; double sumHOut = HCost51 + HCost52 + HCost54 + HCost55 + HCost56 + HCost75 + HCost88 + HCost90; double sumHKOut = HKCost51 + HKCost52 + HKCost54 + HKCost55 + HKCost56 + HKCost75 + HKCost88 + HKCost90; dt.Rows[i]["类别"] = "发出小计"; dt.Rows[i]["佳图"] = sumJOut; dt.Rows[i]["佳图空"] = sumJKOut; dt.Rows[i]["欣图"] = sumXOut; dt.Rows[i]["欣图空"] = sumXKOut; dt.Rows[i]["瑞博"] = sumROut; dt.Rows[i]["瑞博空"] = sumRKOut; dt.Rows[i]["信息"] = sumHOut; dt.Rows[i]["信息空"] = sumHKOut; dt.Rows[i]["合计"] = sumJOut + sumJKOut + sumXOut + sumXKOut + sumROut + sumRKOut + sumHOut + sumHKOut; #endregion //空行 dt.Rows.Add(); i++; //本日列帐 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "本日列帐"; //dt.Rows[i]["佳图"] = sumJOut; //dt.Rows[i]["佳图空"] = sumJKOut; //dt.Rows[i]["欣图"] = sumXOut; //dt.Rows[i]["欣图空"] = sumXKOut; //dt.Rows[i]["瑞博"] = sumROut; //dt.Rows[i]["瑞博空"] = sumRKOut; //dt.Rows[i]["信息"] = sumHOut; //dt.Rows[i]["信息空"] = sumHKOut; //dt.Rows[i]["合计"] = sumJOut + sumJKOut + sumXOut + sumXKOut + sumROut + sumRKOut + sumHOut + sumHKOut; //暂估入库 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "暂估入库"; //发出商品 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "发出商品"; //实际结存 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "实际结存"; //空行 dt.Rows.Add(); i++; //副表项目 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "副表项目"; //dt.Rows[i]["佳图"] = "金额"; //dt.Rows[i]["佳图空"] = "累计金额"; //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; //销售成本 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "销售成本"; //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; //毛利率 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利率"; return dt; }
private void Reaserch_SelectedValueChanged(object sender, EventArgs e) { try { SqlDBConnect SDB = new SqlDBConnect(); s_ItemVal.Clear(); string strSql = "select ItemType as 基础数据类型,ItemVal as 选项数据 from T_SelItems where ItemType='{0}'";//"select * from T_SelItems where ItemType='{0}'"; strSql = string.Format(strSql, s_ItemType.Text.Trim()); DataSet ds = SDB.Get_Ds(strSql); dataGridView2.DataSource = ds.Tables[0]; int Lins = ds.Tables[0].Rows.Count; string[] match = new string[ds.Tables[0].Rows.Count]; for (int i = 0; i < match.Length; i++) { s_ItemVal.Text += ds.Tables[0].Rows[i]["选项数据"].ToString() + "\r\n";//回车换行 } } catch (Exception r) { MessageBox.Show(r.ToString()); } }
private DataTable GetDataTable() { //设置滚动条初始值 this.progressBar1.Maximum = 80; this.progressBar1.Value = 0; SqlDBConnect db = new SqlDBConnect(); dateTimeFrom = this.DateTimePickerFrom.Value.ToString("yyyy-MM-dd").Trim(); //"2011-07-01";// dateTimeTo = this.DateTimePickerTo.Value.ToString("yyyy-MM-dd").Trim(); // "2011-07-31";// string firstDayOfCurMonth = (new DateTime(DateTimePickerFrom.Value.Year, DateTimePickerFrom.Value.Month, 1)).ToString("yyyy-MM-dd").Trim();//当月第一天 //"2011-07-01";// string curWorkMonth = dateTimeFrom.Substring(0, 7); curWorkMonth = curWorkMonth.Remove(curWorkMonth.IndexOf('-'), 1); //当前工作月 //获取起始时间的前一天日期 string Tsql = "select convert(varchar(10),dateadd(day,-1,'" + dateTimeFrom + "'),120)"; string TimeTo = (new SqlDBConnect()).Ret_Single_val_Sql(Tsql).ToString(); DataTable dt = new DataTable(); DataColumn dc = new DataColumn("类别"); dc.Caption = "类别"; DataColumn dc1 = new DataColumn("佳图"); dc1.Caption = "佳图"; DataColumn dc2 = new DataColumn("欣图"); dc2.Caption = "欣图"; DataColumn dc3 = new DataColumn("瑞博"); dc3.Caption = "瑞博"; DataColumn dc4 = new DataColumn("信息"); dc4.Caption = "信息"; DataColumn dc5 = new DataColumn("合计"); dc5.Caption = "合计"; dt.Columns.Add(dc); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); int i = -1; //上日列帐 dt.Rows.Add(); i++; int recordnum = i; this.progressBar1.Value = i; //暂估入库 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region //暂估入库 double JAmountzg = 0.0, XAmountzg = 0.0, RAmountzg = 0.0, HAmountzg = 0.0; string Foreadsql = "select StoreHouseId ,SUM (FirstRoadMoney)Amount from T_Stock_Status where BalanceTime ='" + curWorkMonth + "'group by StoreHouseId "; DataTable dtzg = db.Get_Dt(Foreadsql); if (dtzg != null && dtzg.Rows.Count > 0) { foreach (DataRow dr in dtzg.Rows) { if (dr["StoreHouseId"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } string strsql0320 = "select SourceStoreH, SUM(Amount) Amount from T_Receipt_Main_Det where (OccurTime between '{0}' and '{1}') and (ReceiptTypeID ='03'or ReceiptTypeID='20') " + "Group by SourceStoreH"; strsql0320 = string.Format(strsql0320, firstDayOfCurMonth, TimeTo); DataTable dt0320 = db.Get_Dt(strsql0320); if (dt0320 != null && dt0320.Rows.Count > 0) { foreach (DataRow dr in dt0320.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmountzg += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } dt.Rows[i]["类别"] = "暂估入库"; dt.Rows[i]["佳图"] = JAmountzg.ToString("0.00"); dt.Rows[i]["欣图"] = XAmountzg.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmountzg.ToString("0.00"); dt.Rows[i]["信息"] = HAmountzg.ToString("0.00"); double Foread = JAmountzg + XAmountzg + RAmountzg + HAmountzg; dt.Rows[i]["合计"] = Foread.ToString("0.00"); #endregion //发出商品 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region //发出商品 double JCostsent = 0.0, XCostsent = 0.0, RCostsent = 0.0, HCostsent = 0.0; string Sentsql = "select StoreHouseId ,SUM (FirstOutMoney)Cost from T_Stock_Status where BalanceTime ='" + curWorkMonth + "'group by StoreHouseId "; DataTable dtsent = db.Get_Dt(Sentsql); if (dtsent != null && dtsent.Rows.Count > 0) { foreach (DataRow dr in dtsent.Rows) { if (dr["StoreHouseId"].ToString().Trim() == "J") { if (dr["Cost"].ToString().Trim() != "") JCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "X") { if (dr["Cost"].ToString().Trim() != "") XCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "R") { if (dr["Cost"].ToString().Trim() != "") RCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "H") { if (dr["Cost"].ToString().Trim() != "") HCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } } } string strsql7588 = "select SourceStoreH, SUM(TTaxPurchPrice) Cost from T_Receipt_Main_Det where (OccurTime between '{0}' and '{1}') and (ReceiptTypeID ='75'or ReceiptTypeID='88') " + "Group by SourceStoreH"; strsql7588 = string.Format(strsql7588, firstDayOfCurMonth, TimeTo); DataTable dt7588 = db.Get_Dt(strsql7588); if (dt7588 != null && dt7588.Rows.Count > 0) { foreach (DataRow dr in dt7588.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Cost"].ToString().Trim() != "") JCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Cost"].ToString().Trim() != "") XCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Cost"].ToString().Trim() != "") RCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Cost"].ToString().Trim() != "") HCostsent += Convert.ToDouble(dr["Cost"].ToString().Trim()); } } } dt.Rows[i]["类别"] = "发出商品"; dt.Rows[i]["佳图"] = JCostsent.ToString("0.00"); dt.Rows[i]["欣图"] = XCostsent.ToString("0.00"); dt.Rows[i]["瑞博"] = RCostsent.ToString("0.00"); dt.Rows[i]["信息"] = HCostsent.ToString("0.00"); double Sentout = JCostsent + XCostsent + RCostsent + HCostsent; dt.Rows[i]["合计"] = Sentout.ToString("0.00"); #endregion //实际结存 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region //实际结存 double JAmountjc = 0.0, XAmountjc = 0.0, RAmountjc = 0.0, HAmountjc = 0.0; string strsqlsr = "select SourceStoreH, SUM(TTaxPurchPrice) Amount from T_Receipt_Main_Det where (OccurTime between '{0}' and '{1}') " + "and (ReceiptTypeID ='01'or ReceiptTypeID='03'or ReceiptTypeID='04'or ReceiptTypeID='20') " + "Group by SourceStoreH"; strsqlsr = string.Format(strsqlsr, firstDayOfCurMonth, TimeTo); DataTable dtsr = db.Get_Dt(strsqlsr); if (dtsr != null && dtsr.Rows.Count > 0) { foreach (DataRow dr in dtsr.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } string strsqlfc = "select SourceStoreH, SUM(Amount) Amount from T_Receipt_Main_Det where (OccurTime between '{0}' and '{1}') " + "and (ReceiptTypeID ='51'or ReceiptTypeID='52'or ReceiptTypeID='54'or ReceiptTypeID='55'or ReceiptTypeID='56'" + "or ReceiptTypeID='75'or ReceiptTypeID='88'or ReceiptTypeID='90') " + "Group by SourceStoreH"; strsqlfc = string.Format(strsqlfc, firstDayOfCurMonth, TimeTo); DataTable dtfc = db.Get_Dt(strsqlfc); if (dtfc != null && dtfc.Rows.Count > 0) { foreach (DataRow dr in dtfc.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()) * -1; } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()) * -1; } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()) * -1; } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()) * -1; } } } string Stocksql = "select StoreHouseId ,SUM (FirstMoney)Amount from T_Stock_Status where BalanceTime ='" + curWorkMonth + "'group by StoreHouseId "; DataTable dtjc = db.Get_Dt(Stocksql); if (dtjc != null && dtjc.Rows.Count > 0) { foreach (DataRow dr in dtjc.Rows) { if (dr["StoreHouseId"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["StoreHouseId"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmountjc += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } dt.Rows[i]["类别"] = "实际结存"; dt.Rows[i]["佳图"] = JAmountjc.ToString("0.00"); dt.Rows[i]["欣图"] = XAmountjc.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmountjc.ToString("0.00"); dt.Rows[i]["信息"] = HAmountjc.ToString("0.00"); double Realstock = JAmountjc + XAmountjc + RAmountjc + HAmountjc; dt.Rows[i]["合计"] = Realstock.ToString("0.00"); #endregion #region//上日列账 dt.Rows[recordnum]["类别"] = "上日列帐"; dt.Rows[recordnum]["佳图"] = (JAmountjc + JCostsent - JAmountzg).ToString("0.00"); dt.Rows[recordnum]["欣图"] = (XAmountjc + XCostsent - XAmountzg).ToString("0.00"); dt.Rows[recordnum]["瑞博"] = (RAmountjc + RCostsent - RAmountzg).ToString("0.00"); dt.Rows[recordnum]["信息"] = (HAmountjc + HCostsent - HAmountzg).ToString("0.00"); dt.Rows[recordnum]["合计"] = (Realstock + Sentout - Foread).ToString("0.00"); #endregion //空行 dt.Rows.Add(); i++; this.progressBar1.Value = i; //01-进货单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "01-进货单"; #region 01-进货单 double JAmount01 = 0.0, XAmount01 = 0.0, RAmount01 = 0.0, HAmount01 = 0.0; double JNotTax01 = 0.0, XNotTax01 = 0.0, RNotTax01 = 0.0, HNotTax01 = 0.0; double JTax01 = 0.0, XTax01 = 0.0, RTax01 = 0.0, HTax01 = 0.0; double JCost01 = 0.0, XCost01 = 0.0, RCost01 = 0.0, HCost01 = 0.0; string sql01 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '01' and (OccurTime between '{0}' and '{1}')"; sql01 = string.Format(sql01, dateTimeFrom, dateTimeTo); DataTable dt01 = db.Get_Dt(sql01); if (dt01 != null && dt01.Rows.Count > 0) { foreach (DataRow dr in dt01.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") JNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") JTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") XNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") XTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") RNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") RTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount01 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["NotTax"].ToString().Trim() != "") HNotTax01 += Convert.ToDouble(dr["NotTax"].ToString().Trim()); if (dr["Tax"].ToString().Trim() != "") HTax01 += Convert.ToDouble(dr["Tax"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost01 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //含税金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "含税金额"; dt.Rows[i]["佳图"] = JAmount01.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount01.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount01.ToString("0.00"); dt.Rows[i]["信息"] = HAmount01.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount01 + XAmount01 + RAmount01 + HAmount01).ToString("0.00"); //不含税金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "不含税金额"; dt.Rows[i]["佳图"] = JNotTax01.ToString("0.00"); dt.Rows[i]["欣图"] = XNotTax01.ToString("0.00"); dt.Rows[i]["瑞博"] = RNotTax01.ToString("0.00"); dt.Rows[i]["信息"] = HNotTax01.ToString("0.00"); dt.Rows[i]["合计"] = (JNotTax01 + XNotTax01 + RNotTax01 + HNotTax01).ToString("0.00"); //税额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "税额"; dt.Rows[i]["佳图"] = JTax01.ToString("0.00"); dt.Rows[i]["欣图"] = XTax01.ToString("0.00"); dt.Rows[i]["瑞博"] = RTax01.ToString("0.00"); dt.Rows[i]["信息"] = HTax01.ToString("0.00"); dt.Rows[i]["合计"] = (JTax01 + XTax01 + RTax01 + HTax01).ToString("0.00"); //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount01.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount01.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount01.ToString("0.00"); dt.Rows[i]["信息"] = HAmount01.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount01 + XAmount01 + RAmount01 + HAmount01).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JAmount01.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount01.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount01.ToString("0.00"); dt.Rows[i]["信息"] = HAmount01.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount01 + XAmount01 + RAmount01 + HAmount01).ToString("0.00"); #endregion //03-假设进货单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "03-假设进货单"; #region 03-假设进货单 double JAmount03 = 0.0, XAmount03 = 0.0, RAmount03 = 0.0, HAmount03 = 0.0; double JCost03 = 0.0, XCost03 = 0.0, RCost03 = 0.0, HCost03 = 0.0; string sql03 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '03' and (OccurTime between '{0}' and '{1}')"; sql03 = string.Format(sql03, dateTimeFrom, dateTimeTo); DataTable dt03 = db.Get_Dt(sql03); if (dt03 != null && dt03.Rows.Count > 0) { foreach (DataRow dr in dt03.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount03 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost03 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount03.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount03.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount03.ToString("0.00"); dt.Rows[i]["信息"] = HAmount03.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount03 + XAmount03 + RAmount03 + HAmount03).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JAmount03.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount03.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount03.ToString("0.00"); dt.Rows[i]["信息"] = HAmount03.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount03 + XAmount03 + RAmount03 + HAmount03).ToString("0.00"); #endregion //04-盈亏单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "04-盈亏单"; #region 04-盈亏单 double JCost04 = 0.0, XCost04 = 0.0, RCost04 = 0.0, HCost04 = 0.0; string sql04 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '04' and (OccurTime between '{0}' and '{1}')"; sql04 = string.Format(sql04, dateTimeFrom, dateTimeTo); DataTable dt04 = db.Get_Dt(sql04); if (dt04 != null && dt04.Rows.Count > 0) { foreach (DataRow dr in dt04.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HCost04 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost04.ToString("0.00"); dt.Rows[i]["欣图"] = XCost04.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost04.ToString("0.00"); dt.Rows[i]["信息"] = HCost04.ToString("0.00"); dt.Rows[i]["合计"] = (JCost04 + XCost04 + RCost04 + HCost04).ToString("0.00"); #endregion //20-假设结账单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "20-假设结账单"; #region 20-假设结账单 double JCost20 = 0.0, XCost20 = 0.0, RCost20 = 0.0, HCost20 = 0.0; string sql20 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '20' and (OccurTime between '{0}' and '{1}')"; sql20 = string.Format(sql20, dateTimeFrom, dateTimeTo); DataTable dt20 = db.Get_Dt(sql20); if (dt20 != null && dt20.Rows.Count > 0) { foreach (DataRow dr in dt20.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HCost20 += Convert.ToDouble(dr["Amount"].ToString().Trim()); } } } //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost20.ToString("0.00"); dt.Rows[i]["欣图"] = XCost20.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost20.ToString("0.00"); dt.Rows[i]["信息"] = HCost20.ToString("0.00"); dt.Rows[i]["合计"] = (JCost20 + XCost20 + RCost20 + HCost20).ToString("0.00"); #endregion //收入小计 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region 收入小计 double sumJIn = JAmount01 + JAmount03 + JCost04 + JCost20; double sumXIn = XAmount01 + XAmount03 + XCost04 + XCost20; double sumRIn = RAmount01 + RAmount03 + RCost04 + RCost20; double sumHIn = HAmount01 + HAmount03 + HCost04 + HCost20; dt.Rows[i]["类别"] = "收入小计"; dt.Rows[i]["佳图"] = sumJIn.ToString("0.00"); dt.Rows[i]["欣图"] = sumXIn.ToString("0.00"); dt.Rows[i]["瑞博"] = sumRIn.ToString("0.00"); dt.Rows[i]["信息"] = sumHIn.ToString("0.00"); dt.Rows[i]["合计"] = (sumJIn + sumXIn + sumRIn + sumHIn).ToString("0.00"); #endregion //空行 dt.Rows.Add(); i++; this.progressBar1.Value = i; //51-销售单1 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "51-销售单1"; #region 51-销售单1 double JAmount51 = 0.0, XAmount51 = 0.0, RAmount51 = 0.0, HAmount51 = 0.0; double JCost51 = 0.0, XCost51 = 0.0, RCost51 = 0.0, HCost51 = 0.0; string sql51 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '51' and (OccurTime between '{0}' and '{1}')"; sql51 = string.Format(sql51, dateTimeFrom, dateTimeTo); DataTable dt51 = db.Get_Dt(sql51); if (dt51 != null && dt51.Rows.Count > 0) { foreach (DataRow dr in dt51.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount51 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost51 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount51.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount51.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount51.ToString("0.00"); dt.Rows[i]["信息"] = HAmount51.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount51 + XAmount51 + RAmount51 + HAmount51).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost51.ToString("0.00"); dt.Rows[i]["欣图"] = XCost51.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost51.ToString("0.00"); dt.Rows[i]["信息"] = HCost51.ToString("0.00"); dt.Rows[i]["合计"] = (JCost51 + XCost51 + RCost51 + HCost51).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount51 - JCost51).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount51 - XCost51).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount51 - RCost51).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount51 - HCost51).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount51 - JCost51 + XAmount51 - XCost51 + RAmount51 - RCost51 + HAmount51 - HCost51).ToString("0.00"); //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount51Add = 0.0, XAmount51Add = 0.0, RAmount51Add = 0.0, HAmount51Add = 0.0; double JCost51Add = 0.0, XCost51Add = 0.0, RCost51Add = 0.0, HCost51Add = 0.0; string sql51Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '51' and (OccurTime between '{0}' and '{1}')"; sql51Add = string.Format(sql51Add, firstDayOfCurMonth, dateTimeTo); DataTable dt51Add = db.Get_Dt(sql51Add); if (dt51Add != null && dt51Add.Rows.Count > 0) { foreach (DataRow dr in dt51Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount51Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost51Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount51Add.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount51Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount51Add.ToString("0.00"); dt.Rows[i]["信息"] = HAmount51Add.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount51Add + XAmount51Add + RAmount51Add + HAmount51Add).ToString("0.00"); //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost51Add.ToString("0.00"); dt.Rows[i]["欣图"] = XCost51Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost51Add.ToString("0.00"); dt.Rows[i]["信息"] = HCost51Add.ToString("0.00"); dt.Rows[i]["合计"] = (JCost51Add + XCost51Add + RCost51Add + HCost51Add).ToString("0.00"); //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = (JAmount51Add - JCost51Add).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount51Add - XCost51Add).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount51Add - RCost51Add).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount51Add - HCost51Add).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount51Add - JCost51Add + XAmount51Add - XCost51Add + RAmount51Add - RCost51Add + HAmount51Add - HCost51Add).ToString("0.00"); #endregion //52-销售单2 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "52-销售单2"; #region 52-销售单2 double JAmount52 = 0.0, XAmount52 = 0.0, RAmount52 = 0.0, HAmount52 = 0.0; double JCost52 = 0.0, XCost52 = 0.0, RCost52 = 0.0, HCost52 = 0.0; string sql52 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '52' and (OccurTime between '{0}' and '{1}')"; sql52 = string.Format(sql52, dateTimeFrom, dateTimeTo); DataTable dt52 = db.Get_Dt(sql52); if (dt52 != null && dt52.Rows.Count > 0) { foreach (DataRow dr in dt52.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount52 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost52 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount52.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount52.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount52.ToString("0.00"); dt.Rows[i]["信息"] = HAmount52.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount52 + XAmount52 + RAmount52 + HAmount52).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost52.ToString("0.00"); dt.Rows[i]["欣图"] = XCost52.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost52.ToString("0.00"); dt.Rows[i]["信息"] = HCost52.ToString("0.00"); dt.Rows[i]["合计"] = (JCost52 + XCost52 + RCost52 + HCost52).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount52 - JCost52).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount52 - XCost52).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount52 - RCost52).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount52 - HCost52).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount52 - JCost52 + XAmount52 - XCost52 + RAmount52 - RCost52 + HAmount52 - HCost52).ToString("0.00"); //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount52Add = 0.0, XAmount52Add = 0.0, RAmount52Add = 0.0, HAmount52Add = 0.0; double JCost52Add = 0.0, XCost52Add = 0.0, RCost52Add = 0.0, HCost52Add = 0.0; string sql52Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '52' and (OccurTime between '{0}' and '{1}')"; sql52Add = string.Format(sql52Add, firstDayOfCurMonth, dateTimeTo); DataTable dt52Add = db.Get_Dt(sql52Add); if (dt52Add != null && dt52Add.Rows.Count > 0) { foreach (DataRow dr in dt52Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount52Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost52Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount52Add.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount52Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount52Add.ToString("0.00"); dt.Rows[i]["信息"] = HAmount52Add.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount52Add + XAmount52Add + RAmount52Add + HAmount52Add).ToString("0.00"); //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost52Add.ToString("0.00"); dt.Rows[i]["欣图"] = XCost52Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost52Add.ToString("0.00"); dt.Rows[i]["信息"] = HCost52Add.ToString("0.00"); dt.Rows[i]["合计"] = (JCost52Add + XCost52Add + RCost52Add + HCost52Add).ToString("0.00"); //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = (JAmount52Add - JCost52Add).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount52Add - XCost52Add).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount52Add - RCost52Add).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount52Add - HCost52Add).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount52Add - JCost52Add + XAmount52Add - XCost52Add + RAmount52Add - RCost52Add + HAmount52Add - HCost52Add).ToString("0.00"); #endregion //53-调拨单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "53-调拨单"; #region 53-调拨单 double JAmount53 = 0.0, XAmount53 = 0.0, RAmount53 = 0.0, HAmount53 = 0.0; double JCost53 = 0.0, XCost53 = 0.0, RCost53 = 0.0, HCost53 = 0.0; string sql53 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '53' and (OccurTime between '{0}' and '{1}')"; sql53 = string.Format(sql53, dateTimeFrom, dateTimeTo); DataTable dt53 = db.Get_Dt(sql53); if (dt53 != null && dt53.Rows.Count > 0) { foreach (DataRow dr in dt53.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount53 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost53 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount53.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount53.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount53.ToString("0.00"); dt.Rows[i]["信息"] = HAmount53.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount53 + XAmount53 + RAmount53 + HAmount53).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost53.ToString("0.00"); dt.Rows[i]["欣图"] = XCost53.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost53.ToString("0.00"); dt.Rows[i]["信息"] = HCost53.ToString("0.00"); dt.Rows[i]["合计"] = (JCost53 + XCost53 + RCost53 + HCost53).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount53 - JCost53).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount53 - XCost53).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount53 - RCost53).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount53 - HCost53).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount53 - JCost53 + XAmount53 - XCost53 + RAmount53 - RCost53 + HAmount53 - HCost53).ToString("0.00"); #endregion //54-销售单4 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "54-销售单4"; #region 54-销售单4 double JAmount54 = 0.0, XAmount54 = 0.0, RAmount54 = 0.0, HAmount54 = 0.0; double JCost54 = 0.0, XCost54 = 0.0, RCost54 = 0.0, HCost54 = 0.0; string sql54 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '54' and (OccurTime between '{0}' and '{1}')"; sql54 = string.Format(sql54, dateTimeFrom, dateTimeTo); DataTable dt54 = db.Get_Dt(sql54); if (dt54 != null && dt54.Rows.Count > 0) { foreach (DataRow dr in dt54.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount54 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost54 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount54.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount54.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount54.ToString("0.00"); dt.Rows[i]["信息"] = HAmount54.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount54 + XAmount54 + RAmount54 + HAmount54).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost54.ToString("0.00"); dt.Rows[i]["欣图"] = XCost54.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost54.ToString("0.00"); dt.Rows[i]["信息"] = HCost54.ToString("0.00"); dt.Rows[i]["合计"] = (JCost54 + XCost54 + RCost54 + HCost54).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount54 - JCost54).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount54 - XCost54).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount54 - RCost54).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount54 - HCost54).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount54 - JCost54 + XAmount54 - XCost54 + RAmount54 - RCost54 + HAmount54 - HCost54).ToString("0.00"); //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount54Add = 0.0, XAmount54Add = 0.0, RAmount54Add = 0.0, HAmount54Add = 0.0; double JCost54Add = 0.0, XCost54Add = 0.0, RCost54Add = 0.0, HCost54Add = 0.0; string sql54Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '54' and (OccurTime between '{0}' and '{1}')"; sql54Add = string.Format(sql54Add, firstDayOfCurMonth, dateTimeTo); DataTable dt54Add = db.Get_Dt(sql54Add); if (dt54Add != null && dt54Add.Rows.Count > 0) { foreach (DataRow dr in dt54Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount54Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost54Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount54Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost54Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount54Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost54Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount54Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost54Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount54Add.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount54Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount54Add.ToString("0.00"); dt.Rows[i]["信息"] = HAmount54Add.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount54Add + XAmount54Add + RAmount54Add + HAmount54Add).ToString("0.00"); //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost54Add.ToString("0.00"); dt.Rows[i]["欣图"] = XCost54Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost54Add.ToString("0.00"); dt.Rows[i]["信息"] = HCost54Add.ToString("0.00"); dt.Rows[i]["合计"] = (JCost54Add + XCost54Add + RCost54Add + HCost54Add).ToString("0.00"); //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = (JAmount54Add - JCost54Add).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount54Add - XCost54Add).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount54Add - RCost54Add).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount54Add - HCost54Add).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount54Add - JCost54Add + XAmount54Add - XCost54Add + RAmount54Add - RCost54Add + HAmount54Add - HCost54Add).ToString("0.00"); #endregion //55-销售单3 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "55-销售单3"; #region 55-销售单3 double JAmount55 = 0.0, XAmount55 = 0.0, RAmount55 = 0.0, HAmount55 = 0.0; double JCost55 = 0.0, XCost55 = 0.0, RCost55 = 0.0, HCost55 = 0.0; string sql55 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '55' and (OccurTime between '{0}' and '{1}')"; sql55 = string.Format(sql55, dateTimeFrom, dateTimeTo); DataTable dt55 = db.Get_Dt(sql55); if (dt55 != null && dt55.Rows.Count > 0) { foreach (DataRow dr in dt55.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount55 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost55 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount55.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount55.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount55.ToString("0.00"); dt.Rows[i]["信息"] = HAmount55.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount55 + XAmount55 + RAmount55 + HAmount55).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost55.ToString("0.00"); dt.Rows[i]["欣图"] = XCost55.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost55.ToString("0.00"); dt.Rows[i]["信息"] = HCost55.ToString("0.00"); dt.Rows[i]["合计"] = (JCost55 + XCost55 + RCost55 + HCost55).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount55 - JCost55).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount55 - XCost55).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount55 - RCost55).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount55 - HCost55).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount55 - JCost55 + XAmount55 - XCost55 + RAmount55 - RCost55 + HAmount55 - HCost55).ToString("0.00"); //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount55Add = 0.0, XAmount55Add = 0.0, RAmount55Add = 0.0, HAmount55Add = 0.0; double JCost55Add = 0.0, XCost55Add = 0.0, RCost55Add = 0.0, HCost55Add = 0.0; string sql55Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '55' and (OccurTime between '{0}' and '{1}')"; sql55Add = string.Format(sql55Add, firstDayOfCurMonth, dateTimeTo); DataTable dt55Add = db.Get_Dt(sql55Add); if (dt55Add != null && dt55Add.Rows.Count > 0) { foreach (DataRow dr in dt55Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount55Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost55Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount55Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost55Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount55Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost55Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount55Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost55Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount55Add.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount55Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount55Add.ToString("0.00"); dt.Rows[i]["信息"] = HAmount55Add.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount55Add + XAmount55Add + RAmount55Add + HAmount55Add).ToString("0.00"); //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost55Add.ToString("0.00"); dt.Rows[i]["欣图"] = XCost55Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost55Add.ToString("0.00"); dt.Rows[i]["信息"] = HCost55Add.ToString("0.00"); dt.Rows[i]["合计"] = (JCost55Add + XCost55Add + RCost55Add + HCost55Add).ToString("0.00"); //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = (JAmount55Add - JCost55Add).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount55Add - XCost55Add).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount55Add - RCost55Add).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount55Add - HCost55Add).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount55Add - JCost55Add + XAmount55Add - XCost55Add + RAmount55Add - RCost55Add + HAmount55Add - HCost55Add).ToString("0.00"); #endregion //56-销售单5 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "56-销售单5"; #region 56-销售单5 double JAmount56 = 0.0, XAmount56 = 0.0, RAmount56 = 0.0, HAmount56 = 0.0; double JCost56 = 0.0, XCost56 = 0.0, RCost56 = 0.0, HCost56 = 0.0; string sql56 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '56' and (OccurTime between '{0}' and '{1}')"; sql56 = string.Format(sql56, dateTimeFrom, dateTimeTo); DataTable dt56 = db.Get_Dt(sql56); if (dt56 != null && dt56.Rows.Count > 0) { foreach (DataRow dr in dt56.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount56 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost56 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount56.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount56.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount56.ToString("0.00"); dt.Rows[i]["信息"] = HAmount56.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount56 + XAmount56 + RAmount56 + HAmount56).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost56.ToString("0.00"); dt.Rows[i]["欣图"] = XCost56.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost56.ToString("0.00"); dt.Rows[i]["信息"] = HCost56.ToString("0.00"); dt.Rows[i]["合计"] = (JCost56 + XCost56 + RCost56 + HCost56).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount56 - JCost56).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount56 - XCost56).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount56 - RCost56).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount56 - HCost56).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount56 - JCost56 + XAmount56 - XCost56 + RAmount56 - RCost56 + HAmount56 - HCost56).ToString("0.00"); //求“当月第1天”到“开始时间” 价税合计、成本金额、毛利 double JAmount56Add = 0.0, XAmount56Add = 0.0, RAmount56Add = 0.0, HAmount56Add = 0.0; double JCost56Add = 0.0, XCost56Add = 0.0, RCost56Add = 0.0, HCost56Add = 0.0; string sql56Add = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '56' and (OccurTime between '{0}' and '{1}')"; sql56Add = string.Format(sql56Add, firstDayOfCurMonth, dateTimeTo); DataTable dt56Add = db.Get_Dt(sql56Add); if (dt56Add != null && dt56Add.Rows.Count > 0) { foreach (DataRow dr in dt56Add.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount56Add += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost56Add += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //累计:价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:价税合计"; dt.Rows[i]["佳图"] = JAmount56Add.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount56Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount56Add.ToString("0.00"); dt.Rows[i]["信息"] = HAmount56Add.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount56Add + XAmount56Add + RAmount56Add + HAmount56Add).ToString("0.00"); //累计:成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:成本金额"; dt.Rows[i]["佳图"] = JCost56Add.ToString("0.00"); dt.Rows[i]["欣图"] = XCost56Add.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost56Add.ToString("0.00"); dt.Rows[i]["信息"] = HCost56Add.ToString("0.00"); dt.Rows[i]["合计"] = (JCost56Add + XCost56Add + RCost56Add + HCost56Add).ToString("0.00"); //累计:毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "累计:毛利"; dt.Rows[i]["佳图"] = (JAmount56Add - JCost56Add).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount56Add - XCost56Add).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount56Add - RCost56Add).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount56Add - HCost56Add).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount56Add - JCost56Add + XAmount56Add - XCost56Add + RAmount56Add - RCost56Add + HAmount56Add - HCost56Add).ToString("0.00"); #endregion //75-借用单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "75-借用单"; #region 75-借用单 double JAmount75 = 0.0, XAmount75 = 0.0, RAmount75 = 0.0, HAmount75 = 0.0; double JCost75 = 0.0, XCost75 = 0.0, RCost75 = 0.0, HCost75 = 0.0; string sql75 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '75' and (OccurTime between '{0}' and '{1}')"; sql75 = string.Format(sql75, dateTimeFrom, dateTimeTo); DataTable dt75 = db.Get_Dt(sql75); if (dt75 != null && dt75.Rows.Count > 0) { foreach (DataRow dr in dt75.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount75 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost75 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount75.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount75.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount75.ToString("0.00"); dt.Rows[i]["信息"] = HAmount75.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount75 + XAmount75 + RAmount75 + HAmount75).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost75.ToString("0.00"); dt.Rows[i]["欣图"] = XCost75.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost75.ToString("0.00"); dt.Rows[i]["信息"] = HCost75.ToString("0.00"); dt.Rows[i]["合计"] = (JCost75 + XCost75 + RCost75 + HCost75).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount75 - JCost75).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount75 - XCost75).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount75 - RCost75).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount75 - HCost75).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount75 - JCost75 + XAmount75 - XCost75 + RAmount75 - RCost75 + HAmount75 - HCost75).ToString("0.00"); #endregion //88-租机单 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "88-租机单"; #region 88-租机单 double JAmount88 = 0.0, XAmount88 = 0.0, RAmount88 = 0.0, HAmount88 = 0.0; double JCost88 = 0.0, XCost88 = 0.0, RCost88 = 0.0, HCost88 = 0.0; string sql88 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '88' and (OccurTime between '{0}' and '{1}')"; sql88 = string.Format(sql88, dateTimeFrom, dateTimeTo); DataTable dt88 = db.Get_Dt(sql88); if (dt88 != null && dt88.Rows.Count > 0) { foreach (DataRow dr in dt88.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["Amount"].ToString().Trim() != "") JAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["Amount"].ToString().Trim() != "") XAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["Amount"].ToString().Trim() != "") RAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["Amount"].ToString().Trim() != "") HAmount88 += Convert.ToDouble(dr["Amount"].ToString().Trim()); if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost88 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //价税合计 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "价税合计"; dt.Rows[i]["佳图"] = JAmount88.ToString("0.00"); dt.Rows[i]["欣图"] = XAmount88.ToString("0.00"); dt.Rows[i]["瑞博"] = RAmount88.ToString("0.00"); dt.Rows[i]["信息"] = HAmount88.ToString("0.00"); dt.Rows[i]["合计"] = (JAmount88 + XAmount88 + RAmount88 + HAmount88).ToString("0.00"); //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost88.ToString("0.00"); dt.Rows[i]["欣图"] = XCost88.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost88.ToString("0.00"); dt.Rows[i]["信息"] = HCost88.ToString("0.00"); dt.Rows[i]["合计"] = (JCost88 + XCost88 + RCost88 + HCost88).ToString("0.00"); //毛利 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "毛利"; dt.Rows[i]["佳图"] = (JAmount88 - JCost88).ToString("0.00"); dt.Rows[i]["欣图"] = (XAmount88 - XCost88).ToString("0.00"); dt.Rows[i]["瑞博"] = (RAmount88 - RCost88).ToString("0.00"); dt.Rows[i]["信息"] = (HAmount88 - HCost88).ToString("0.00"); dt.Rows[i]["合计"] = (JAmount88 - JCost88 + XAmount88 - XCost88 + RAmount88 - RCost88 + HAmount88 - HCost88).ToString("0.00"); #endregion //90-暂估结账销售 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "90-暂估结账销售"; #region 90-暂估结账销售 double JCost90 = 0.0, XCost90 = 0.0, RCost90 = 0.0, HCost90 = 0.0; string sql90 = "select OccurTime, SourceStoreH, num, price, Amount,NotTax,Tax,STaxPurchPrice,TTaxPurchPrice from T_Receipt_Main_Det " + "where ReceiptTypeID = '90' and (OccurTime between '{0}' and '{1}')"; sql90 = string.Format(sql90, dateTimeFrom, dateTimeTo); DataTable dt90 = db.Get_Dt(sql90); if (dt90 != null && dt90.Rows.Count > 0) { foreach (DataRow dr in dt90.Rows) { if (dr["SourceStoreH"].ToString().Trim() == "J") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") JCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "X") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") XCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "R") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") RCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } if (dr["SourceStoreH"].ToString().Trim() == "H") { if (dr["TTaxPurchPrice"].ToString().Trim() != "") HCost90 += Convert.ToDouble(dr["TTaxPurchPrice"].ToString().Trim()); } } } //成本金额 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "成本金额"; dt.Rows[i]["佳图"] = JCost90.ToString("0.00"); dt.Rows[i]["欣图"] = XCost90.ToString("0.00"); dt.Rows[i]["瑞博"] = RCost90.ToString("0.00"); dt.Rows[i]["信息"] = HCost90.ToString("0.00"); dt.Rows[i]["合计"] = (JCost90 + XCost90 + RCost90 + HCost90).ToString("0.00"); #endregion //发出小计 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region 发出小计 double sumJOut = JCost51 + JCost52 + JCost54 + JCost55 + JCost56 + JCost75 + JCost88 + JCost90; double sumXOut = XCost51 + XCost52 + XCost54 + XCost55 + XCost56 + XCost75 + XCost88 + XCost90; double sumROut = RCost51 + RCost52 + RCost54 + RCost55 + RCost56 + RCost75 + RCost88 + RCost90; double sumHOut = HCost51 + HCost52 + HCost54 + HCost55 + HCost56 + HCost75 + HCost88 + HCost90; dt.Rows[i]["类别"] = "发出小计"; dt.Rows[i]["佳图"] = sumJOut.ToString("0.00"); dt.Rows[i]["欣图"] = sumXOut.ToString("0.00"); dt.Rows[i]["瑞博"] = sumROut.ToString("0.00"); dt.Rows[i]["信息"] = sumHOut.ToString("0.00"); dt.Rows[i]["合计"] = (sumJOut + sumXOut + sumROut + sumHOut).ToString("0.00"); #endregion //空行 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region//本日列帐 dt.Rows.Add(); i++; dt.Rows[i]["类别"] = "本日列帐"; double Na = JAmountjc + JCostsent - JAmountzg + JAmount01 + JCost04 - sumJOut + JCost75 + JCost88; double Nc = XAmountjc + XCostsent - XAmountzg + XAmount01 + XCost04 - sumXOut + XCost75 + XCost88; double Ne = RAmountjc + RCostsent - RAmountzg + RAmount01 + RCost04 - sumROut + RCost75 + RCost88; double Ng = HAmountjc + HCostsent - HAmountzg + HAmount01 + HCost04 - sumHOut + HCost75 + HCost88; dt.Rows[i]["佳图"] = Na.ToString("0.00"); dt.Rows[i]["欣图"] = Nc.ToString("0.00"); dt.Rows[i]["瑞博"] = Ne.ToString("0.00"); dt.Rows[i]["信息"] = Ng.ToString("0.00"); dt.Rows[i]["合计"] = (Na + Nc + Ne + Ng).ToString("0.00"); #endregion //暂估入库 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region//暂估入库 double Za = JAmountzg + JAmount03 + JCost20; double Zc = XAmountzg + XAmount03 + XCost20; double Ze = RAmountzg + RAmount03 + RCost20; double Zg = HAmountzg + HAmount03 + HCost20; dt.Rows[i]["类别"] = "暂估入库"; dt.Rows[i]["佳图"] = Za.ToString("0.00"); dt.Rows[i]["欣图"] = Zc.ToString("0.00"); dt.Rows[i]["瑞博"] = Ze.ToString("0.00"); dt.Rows[i]["信息"] = Zg.ToString("0.00"); dt.Rows[i]["合计"] = (Za + Zc + Ze + Zg).ToString("0.00"); #endregion //发出商品 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region//发出商品 double Senta = JCostsent + JCost75 + JCost88; double Sentc = XCostsent + XCost75 + XCost88; double Sente = RCostsent + RCost75 + RCost88; double Sentg = HCostsent + HCost75 + HCost88; dt.Rows[i]["类别"] = "发出商品"; dt.Rows[i]["佳图"] = Senta.ToString("0.00"); dt.Rows[i]["欣图"] = Sentc.ToString("0.00"); dt.Rows[i]["瑞博"] = Sente.ToString("0.00"); dt.Rows[i]["信息"] = Sentg.ToString("0.00"); dt.Rows[i]["合计"] = (Senta + Sentc + Sente + Sentg).ToString("0.00"); #endregion //实际结存 dt.Rows.Add(); i++; this.progressBar1.Value = i; #region//实际结存 double Rsa = JAmountjc + sumJIn - sumJOut; double Rsc = XAmountjc + sumXIn - sumXOut; double Rse = RAmountjc + sumRIn - sumROut; double Rsg = HAmountjc + sumHIn - sumHOut; dt.Rows[i]["类别"] = "实际结存"; dt.Rows[i]["佳图"] = Rsa.ToString("0.00"); dt.Rows[i]["欣图"] = Rsc.ToString("0.00"); dt.Rows[i]["瑞博"] = Rse.ToString("0.00"); dt.Rows[i]["信息"] = Rsg.ToString("0.00"); dt.Rows[i]["合计"] = (Rsa + Rsc + Rse + Rsg).ToString("0.00"); #endregion //空行 dt.Rows.Add(); i++; this.progressBar1.Value = i; //副表项目 #region 副表项目 dt.Rows.Add(); i++; this.progressBar1.Value = i; dt.Rows[i]["类别"] = "副表项目"; dt.Rows[i]["佳图"] = "金额 "; dt.Rows[i]["欣图"] = "含税金额 "; dt.Rows.Add(); i++; this.progressBar1.Value = i; //价税合计 #region//价税合计(金额) double Jsa = JAmount51 + JAmount52 + JAmount56; double Jsc = XAmount51 + XAmount52 + XAmount56; double Jse = RAmount51 + RAmount52 + RAmount56; double Jsg = HAmount51 + HAmount52 + HAmount56; dt.Rows[i]["类别"] = "价税合计"; double JSamount = Jsa + Jsc + Jse + Jsg; dt.Rows[i]["佳图"] = JSamount.ToString("0.00"); #endregion #region//价税合计( 累计金额) double Jsaa = JAmount51Add + JAmount52Add + JAmount56Add; double Jscc = XAmount51Add + XAmount52Add + XAmount56Add; double Jsee = RAmount51Add + RAmount52Add + RAmount56Add; double Jsgg = HAmount51Add + HAmount52Add + HAmount56Add; double LJSamount = Jsaa + Jscc + Jsee + Jsgg; dt.Rows[i]["欣图"] = (LJSamount).ToString("0.00"); #endregion dt.Rows.Add(); i++; this.progressBar1.Value = i; //销售成本 #region//销售成本(金额) double Ssa = JCost51 + JCost52 + JCost54 + JCost55 + JCost56 + JCost90; double Ssc = XCost51 + XCost52 + XCost54 + XCost55 + XCost56 + XCost90; double Sse = RCost51 + RCost52 + RCost54 + RCost55 + RCost56 + RCost90; double Ssg = HCost51 + HCost52 + HCost54 + HCost55 + HCost56 + HCost90; dt.Rows[i]["类别"] = "销售成本"; dt.Rows[i]["佳图"] = (Ssa + Ssc + Sse + Ssg).ToString("0.00"); #endregion #region//销售成本(含税金额) double Ssaa = JCost51Add + JCost52Add + JCost54Add + JCost55Add + JCost56Add + JCost90; double Sscc = XCost51Add + XCost52Add + XCost54Add + XCost55Add + XCost56Add + XCost90; double Ssee = RCost51Add + RCost52Add + RCost54Add + RCost55Add + RCost56Add + RCost90; double Ssgg = HCost51Add + HCost52Add + HCost54Add + HCost55Add + HCost56Add + HCost90; dt.Rows[i]["欣图"] = (Ssaa + Sscc + Ssee + Ssgg).ToString("0.00"); #endregion dt.Rows.Add(); i++; this.progressBar1.Value = i; //毛利 #region//毛利(金额) double Mla = Jsa - Ssa; double Mlc = Jsc - Ssc; double Mle = Jse - Sse; double Mlg = Jsg - Ssg; dt.Rows[i]["类别"] = "毛利"; double LVamount = Mla + Mlc + Mle + Mlg; dt.Rows[i]["佳图"] = LVamount.ToString("0.00"); #endregion #region//毛利(含税金额) double Mlaa = Jsa - Ssa; double Mlcc = Jsc - Ssc; double Mlee = Jse - Sse; double Mlgg = Jsg - Ssg; double LLVamount = Mlaa + Mlcc + Mlee + Mlgg; dt.Rows[i]["欣图"] = LLVamount.ToString("0.00"); #endregion dt.Rows.Add(); i++; this.progressBar1.Value = i; //毛利率 #region//毛利率(金额) dt.Rows[i]["类别"] = "毛利率"; dt.Rows[i]["佳图"] = (LVamount / JSamount * 100).ToString("#0.#0") + "%"; #endregion #region//毛利率 dt.Rows[i]["欣图"] = (LLVamount / LJSamount * 100).ToString("#0.#0") + "%"; #endregion #endregion this.progressBar1.Value = 0; return dt; }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { //以中文字段名显示 //Return_Sql = "select * from " + tableName + " where "; //英文字段名 //for (int i = 0; i < lb_sql.Items.Count; i++) //{ // Return_Sql += " " + lb_sql.Items[i].ToString().Trim(); //} Return_Sql = ""; if (lb_sql.Items.Count > 0) { if (this.strSql.Contains(" where ")) Return_Sql += this.strSql + " and "; else Return_Sql += this.strSql + " where "; for (int i = 0; i < lb_sql.Items.Count; i++) { Return_Sql += " " + lb_sql.Items[i].ToString().Trim(); } } else Return_Sql = this.strSql; try { SqlDBConnect db = new SqlDBConnect(); DataTable dt = new DataTable(); dt = db.Get_Dt(Return_Sql); if (dt == null || dt.Rows.Count <= 0) { MessageBox.Show("没有符合条件的记录存在!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } InitFuncs initFuncs = new InitFuncs(); initFuncs.InitDataGridView(this.dataGridView, dt); this.Height = 450; } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\n" + Return_Sql, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 将selectsql_查询语句执行结果,绑定到pa中Name属性指定了值的控件上 /// </summary> /// <param name="Pa"></param> /// <param name="selectsql_"></param> public void ShowDatas(Panel Pa, string selectsql_) { SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(selectsql_); string filename_ = "", stmp = "", lx_, str = ""; string fiel_ = ""; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) //行 { for (int i = 0; i <= dt.Columns.Count - 1; i++) //列 { filename_ = dt.Columns[i].ColumnName.ToLower().Trim(); foreach (Control o in Pa.Controls) { if (o is TextBox) { stmp = ((TextBox)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); if ((lx_ != "s_") && (lx_ != "n_")) { continue; //其余控件不处理 } if (fiel_.ToLower() == filename_) { if (dr[filename_] is DBNull) { ((TextBox)o).Text = ""; } else { ((TextBox)o).Text = dr[filename_].ToString().Trim(); } break; } } if (o is ComboBox) { stmp = ((ComboBox)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); //if ((lx_ != "s_") && (lx_ != "n_")) continue; //其余控件不处理 if (fiel_.ToLower() == filename_) { if (dr[filename_] is DBNull) { ((ComboBox)o).Text = ""; } else { if (((ComboBox)o).DropDownStyle == ComboBoxStyle.DropDownList) { //如果选项中无,则加一个 if (((ComboBox)o).Items.IndexOf(dr[filename_].ToString().Trim()) == -1) { ((ComboBox)o).Items.Add(dr[filename_].ToString().Trim()); } ((ComboBox)o).SelectedIndex = ((ComboBox)o).Items.IndexOf(dr[filename_].ToString().Trim()); } else { ((ComboBox)o).Text = dr[filename_].ToString().Trim(); } } break; } } if (o is DateTimePicker) { stmp = ((DateTimePicker)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); if ((lx_ != "s_") && (lx_ != "n_")) { continue; //其余控件不处理 } if (fiel_.ToLower() == filename_) { if (dr[filename_] is DBNull) { //((DateTimePicker)o).Value = Convert.ToDateTime(DBNull.Value); //error ((DateTimePicker)o).Value = Convert.ToDateTime("1900-01-01 00:00:01"); } else { ((DateTimePicker)o).Value = Convert.ToDateTime(dr[filename_].ToString().Trim()); } break; } } if (o is CheckBox) //只处理存储为true,false的情况 { stmp = ((CheckBox)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); if ((lx_ != "s_") && (lx_ != "n_")) { continue; //其余控件不处理 } if (fiel_.ToLower() == filename_) { if (dr[filename_].ToString().Trim() == "True") { ((CheckBox)o).Checked = true; } else if (dr[filename_].ToString().Trim() == "False") { ((CheckBox)o).Checked = false; } break; } } } //end of foreach } //end of for } //end of foreach } }
/// <summary> /// 获得某一仓库、某一物料、某一类型商品的库存 /// </summary> /// <param name="SStorehouseId"></param> /// <param name="matId"></param> /// <param name="matType"></param> /// <returns></returns> public static StockStatus GetStockNum(string SStorehouseId, string matId, int matType) { double stockNum = 0; //当前库存 double firstCount = 0; //期初数量 double stockInCount = 0; //收入数量 double stockOutCount = 0; //发出数量 SqlDBConnect db = new SqlDBConnect(); //查找最近一次结存的数量 string maxBalanceTime = StockStatusDAO.GetBalanceTime(); string strSql_ = "select FirstCount,FirstCostPrice,BalanceTime from T_Stock_Status " + "where StoreHouseId='{0}' and MatId='{1}' and MatType={2} and BalanceTime='{3}'"; strSql_ = string.Format(strSql_, SStorehouseId, matId, matType, maxBalanceTime); DataTable dt_ = db.Get_Dt(strSql_); if (dt_ != null && dt_.Rows.Count > 0) firstCount = Convert.ToDouble(dt_.Rows[0]["FirstCount"].ToString().Trim()); //入库 string sql_1 = "select sum(num) num from T_Receipt_Main_Det where SourceStoreH='{0}' and MatId='{1}' and MatType='{2}' and CurWorkMonth >= '{3}' " + "and ReceiptTypeID < '51' and ReceiptTypeID != 'YS' and ReceiptTypeID != 'YF'"; sql_1 = string.Format(sql_1, SStorehouseId, matId, matType, maxBalanceTime); DataTable dt_1 = db.Get_Dt(sql_1); if (dt_1 != null && dt_1.Rows.Count > 0) { if (dt_1.Rows[0]["num"].ToString().Trim() != "") stockInCount = Convert.ToDouble(dt_1.Rows[0]["num"].ToString().Trim()); } //出库 string sql_2 = "select sum(num) num from T_Receipt_Main_Det where SourceStoreH='{0}' and MatId='{1}' and MatType='{2}' and CurWorkMonth >= '{3}' " + "and ReceiptTypeID >= '51' and ReceiptTypeID <= '90'"; sql_2 = string.Format(sql_2, SStorehouseId, matId, matType, maxBalanceTime); DataTable dt_2 = db.Get_Dt(sql_2); if (dt_2 != null && dt_2.Rows.Count > 0) { if (dt_2.Rows[0]["num"].ToString().Trim() != "") stockOutCount = Convert.ToDouble(dt_2.Rows[0]["num"].ToString().Trim()); } stockNum = firstCount + stockInCount - stockOutCount; StockStatus stockStatus = new StockStatus(); stockStatus.firstCount = firstCount; stockStatus.stockInCount = stockInCount; stockStatus.stockOutCount = stockOutCount; stockStatus.stockNum = stockNum; return stockStatus; }
/// <summary> /// 将selectsql_查询语句执行结果,绑定到pa中Name属性指定了值的控件上 /// </summary> /// <param name="Pa"></param> /// <param name="selectsql_"></param> public static void ShowDatas(Panel Pa, string selectsql_) { SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(selectsql_); string filename_ = "", stmp = "", lx_; string fiel_ = ""; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) //行 { for (int i = 0; i <= dt.Columns.Count - 1; i++) //列 { filename_ = dt.Columns[i].ColumnName.ToLower().Trim(); foreach (Control con in Pa.Controls) { if (con is Panel) foreach (Control o in (con as Panel).Controls) { if (o is TextBox) { stmp = ((TextBox)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); if ((lx_ != "s_") && (lx_ != "n_")) continue; //其余控件不处理 if (fiel_.ToLower() == filename_) { if (dr[filename_] is DBNull) ((TextBox)o).Text = ""; else ((TextBox)o).Text = dr[filename_].ToString().Trim(); break; } } if (o is ComboBox) { stmp = ((ComboBox)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); //if ((lx_ != "s_") && (lx_ != "n_")) continue; //其余控件不处理 if (fiel_.ToLower() == filename_) { if (dr[filename_] is DBNull) ((ComboBox)o).Text = ""; else { if (((ComboBox)o).DropDownStyle == ComboBoxStyle.DropDownList) ((ComboBox)o).SelectedIndex = ((ComboBox)o).Items.IndexOf(dr[filename_].ToString().Trim()); else ((ComboBox)o).Text = dr[filename_].ToString().Trim(); } break; } } if (o is DateTimePicker) { stmp = ((DateTimePicker)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); if ((lx_ != "s_") && (lx_ != "n_")) continue; //其余控件不处理 if (fiel_.ToLower() == filename_) { if (dr[filename_] is DBNull) ((DateTimePicker)o).Value = Convert.ToDateTime(DBNull.Value); else ((DateTimePicker)o).Value = Convert.ToDateTime(dr[filename_].ToString().Trim()); break; } } if (o is CheckBox) //只处理存储为true,false的情况 { stmp = ((CheckBox)o).Name.Trim().ToLower(); lx_ = stmp.Substring(0, 2); fiel_ = stmp.Substring(2, stmp.Length - 2).Trim(); if ((lx_ != "s_") && (lx_ != "n_")) continue; //其余控件不处理 if (fiel_.ToLower() == filename_) { if (dr[filename_].ToString().Trim() == "True") ((CheckBox)o).Checked = true; else if (dr[filename_].ToString().Trim() == "False") ((CheckBox)o).Checked = false; break; } } } //end of foreach } //end of foreach } //end of for }//end of foreach } }
/// <summary> /// 从服务器读取执行文件的上传时间 /// </summary> /// <returns></returns> public string get_version() { string vernew_ = ""; string sql_ = "select UploadTime from T_SysConfig"; SqlDBConnect db = new SqlDBConnect(); DataTable dt = db.Get_Dt(sql_); if (dt == null || dt.Rows.Count <= 0) return ""; vernew_ = dt.Rows[0]["UploadTime"].ToString().Trim(); return vernew_; }
private void CustomerInfAdd_Load(object sender, EventArgs e) { //初始化ComboBox InitFuncs inf = new InitFuncs(); inf.InitComboBox(this.s_CustType, "[客户]类别"); inf.InitComboBox(this.s_Degree, "[客户]等级"); inf.InitComboBox(this.s_whichTrade, "[客户]所在行业"); inf.InitComboBox(this.s_Country, "[客户]国家"); inf.InitComboBox(this.s_Province, "[客户]省"); inf.InitComboBox(this.s_City, "[客户]城市"); inf.InitComboBox(this.t_AreaCode, "T_AreaInf", "Area"); inf.InitComboBox(this.t_ImportanceDegreeId, "T_CustomerImp", "importance"); if (custid.Trim() == "") { tabControl1.Enabled = false; } else { tabControl1.Enabled = true ; } s_InputTime.Text = DBUtil.getServerTime().ToString(); if (this.type == "edit") { this.s_CustID.ReadOnly = true; string strsql = "select * from T_CustomerInf where CustID='{0}'"; strsql = string.Format(strsql, this.custid); inf.ShowDatas(this.panelcustomer, strsql); //以下两行必须在ShowDatas后 DBUtil dbUtil = new DBUtil(); t_AreaCode.Text = (new DBUtil()).Get_Single_val("T_AreaInf", "Area", "areaId", S_AreaCode.Text.Trim()); t_ImportanceDegreeId.Text = (new DBUtil()).Get_Single_val("T_CustomerImp", "importance", "Iid", S_ImportanceDegreeId.Text.Trim()); //初始化抬头 SqlDBConnect SDB = new SqlDBConnect(); s_BillHead.Clear(); string strSql = "select BillHead as 发票抬头 from T_CustomerTitle where CustID='{0}'";//"select * from T_SelItems where ItemType='{0}'"; strSql = string.Format(strSql, s_CustID.Text.Trim()); DataSet ds = SDB.Get_Ds(strSql); int Lins = ds.Tables[0].Rows.Count; string[] match = new string[ds.Tables[0].Rows.Count]; for (int i = 0; i < match.Length; i++) { s_BillHead.Text += ds.Tables[0].Rows[i]["发票抬头"].ToString() + "\r\n";//回车换行 } } if (this.custid!="") {//初始化联系人; init_lxr(); //初始化发票 init_fp(); //初始化多地址 init_muladd(); } //限制值类型文本框的输入 (new InitFuncs()).Num_limited(this.panelcustomer); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { #region 验证 if (this.comboBoxReceiptTypeID.SelectedIndex == 0) { MessageBox.Show("请选择单据模板!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (this.checkBoxReceiptId.Checked == false) { MessageBox.Show("单据号必须选择!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } #endregion string strRTypeID = this.comboBoxReceiptTypeID.Text.Trim(); //插入前先全部删除 string strSqlDelete = "delete from T_ReceiptModCfg where RTypeID='{0}'"; strSqlDelete = string.Format(strSqlDelete, strRTypeID); List<string> sqls = new List<string>(); sqls.Add(strSqlDelete); Insert(this.listBoxMainTop, ref sqls, strRTypeID); Insert(this.listBoxMainBottom, ref sqls, strRTypeID); Insert(this.listBoxDetail, ref sqls, strRTypeID); SqlDBConnect db = new SqlDBConnect(); db.Exec_Tansaction(sqls); MessageBox.Show("保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); }
private void btnOK_Click(object sender, EventArgs e) { #region 验证 if (this.s_ReceiptId.Text.Trim() == "") { MessageBox.Show("请输入拆件单据编号!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (this.comboBoxMatName.SelectedIndex == 0 || this.comboBoxMatName.Text.Trim() == "") { MessageBox.Show("请选择被拆物料!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (this.comboBoxMatType.SelectedIndex == 0 || this.comboBoxMatType.Text.Trim() == "") { MessageBox.Show("请选择被拆物料类型!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } #endregion SqlDBConnect db = new SqlDBConnect(); InitFuncs initFuncs = new InitFuncs(); DBUtil dbUtil = new DBUtil(); this.s_OccurTime.Format = DateTimePickerFormat.Short; this.s_OccurTime.Value = DBUtil.getServerTime(); if (this.type == "add") { //插入之前判断 string strSqlSel = "select * from T_MatSplit_Main where ReceiptId='{0}'"; strSqlSel = string.Format(strSqlSel, this.s_ReceiptId.Text.Trim()); bool isExist = dbUtil.yn_exist_data(strSqlSel); if (isExist) { MessageBox.Show("已存在该拆件单据!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { List<string> sqls = new List<string>(); //插入拆件管理主表 string strSqlInsert = initFuncs.Build_Insert_Sql(this.panel1, "T_MatSplit_Main"); sqls.Add(strSqlInsert); db.Exec_Tansaction(sqls); MessageBox.Show("保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); matSplitMainFormChange(); //激活代理事件,在MatSplitForm中处理 this.Close(); } } else if (this.type == "edit") { //更新 string strWhere = "where ReceiptId='{0}'"; strWhere = string.Format(strWhere, this.s_ReceiptId.Text.Trim()); string strSqlUpdate = initFuncs.Build_Update_Sql(this.panel1, "T_MatSplit_Main", strWhere); db.ExecuteNonQuery(strSqlUpdate); MessageBox.Show("修改成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); matSplitMainFormChange(); //激活代理事件,在MatSplitForm中处理 this.Close(); } }
private void StockStatusOperate() { try { DateTime from_, to_; from_ = System.DateTime.Now; string balanceTime = this.textBoxStockMonth.Text.Trim(); if (balanceTime.Length != 6) { MessageBox.Show("请输入正确的结存年月(如:201108)!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string maxBalanceTime = StockStatusDAO.GetBalanceTime(); if (string.Compare(balanceTime, maxBalanceTime) > 0) { MessageBox.Show("前面还有未结存的月份!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } SqlDBConnect db = new SqlDBConnect(); string strSql = "select distinct SourceStoreH, MatId, MatType from T_Receipts_Det,T_Receipt_Main " + "where CurWorkMonth = '{0}' and T_Receipts_Det.receiptId=T_Receipt_Main.receiptId and ReceiptTypeID != 'YS' and ReceiptTypeID != 'YF'"; strSql = string.Format(strSql, balanceTime); DataTable dt = db.Get_Dt(strSql); if (dt == null || dt.Rows.Count <= 0) return; this.Invoke((EventHandler)delegate { this.progressBar1.Value = 0; }); this.Invoke((EventHandler)delegate { this.progressBar1.Minimum = 0; }); this.Invoke((EventHandler)delegate { this.progressBar1.Maximum = dt.Rows.Count; }); List<string> sqls = new List<string>(); foreach (DataRow dr in dt.Rows) { double firstCount = 0; //期初数量 double firstMoney = 0.0; //期初成本金额 double stockInCount = 0; //收入数量 double stockInMoney = 0.0; double stockOutCount = 0; //发出数量 double stockOutMoney = 0.0; double lastCount = 0; //期末数量 double lastMoney = 0.0; //期末金额 double firstRoadCount = 0; //期初在途数量(未冲销03单) double firstRoadMoney = 0.0; double firstOutCount = 0; //期初发出数量(75、88数量) double firstOutMoney = 0.0; double lastRoadCount = 0; //期末在途数量(未冲销03单) double lastRoadMoney = 0.0; double lastOutCount = 0; //期末发出数量(75、88数量) double lastOutMoney = 0.0; double roadCount = 0; //本期在途数量 double roadMoney = 0.0; double outCount = 0; //本期发出数量 double outMoney = 0.0; string storeHouseId = dr["SourceStoreH"].ToString().Trim(); string matId = dr["MatId"].ToString().Trim(); int matType = Convert.ToInt32(dr["MatType"].ToString().Trim()); //入库 string sql_1 = "select sum(num) as num, sum(TTaxPurchPrice) as TTaxPurchPrice from T_Receipt_Main_Det " + "where CurWorkMonth = '{0}' and SourceStoreH='{1}' and MatId='{2}' and MatType={3} " + "and ReceiptTypeID < '51' and ReceiptTypeID != 'YS' and ReceiptTypeID != 'YF'"; sql_1 = string.Format(sql_1, balanceTime, storeHouseId, matId, matType); DataTable dt_1 = db.Get_Dt(sql_1); if (dt_1 != null && dt_1.Rows.Count > 0) { if (dt_1.Rows[0]["num"].ToString().Trim() != "") stockInCount = Convert.ToDouble(dt_1.Rows[0]["num"].ToString().Trim()); if (dt_1.Rows[0]["TTaxPurchPrice"].ToString().Trim() != "") stockInMoney = Convert.ToDouble(dt_1.Rows[0]["TTaxPurchPrice"].ToString().Trim()); } //出库 string sql_2 = "select sum(num) as num, sum(TTaxPurchPrice) as TTaxPurchPrice from T_Receipt_Main_Det " + "where CurWorkMonth = '{0}' and SourceStoreH='{1}' and MatId='{2}' and MatType={3} " + "and ReceiptTypeID >= '51' and ReceiptTypeID != 'YS' and ReceiptTypeID != 'YF'";// and ReceiptTypeID != '90'"; sql_2 = string.Format(sql_2, balanceTime, storeHouseId, matId, matType); DataTable dt_2 = db.Get_Dt(sql_2); if (dt_2 != null && dt_2.Rows.Count > 0) { if (dt_2.Rows[0]["num"].ToString().Trim() != "") stockOutCount = Convert.ToDouble(dt_2.Rows[0]["num"].ToString().Trim()); if (dt_2.Rows[0]["TTaxPurchPrice"].ToString().Trim() != "") stockOutMoney = Convert.ToDouble(dt_2.Rows[0]["TTaxPurchPrice"].ToString().Trim());// } //本期在途(未冲销03单) string sql_3 = "select sum(num) as num,sum(TTaxPurchPrice) as TTaxPurchPrice from T_Receipt_Main_Det " + "where CurWorkMonth = '{0}' and SourceStoreH='{1}' and MatId='{2}' and MatType={3} " + "and (ReceiptTypeID = '03' or ReceiptTypeID = '20')"; sql_3 = string.Format(sql_3, balanceTime, storeHouseId, matId, matType); DataTable dt_3 = db.Get_Dt(sql_3); if (dt_3 != null && dt_3.Rows.Count > 0) { if (dt_3.Rows[0]["num"].ToString().Trim() != "") roadCount = Convert.ToDouble(dt_3.Rows[0]["num"].ToString().Trim()); if (dt_3.Rows[0]["TTaxPurchPrice"].ToString().Trim() != "") roadMoney = Convert.ToDouble(dt_3.Rows[0]["TTaxPurchPrice"].ToString().Trim());// } //本期发出(75、88数量) string sql_4 = "select sum(num) as num,sum(TTaxPurchPrice) as TTaxPurchPrice from T_Receipt_Main_Det " + "where CurWorkMonth = '{0}' and SourceStoreH='{1}' and MatId='{2}' and MatType={3} " + "and (ReceiptTypeID = '75' or ReceiptTypeID = '88')"; sql_4 = string.Format(sql_4, balanceTime, storeHouseId, matId, matType); DataTable dt_4 = db.Get_Dt(sql_4); if (dt_4 != null && dt_4.Rows.Count > 0) { if (dt_4.Rows[0]["num"].ToString().Trim() != "") outCount = Convert.ToDouble(dt_4.Rows[0]["num"].ToString().Trim()); if (dt_4.Rows[0]["TTaxPurchPrice"].ToString().Trim() != "") outMoney = Convert.ToDouble(dt_4.Rows[0]["TTaxPurchPrice"].ToString().Trim());// } //期初 string strSql_ = "select FirstCount,FirstCostPrice,FirstMoney,FirstRoadCount,FirstRoadMoney,FirstOutCount,FirstOutMoney,BalanceTime from T_Stock_Status " + "where BalanceTime='{0}' and StoreHouseId='{1}' and MatId='{2}' and MatType={3} "; strSql_ = string.Format(strSql_, balanceTime, storeHouseId, matId, matType); DataTable dt_ = db.Get_Dt(strSql_); if (dt_ != null && dt_.Rows.Count > 0) { //取该物料本期期初的数量、成本单价、成本金额 firstCount = Convert.ToDouble(dt_.Rows[0]["FirstCount"].ToString().Trim()); firstMoney = Convert.ToDouble(dt_.Rows[0]["FirstMoney"].ToString().Trim()); firstRoadCount = Convert.ToDouble(dt_.Rows[0]["FirstRoadCount"].ToString().Trim()); firstRoadMoney = Convert.ToDouble(dt_.Rows[0]["FirstRoadMoney"].ToString().Trim()); firstOutCount = Convert.ToDouble(dt_.Rows[0]["FirstOutCount"].ToString().Trim()); firstOutMoney = Convert.ToDouble(dt_.Rows[0]["FirstOutMoney"].ToString().Trim()); lastCount = firstCount + stockInCount - stockOutCount; lastMoney = firstMoney + stockInMoney - stockOutMoney; lastRoadCount = firstRoadCount + roadCount; lastRoadMoney = firstRoadMoney + roadMoney; lastOutCount = firstOutCount + outCount; lastOutMoney = firstOutMoney + outMoney; string strSqlUpdate = "update T_Stock_Status set StockInCount={0},StockInMoney={1},StockOutCount={2},StockOutMoney={3}," + "LastCount={4},LastMoney={5},LastRoadCount={6},LastRoadMoney={7},LastOutCount={8},LastOutMoney={9} " + " where BalanceTime='{10}' and StoreHouseId='{11}' and MatId='{12}' and MatType={13} "; strSqlUpdate = string.Format(strSqlUpdate, stockInCount, stockInMoney, stockOutCount, stockOutMoney, lastCount, lastMoney, lastRoadCount, lastRoadMoney, lastOutCount, lastOutMoney, balanceTime, storeHouseId, matId, matType); sqls.Add(strSqlUpdate); } else //不存在,为本工作月新增商品 { lastCount = stockInCount - stockOutCount; lastMoney = stockInMoney - stockOutMoney; lastRoadCount = roadCount; lastRoadMoney = roadMoney; lastOutCount = outCount; lastOutMoney = outMoney; string strSqlInsert = "insert into T_Stock_Status(StoreHouseId,MatId,MatType,BalanceTime,FirstCount,FirstMoney,FirstRoadCount,FirstRoadMoney,FirstOutCount,FirstOutMoney," + "StockInCount,StockInMoney,StockOutCount,StockOutMoney,LastCount,LastMoney,LastRoadCount,LastRoadMoney,LastOutCount,LastOutMoney) " + "values('{0}','{1}',{2},'{3}',{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19}"; strSqlInsert = string.Format(strSqlInsert, storeHouseId, matId, matType, balanceTime, 0, 0, 0, 0, 0, 0, stockInCount, stockInMoney, stockOutCount, stockOutMoney, lastCount, lastMoney, lastRoadCount, lastRoadMoney, lastOutCount, lastOutMoney); sqls.Add(strSqlInsert); } this.Invoke((EventHandler)delegate { this.progressBar1.Value += 1; }); } //处理结存库中存在,但当月并未发生的物料 string sqlSS = "select T_Stock_Status.* from T_Stock_Status " + "where T_Stock_Status.StoreHouseId + T_Stock_Status.MatId + CONVERT(Nvarchar, T_Stock_Status.matType) not in " + "(select T_Receipt_Main_Det.SourceStoreH + T_Receipt_Main_Det.MatId + CONVERT(Nvarchar, T_Receipt_Main_Det.matType) "+ "from T_Receipt_Main_Det where CurWorkMonth='{0}' and ReceiptTypeID != 'YS' and ReceiptTypeID != 'YF') " + "and BalanceTime = '{1}'"; sqlSS = string.Format(sqlSS, balanceTime, balanceTime); DataTable dtSS = db.Get_Dt(sqlSS); this.Invoke((EventHandler)delegate { this.progressBar1.Value = 0; }); this.Invoke((EventHandler)delegate { this.progressBar1.Minimum = 0; }); this.Invoke((EventHandler)delegate { this.progressBar1.Maximum = dtSS.Rows.Count; }); if (dtSS != null && dtSS.Rows.Count > 0) { foreach (DataRow dr in dtSS.Rows) { string storeHouseId = dr["StoreHouseId"].ToString().Trim(); string matId = dr["MatId"].ToString().Trim(); int matType = Convert.ToInt32(dr["MatType"].ToString().Trim()); double firstCount = Convert.ToDouble(dr["FirstCount"].ToString().Trim()); double firstMoney = Convert.ToDouble(dr["FirstMoney"].ToString().Trim()); double firstRoadCount = Convert.ToDouble(dr["FirstRoadCount"].ToString().Trim()); double firstRoadMoney = Convert.ToDouble(dr["FirstRoadMoney"].ToString().Trim()); double firstOutCount = Convert.ToDouble(dr["FirstOutCount"].ToString().Trim()); double firstOutMoney = Convert.ToDouble(dr["FirstOutMoney"].ToString().Trim()); string strSqlUpdate = "update T_Stock_Status set StockInCount={0},StockInMoney={1},StockOutCount={2},StockOutMoney={3}," + "LastCount={4},LastMoney={5},LastRoadCount={6},LastRoadMoney={7},LastOutCount={8},LastOutMoney={9} " + " where BalanceTime='{10}' and StoreHouseId='{11}' and MatId='{12}' and MatType={13}"; strSqlUpdate = string.Format(strSqlUpdate, 0, 0, 0, 0, firstCount, firstMoney, firstRoadCount, firstRoadMoney, firstOutCount, firstOutMoney, balanceTime, storeHouseId, matId, matType); sqls.Add(strSqlUpdate); this.Invoke((EventHandler)delegate { this.progressBar1.Value += 1; }); } } db.Exec_Tansaction(sqls); //执行 //插入下一个结存月的期初信息 List<string> sqlsIns = new List<string>(); string nextBalanceTime = Util.GetNextMonth(balanceTime); ;//计算下一个月 string strSqlIns = "select * from T_Stock_Status where BalanceTime='{0}'"; strSqlIns = string.Format(strSqlIns, balanceTime); DataTable dtIns = db.Get_Dt(strSqlIns); this.Invoke((EventHandler)delegate { this.progressBar1.Value = 0; }); this.Invoke((EventHandler)delegate { this.progressBar1.Minimum = 0; }); this.Invoke((EventHandler)delegate { this.progressBar1.Maximum = dtIns.Rows.Count; }); for (int i = 0; i < dtIns.Rows.Count; i++) { string storeHouseId = dtIns.Rows[i]["StoreHouseId"].ToString().Trim(); string matId = dtIns.Rows[i]["MatId"].ToString().Trim(); int matType = Convert.ToInt32(dtIns.Rows[i]["MatType"].ToString().Trim()); double lastCount = Convert.ToDouble(dtIns.Rows[i]["LastCount"].ToString().Trim()); //期末数量 double lastMoney = Convert.ToDouble(dtIns.Rows[i]["LastMoney"].ToString().Trim()); //期末金额 double lastRoadCount = Convert.ToDouble(dtIns.Rows[i]["LastRoadCount"].ToString().Trim()); //期末在途数量(未冲销03单) double lastRoadMoney = Convert.ToDouble(dtIns.Rows[i]["LastRoadMoney"].ToString().Trim()); double lastOutCount = Convert.ToDouble(dtIns.Rows[i]["LastOutCount"].ToString().Trim()); //期末发出数量(75、88数量) double lastOutMoney = Convert.ToDouble(dtIns.Rows[i]["LastOutMoney"].ToString().Trim()); string sql = "insert into T_Stock_Status(StoreHouseId,MatId,MatType,BalanceTime,FirstCount,FirstMoney,FirstRoadCount,FirstRoadMoney,FirstOutCount,FirstOutMoney) " + "values('{0}','{1}',{2},'{3}',{4},{5},{6},{7},{8},{9})"; sql = string.Format(sql, storeHouseId, matId, matType, nextBalanceTime, lastCount, lastMoney, lastRoadCount, lastRoadMoney, lastOutCount, lastOutMoney); sqlsIns.Add(sql); this.Invoke((EventHandler)delegate { this.progressBar1.Value += 1; }); } db.Exec_Tansaction(sqlsIns); to_ = System.DateTime.Now; string strInf = "结存成功!\n开始时间:" + from_.ToShortTimeString() + "\n结束时间:" + to_.ToShortTimeString(); MessageBox.Show(strInf, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Invoke((EventHandler)delegate { this.progressBar1.Value = 0; }); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } }
/// <summary> /// 添加附件 /// </summary> private void btnAddDoc_Click(object sender, EventArgs e) { #region 验证 if (this.dataGridView1.SelectedRows.Count <= 0) return; if (this.dataGridView1.SelectedRows[0].Cells["sysid"].Value == null) return; if (this.dataGridView1.SelectedRows[0].Cells["barsysid"].Value == null) return; if (this.s_AttachName.Text.Trim() == "") { MessageBox.Show("请先填写附件名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //判断是否存在记录 string strSqlSel = "select * from T_BargAttach where barsysid={0} and AttachName='{1}'"; strSqlSel = string.Format(strSqlSel, this.barsysid, this.s_AttachName.Text.Trim()); bool isExist = (new DBUtil()).yn_exist_data(strSqlSel); if (isExist == false) { MessageBox.Show("该记录不存在,不能为其添加附件!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } #endregion OpenFileDialog fd = new OpenFileDialog(); fd.Filter = "word文档(*.doc)|*.doc|Excel电子表格(*.xls)|*.xls|所有文件(*.*)|*.*"; if (fd.ShowDialog() == DialogResult.OK) { string fileName = fd.FileName; string fileExt = fileName.Substring(fileName.LastIndexOf('.')); //将文件读入到字节数组 System.IO.FileStream fs = new System.IO.FileStream(fd.FileName, System.IO.FileMode.Open, System.IO.FileAccess.Read); byte[] buffByte = new byte[fs.Length]; fs.Read(buffByte, 0, (int)fs.Length); fs.Close(); fs = null; SqlDBConnect dbc = new SqlDBConnect(); string sql_ = "update T_BargAttach set Attachment=@file,doctype=@doctype where barsysid={0} and AttachName='{1}'"; sql_ = string.Format(sql_, this.barsysid, this.s_AttachName.Text.Trim()); SqlCommand cm = new SqlCommand(); cm.Connection = dbc.conn; dbc.OpenDb(); cm.CommandText = sql_; cm.Parameters.Add("@file", System.Data.SqlDbType.Image); cm.Parameters.Add("@doctype", System.Data.SqlDbType.NChar); cm.Parameters[0].Value = buffByte; cm.Parameters[1].Value = fileExt; try { cm.ExecuteNonQuery(); MessageBox.Show("绑定成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); initdataGridview(); } catch (Exception ex) { MessageBox.Show("绑定失败" + ex.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } dbc.CloseDb(); } }
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e) { SqlDBConnect SDB = new SqlDBConnect(); DBUtil dbUtil = new DBUtil(); try { s_ItemVal.Clear(); string strSql = "select * from T_SelItems where ItemType='{0}'"; strSql = string.Format(strSql, s_ItemType.Text.Trim()); DataSet ds = SDB.Get_Ds(strSql); int Lins = ds.Tables[0].Rows.Count; string[] match = new string[ds.Tables[0].Rows.Count]; for (int i = 0; i < match.Length; i++) { s_ItemVal.Text += ds.Tables[0].Rows[i]["ItemVal"].ToString() + "\r\n";//回车换行 } } catch { MessageBox.Show("当前行不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnSave_Click(object sender, EventArgs e) { if (this.txtCustId.Text.Trim() == "") { MessageBox.Show("客户代码不能为空!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (this.txtInMoney.Text.Trim() != "" && !Util.IsNumberic(this.txtInMoney)) { MessageBox.Show("核销金额只能为数值型数据!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } List<string> sqls = new List<string>(); string custId = this.txtCustId.Text.Trim(); string custName = this.txtCustName.Text.Trim(); string payMethod = ""; if (this.comboBoxPayMethod.SelectedIndex != 0) payMethod = this.comboBoxPayMethod.Text.Trim(); string bankAccount = this.txtBankAccount.Text.Trim(); double inMoney = 0.0; if (this.txtInMoney.Text.Trim() != "") inMoney = Convert.ToDouble(this.txtInMoney.Text.Trim()); string pinZhengHao = this.txtPinZhengHao.Text.Trim(); string abstact = this.txtAbstract.Text.Trim(); string record = this.txtRecord.Text.Trim(); string memo = this.txtMemo.Text.Trim(); string financialId = ""; if (this.financialType == "收入") { //产生单据号,并返回更新"T_ReceiptRule"的SQL语句 string SqlUpdateBillRullYS = ""; financialId = DBUtil.Produce_Bill_Id("YS", DBUtil.getServerTime().ToString().Trim(), ref SqlUpdateBillRullYS); //插入账务主表 string strSqlMain = "insert into T_Financial(FinancialId,CurWorkMonth,FinancialType,CustId,CustName,PayMethod,BankAccount,InMoney," + "OccurTime,PinZhengHao,Abstract,Record,OperatePerson,Memo) " + "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')"; strSqlMain = string.Format(strSqlMain, financialId, this.curWorkMonth, "收入", custId, custName, payMethod, bankAccount, inMoney, DBUtil.getServerTime().ToString().Trim(), pinZhengHao, abstact, record, this.curUserName, memo); sqls.Add(strSqlMain); sqls.Add(SqlUpdateBillRullYS);//更新单据号 } else if (this.financialType == "支出") { //产生单据号,并返回更新"T_ReceiptRule"的SQL语句 string SqlUpdateBillRullYF = ""; financialId = DBUtil.Produce_Bill_Id("YF", DBUtil.getServerTime().ToString().Trim(), ref SqlUpdateBillRullYF); //插入账务主表 string strSqlMain = "insert into T_Financial(FinancialId,CurWorkMonth,FinancialType,CustId,CustName,PayMethod,BankAccount,OutMoney," + "OccurTime,PinZhengHao,Abstract,Record,OperatePerson,Memo) " + "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')"; strSqlMain = string.Format(strSqlMain, financialId, this.curWorkMonth, "支出", custId, custName, payMethod, bankAccount, inMoney, DBUtil.getServerTime().ToString().Trim(), pinZhengHao, abstact, record, this.curUserName, memo); sqls.Add(strSqlMain); sqls.Add(SqlUpdateBillRullYF);//更新单据号 } //插入账务子表 foreach (DataGridViewRow dgvr in this.dataGridView1.Rows) { if (dgvr.Cells["单据号"].Value == null || dgvr.Cells["单据号"].Value.ToString().Trim() == "") continue; string workMonth = dgvr.Cells["单据工作月"].Value.ToString().Trim(); string receiptId = dgvr.Cells["单据号"].Value.ToString().Trim(); string orderNo = dgvr.Cells["分录号"].Value.ToString().Trim(); double moneyPayed = 0.0; if (dgvr.Cells["实核销金额"].Value != null && dgvr.Cells["实核销金额"].Value.ToString().Trim() != "") moneyPayed = Convert.ToDouble(dgvr.Cells["实核销金额"].Value.ToString().Trim()); string strSqlDet = "insert into T_Financial_Det(FinancialId,workMonth,ReceiptId,OrderNo,MoneyPayed) " + "values('{0}','{1}','{2}','{3}','{4}')"; strSqlDet = string.Format(strSqlDet, financialId, workMonth, receiptId, orderNo, moneyPayed); sqls.Add(strSqlDet); //更新单据子表的MoneyPayed string strSqlUpdate = "update T_Receipts_Det set MoneyPayed = MoneyPayed + {0} where ReceiptId='{1}' and OrderNo='{2}'"; strSqlUpdate = string.Format(strSqlUpdate, moneyPayed, receiptId, orderNo); sqls.Add(strSqlUpdate); } //执行事务处理所有的Sql SqlDBConnect db = new SqlDBConnect(); db.Exec_Tansaction(sqls); MessageBox.Show("保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); //保存后,新建一个 if (this.financialType == "收入") { FinancialForm form = new FinancialForm("收入"); form.MdiParent = this.MdiParent as MainForm; form.Show(); } if (this.financialType == "支出") { FinancialForm form = new FinancialForm("支出"); form.MdiParent = this.MdiParent as MainForm; form.Show(); } this.Close(); }
/// <summary> /// 添加技术资料附件 /// </summary> private void btnAddMatDoc_Click(object sender, EventArgs e) { if (this.s_DocName.Text.Trim() == "") { MessageBox.Show("请先填写资料名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //判断是否存在记录 string strSqlSel=""; if (this.Type=="add") { strSqlSel = "select * from T_MatDocs where DocName='{0}'"; } else { strSqlSel = "select * from T_MatDocs where DocName='{0}' and sysid!="+this.sysid_; } strSqlSel = string.Format(strSqlSel, this.s_DocName.Text.Trim()); bool isExist = (new DBUtil()).yn_exist_data(strSqlSel); if (isExist) { MessageBox.Show("该资料名已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } OpenFileDialog fd = new OpenFileDialog(); fd.Filter = "word文档(*.doc)|*.doc|Excel电子表格(*.xls)|*.xls|所有文件(*.*)|*.*"; if (fd.ShowDialog() == DialogResult.OK) { string fileName = fd.FileName; string fileExt = fileName.Substring(fileName.LastIndexOf('.')); //将文件读入到字节数组 System.IO.FileStream fs = new System.IO.FileStream(fd.FileName, System.IO.FileMode.Open, System.IO.FileAccess.Read); byte[] buffByte = new byte[fs.Length]; fs.Read(buffByte, 0, (int)fs.Length); fs.Close(); fs = null; SqlDBConnect dbc = new SqlDBConnect(); string sql_ = "update T_MatDocs set DocBlob=@file,doctype=@doctype where sysid='{0}'"; sql_ = string.Format(sql_, this.sysid_); SqlCommand cm = new SqlCommand(); cm.Connection = dbc.conn; dbc.OpenDb(); cm.CommandText = sql_; cm.Parameters.Add("@file", System.Data.SqlDbType.Image); cm.Parameters.Add("@doctype", System.Data.SqlDbType.NChar); cm.Parameters[0].Value = buffByte; cm.Parameters[1].Value = fileExt; try { cm.ExecuteNonQuery(); MessageBox.Show("上传成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { MessageBox.Show("上传失败" + ex.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } dbc.CloseDb(); } }