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_:单据类型（２个字符）
//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) //本月第１张
{
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();
}
}
