private void sbtnDel_Click(object sender, System.EventArgs e)
{
if (this.dataGrid1.CurrentRowIndex >= 0)
{
string strGoodsID = dataGrid1[dataGrid1.CurrentRowIndex, 0].ToString();
DialogResult strRes = MessageBox.Show("确定要删除“" + strGoodsID + "”吗？", "请确认", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question);
if (strRes == DialogResult.Yes)
{
err = null;
cs.DeleteGoods(strGoodsID, out err);
if (err != null)
{
MessageBox.Show("删除商品信息失败，请重试！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
this.DgBind();
}
else
{
MessageBox.Show("删除商品信息成功！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
Application.Exit();
}
this.DgBind();
}
}
}
}
private void sbtnOk_Click(object sender, System.EventArgs e)
{
string strDeptName = this.comboBox1.Text;
string strDeptID = this.GetColEn(strDeptName, "Dept");
Exception err = null;
ca.SetLocalDept(strDeptName, strDeptID, out err);
if (err != null)
{
MessageBox.Show("设置本地门店出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
Application.Exit();
}
else
{
SysInitial.LocalDeptID = strDeptID;
SysInitial.LocalDeptName = strDeptName;
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统初始化错误，或是部门和操作员信息不全，请与管理员联系！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
Application.Exit();
return;
}
this.Close();
}
}
private void sbtnSet_Click(object sender, System.EventArgs e)
{
CMSMData.CMSMStruct.CommStruct cos = new CMSMData.CMSMStruct.CommStruct();
if (txtFee.Text.Trim() == "")
{
cos.strCommName = "0";
}
else if (double.Parse(txtFee.Text.Trim()) < 0)
{
MessageBox.Show("消费金额不能小于0！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
cos.strCommName = txtFee.Text.Trim();
}
if (txtIg.Text.Trim() == "")
{
cos.strCommCode = "0";
}
else if (double.Parse(txtIg.Text.Trim()) < 0)
{
MessageBox.Show("赠送积分分值不能小于0！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
cos.strCommCode = txtIg.Text.Trim();
}
cos.strCommSign = "IG";
cos.strComments = "积分赠送";
CommAccess cs = new CommAccess(SysInitial.ConString);
Exception err = null;
cs.UpdateIgComm(cos, out err);
if (err == null)
{
MessageBox.Show("消费积分设置成功！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
Application.Exit();
}
return;
}
else
{
MessageBox.Show("消费积分设置失败！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
return;
}
}
private void sbtnOk_Click(object sender, System.EventArgs e)
{
string strCompName = txtCompName.Text.Trim();
string strDeptName = cmbDeptName.Text.Trim();
string strDeptID = this.GetColEn(strDeptName, "AllDept");
if (strCompName == "")
{
MessageBox.Show("单位名称不能为空！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
this.txtCompName.Focus();
return;
}
else
{
err = null;
if (cs.IsDupMebCompany(strCompName, out err))
{
MessageBox.Show("单位名称已经存在，不能添加！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
this.txtCompName.Focus();
return;
}
}
err = null;
if (!cs.InsertMebCompay(strCompName, strDeptName, strDeptID, out err))
{
MessageBox.Show("添加新的会员单位失败，请重试！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
if (err != null)
{
clog.WriteLine(err);
}
}
else
{
MessageBox.Show("添加新的会员单位成功！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
this.ClearText();
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
Application.Exit();
}
}
}
private void sbtnProm_Click(Object sender, System.EventArgs e)
{
CMSMData.CMSMStruct.CommStruct cos = new CMSMData.CMSMStruct.CommStruct();
Hashtable htpar = new Hashtable();
if (txtPromRate1.Text.Trim() == "")
{
cos.strCommCode = "0";
}
else if (double.Parse(txtPromRate1.Text.Trim()) < 0)
{
MessageBox.Show("充值赠款比例不能小于0！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
cos.strCommCode = txtPromRate1.Text.Trim();
}
cos.strCommName = "充值赠款100-500";
cos.strCommSign = "FP1";
cos.strComments = "充值赠款";
htpar.Add("FP1", cos);
CMSMData.CMSMStruct.CommStruct cos2 = new CMSMData.CMSMStruct.CommStruct();
if (txtPromRate2.Text.Trim() == "")
{
cos2.strCommCode = "0";
}
else if (double.Parse(txtPromRate2.Text.Trim()) < 0)
{
MessageBox.Show("充值赠款比例不能小于0！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
cos2.strCommCode = txtPromRate2.Text.Trim();
}
cos2.strCommName = "充值赠款500-1000";
cos2.strCommSign = "FP2";
cos2.strComments = "充值赠款";
htpar.Add("FP2", cos2);
CMSMData.CMSMStruct.CommStruct cos3 = new CMSMData.CMSMStruct.CommStruct();
if (txtPromRate3.Text.Trim() == "")
{
cos3.strCommCode = "0";
}
else if (double.Parse(txtPromRate3.Text.Trim()) < 0)
{
MessageBox.Show("充值赠款比例不能小于0！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
cos3.strCommCode = txtPromRate3.Text.Trim();
}
cos3.strCommName = "充值赠款1000以上";
cos3.strCommSign = "FP3";
cos3.strComments = "充值赠款";
htpar.Add("FP3", cos3);
CommAccess cs = new CommAccess(SysInitial.ConString);
Exception err = null;
// cs.UpdateFillPromComm(htpar,out err);
if (err == null)
{
MessageBox.Show("充值赠款比例设置成功！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
Application.Exit();
}
return;
}
else
{
MessageBox.Show("充值赠款比例设置失败！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
return;
}
}
private void sbtnMod_Click(object sender, System.EventArgs e)
{
if (sbtnMod.Text == "修改")
{
if (this.dataGrid1.CurrentRowIndex >= 0)
{
this.ClearText();
txtGoodsID.Text = dataGrid1[dataGrid1.CurrentRowIndex, 0].ToString();
txtGoodsName.Text = dataGrid1[dataGrid1.CurrentRowIndex, 1].ToString();
txtSpell.Text = dataGrid1[dataGrid1.CurrentRowIndex, 2].ToString();
txtPrice.Text = dataGrid1[dataGrid1.CurrentRowIndex, 3].ToString();
txtIgValue.Text = dataGrid1[dataGrid1.CurrentRowIndex, 4].ToString();
txtComments.Text = dataGrid1[dataGrid1.CurrentRowIndex, 5].ToString();
gsold = new CMSMData.CMSMStruct.GoodsStruct();
gsold.strGoodsID = dataGrid1[dataGrid1.CurrentRowIndex, 0].ToString();
gsold.strGoodsName = dataGrid1[dataGrid1.CurrentRowIndex, 1].ToString();
gsold.strSpell = dataGrid1[dataGrid1.CurrentRowIndex, 2].ToString();
gsold.dPrice = Double.Parse(dataGrid1[dataGrid1.CurrentRowIndex, 3].ToString());
gsold.iIgValue = int.Parse(dataGrid1[dataGrid1.CurrentRowIndex, 4].ToString());
gsold.strComments = dataGrid1[dataGrid1.CurrentRowIndex, 5].ToString();
sbtnMod.Text = "保存";
this.cmbGoodsType.Enabled = false;
txtGoodsID.ReadOnly = true;
sbtnDel.Enabled = false;
txtGoodsName.ReadOnly = true;
sbtnAdd.Enabled = false;
}
else
{
MessageBox.Show("没有选中要修改的商品信息！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
}
else
{
CMSMData.CMSMStruct.GoodsStruct gs = new CMSMData.CMSMStruct.GoodsStruct();
if (txtGoodsName.Text.Trim() == "")
{
MessageBox.Show("商品名称不能为空！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
gs.strGoodsName = txtGoodsName.Text.Trim();
}
if (txtPrice.Text.Trim() == "")
{
MessageBox.Show("商品单价不能为空！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
gs.dPrice = Double.Parse(txtPrice.Text.Trim());
}
if (txtIgValue.Text.Trim() == "" || txtIgValue.Text.Trim() == "0" || int.Parse(txtIgValue.Text.Trim()) < -1)
{
MessageBox.Show("兑换分值不正确！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
gs.iIgValue = int.Parse(txtIgValue.Text.Trim());
}
gs.strSpell = txtSpell.Text.Trim();
gs.strComments = txtComments.Text.Trim();
err = null;
cs.UpdateGoods(gs, gsold, out err);
if (err != null)
{
MessageBox.Show("修改商品信息失败，请重试！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
sbtnMod.Text = "修改";
txtGoodsID.ReadOnly = false;
sbtnDel.Enabled = true;
sbtnAdd.Enabled = true;
this.ClearText();
this.DgBind();
clog.WriteLine(err);
}
else
{
MessageBox.Show("修改商品信息成功！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
Application.Exit();
}
sbtnMod.Text = "修改";
txtGoodsID.ReadOnly = false;
sbtnDel.Enabled = true;
sbtnAdd.Enabled = true;
this.ClearText();
txtIgValue.Text = "-1";
this.DgBind();
}
}
}
private void sbtnAdd_Click(object sender, System.EventArgs e)
{
CMSMData.CMSMStruct.GoodsStruct gs = new CMSMData.CMSMStruct.GoodsStruct();
err = null;
gs.strGoodsType = this.cmbGoodsType.Text.Trim();
if (!cs.ChkGoodsIDDup(txtGoodsID.Text.Trim(), out err))
{
gs.strGoodsID = txtGoodsID.Text.Trim();
}
else
{
MessageBox.Show("该编号已经存在，请重新输入！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
if (err != null)
{
clog.WriteLine(err);
}
txtGoodsID.Focus();
return;
}
if (txtGoodsName.Text.Trim() == "")
{
MessageBox.Show("商品名称不能为空！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else if (!cs.ChkGoodsNameDup(txtGoodsName.Text.Trim(), out err))
{
gs.strGoodsName = txtGoodsName.Text.Trim();
}
else
{
MessageBox.Show("该商品名称已经存在，请重新输入！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
if (err != null)
{
clog.WriteLine(err);
}
txtGoodsName.Focus();
return;
}
if (txtPrice.Text.Trim() == "")
{
MessageBox.Show("商品单价不能为空！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
gs.dPrice = Double.Parse(txtPrice.Text.Trim());
}
if (txtIgValue.Text.Trim() == "" || txtIgValue.Text.Trim() == "0" || int.Parse(txtIgValue.Text.Trim()) < -1)
{
MessageBox.Show("兑换分值不正确！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
return;
}
else
{
gs.iIgValue = int.Parse(txtIgValue.Text.Trim());
}
gs.strSpell = txtSpell.Text.Trim().ToLower();
gs.strComments = txtComments.Text.Trim();
err = null;
cs.InsertGoods(gs, out err);
if (err != null)
{
MessageBox.Show("添加商品信息失败，请重试！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
}
else
{
MessageBox.Show("添加商品信息成功！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统出错，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
Application.Exit();
}
this.ClearText();
txtIgValue.Text = "-1";
this.DgBind();
}
}
private void simpleButton1_Click(object sender, System.EventArgs e)
{
this.pictureBox1.Visible = true;
this.sbtnClose.Enabled = false;
#region 手动下载更新
DataSet dstmp = new DataSet();
int i = 0;
SqlDataAdapter daTmp;
SqlConnection conCenter = new SqlConnection();
SqlConnection con = new SqlConnection();
SqlCommand cmd;
SqlDataReader drr;
conCenter.ConnectionString = SysInitial.CenterConString;
con.ConnectionString = SysInitial.ConString;
try
{
conCenter.Open();
}
catch (Exception conerr)
{
clog.WriteLine(conerr);
this.listBox1.Items.Add("--------------------------------");
this.listBox1.Items.Add("连接中心数据库失败，请检查网络！");
this.sbtnClose.Enabled = true;
return;
}
con.Open();
using (SqlTransaction transCenter = conCenter.BeginTransaction(IsolationLevel.ReadCommitted))
{
using (SqlTransaction transLocal = con.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
e = null;
string sql, sql2;
this.listBox1.Items.Add("--------------------------------");
this.listBox1.Items.Add("开始加载中心数据库资料...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
sql = "select * from tbCommCode";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenCommCode");
sql = "select * from tbDept";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenDept");
sql = "select * from tbFunc";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenFunc");
sql = "select * from tbOper";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenOper");
sql = "select * from tbOperFunc";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenOperFunc");
sql = "select * from tbRegister";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenRegister");
DateTime dt1MonthBefore = DateTime.Today.AddMonths(-1);
sql = "select * from tbOilPrice where cndPriceDate>='" + dt1MonthBefore.ToShortDateString() + "'";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenOilPrice");
sql = "select * from tbMember";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenMember");
sql = "select * from tbSpecialOilDept";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenSpecOilDept");
sql = "select * from tbConsItem";
cmd = new SqlCommand(sql, con, transLocal);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "LocalConsItem");
sql = "select * from tbMebCompanyPrepay";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenMebCompanyPrepay");
this.listBox1.Items.Add("加载中心数据库资料成功！");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：系统基本参数信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新tbCommCode
sql = "truncate table tbCommCode";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "";
for (i = 0; i < dstmp.Tables["CenCommCode"].Rows.Count; i++)
{
sql += "insert into tbCommCode values('" + dstmp.Tables["CenCommCode"].Rows[i]["cnvcCommName"].ToString() + "','" + dstmp.Tables["CenCommCode"].Rows[i]["cnvcCommCode"].ToString() + "','" + dstmp.Tables["CenCommCode"].Rows[i]["cnvcCommSign"].ToString() + "','" + dstmp.Tables["CenCommCode"].Rows[i]["cnvcComments"].ToString() + "');";
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：系统基本参数信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：部门信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新tbDept
sql = "";
sql = "delete from tbDept where cnvcLocalFlag<>'LOCAL' or cnvcLocalFlag is null";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
CMSMStruct.DeptStruct depts = new CMSMData.CMSMStruct.DeptStruct();
sql = "select * from tbDept where cnvcLocalFlag='LOCAL'";
cmd = new SqlCommand(sql, con, transLocal);
drr = cmd.ExecuteReader();
if (drr.HasRows)
{
drr.Read();
depts.strDeptID = drr[0].ToString();
depts.strDeptName = drr[1].ToString();
depts.strParentDeptID = drr[2].ToString();
depts.strLocalFlag = drr[3].ToString();
drr.Close();
sql = "";
for (i = 0; i < dstmp.Tables["CenDept"].Rows.Count; i++)
{
if (dstmp.Tables["CenDept"].Rows[i]["cnvcDeptID"].ToString() != depts.strDeptID)
{
sql += "insert into tbDept values('" + dstmp.Tables["CenDept"].Rows[i]["cnvcDeptID"].ToString() + "','" + dstmp.Tables["CenDept"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenDept"].Rows[i]["cnvcParentDeptID"].ToString() + "',null);";
}
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
sql = "";
if (depts.strDeptID != "NULL")
{
for (i = 0; i < dstmp.Tables["CenDept"].Rows.Count; i++)
{
if (dstmp.Tables["CenDept"].Rows[i]["cnvcDeptID"].ToString() == depts.strDeptID)
{
if (dstmp.Tables["CenDept"].Rows[i]["cnvcDeptName"].ToString() != depts.strDeptName)
{
sql += "update tbDept set cnvcDeptName='" + dstmp.Tables["CenDept"].Rows[i]["cnvcDeptName"].ToString() + "' where cnvcLocalFlag='LOCAL' and cnvcDeptID='" + depts.strDeptID + "';";
sql += "update tbRegister set cnvcDeptName='" + dstmp.Tables["CenDept"].Rows[i]["cnvcDeptName"].ToString() + "' where cnvcDeptName='" + depts.strDeptName + "';";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "";
break;
}
}
}
}
}
else
{
drr.Close();
sql = "";
for (i = 0; i < dstmp.Tables["CenDept"].Rows.Count; i++)
{
sql += "insert into tbDept values('" + dstmp.Tables["CenDept"].Rows[i]["cnvcDeptID"].ToString() + "','" + dstmp.Tables["CenDept"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenDept"].Rows[i]["cnvcParentDeptID"].ToString() + "',null);";
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
}
#endregion
this.listBox1.Items.Add("更新本地数据：部门信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：功能列表信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新tbFunc
sql = "";
sql = "truncate table tbFunc";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "";
for (i = 0; i < dstmp.Tables["CenFunc"].Rows.Count; i++)
{
sql += "insert into tbFunc values('" + dstmp.Tables["CenFunc"].Rows[i]["cnvcFuncName"].ToString() + "','" + dstmp.Tables["CenFunc"].Rows[i]["cnvcFuncAddress"].ToString() + "','" + dstmp.Tables["CenFunc"].Rows[i]["cnvcFuncType"].ToString() + "');";
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：功能列表信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：操作员信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新tbOper
sql = "";
sql = "truncate table tbOper";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "";
for (i = 0; i < dstmp.Tables["CenOper"].Rows.Count; i++)
{
sql += "insert into tbOper values(" + dstmp.Tables["CenOper"].Rows[i]["cnnOperID"].ToString() + ",'" + dstmp.Tables["CenOper"].Rows[i]["cnvcOperName"].ToString() + "','" + dstmp.Tables["CenOper"].Rows[i]["cnvcPwd"].ToString() + "','" + dstmp.Tables["CenOper"].Rows[i]["cnvcDeptID"].ToString() + "');";
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：操作员信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：操作员权限信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新tbOperFunc
sql = "";
sql = "truncate table tbOperFunc";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "";
for (i = 0; i < dstmp.Tables["CenOperFunc"].Rows.Count; i++)
{
sql += "insert into tbOperFunc values(" + dstmp.Tables["CenOperFunc"].Rows[i]["cnnOperID"].ToString() + ",'" + dstmp.Tables["CenOperFunc"].Rows[i]["cnvcFuncName"].ToString() + "','" + dstmp.Tables["CenOperFunc"].Rows[i]["cnvcFuncAddress"].ToString() + "');";
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：操作员权限信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新tbRegister
sql = "";
sql = "truncate table tbRegister";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "";
for (i = 0; i < dstmp.Tables["CenRegister"].Rows.Count; i++)
{
sql += "insert into tbRegister values('" + dstmp.Tables["CenRegister"].Rows[i]["cnvcHddSerialNo"].ToString() + "','" + dstmp.Tables["CenRegister"].Rows[i]["cnvcRegister"].ToString() + "','" + dstmp.Tables["CenRegister"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenRegister"].Rows[i]["cnvcOperName"].ToString() + "','" + dstmp.Tables["CenRegister"].Rows[i]["cndOperDate"].ToString() + "');";
}
if (sql != "")
{
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：油价信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新本地tbOilPrice
sql2 = "";
for (i = 0; i < dstmp.Tables["CenOilPrice"].Rows.Count; i++)
{
sql = "select count(*) from tbOilPrice where cnnSerialNo='" + dstmp.Tables["CenOilPrice"].Rows[i]["cnnSerialNo"].ToString() + "'";
cmd = new SqlCommand(sql, con, transLocal);
drr = cmd.ExecuteReader();
drr.Read();
int PriceCount = int.Parse(drr[0].ToString());
drr.Close();
if (PriceCount == 0)
{
sql2 += "insert into tbOilPrice values('" + dstmp.Tables["CenOilPrice"].Rows[i]["cnnSerialNo"].ToString() + "','" + dstmp.Tables["CenOilPrice"].Rows[i]["cndPriceDate"].ToString() + "','" + dstmp.Tables["CenOilPrice"].Rows[i]["cnvcGoodsName"].ToString() + "','" + dstmp.Tables["CenOilPrice"].Rows[i]["cnvcGoodsType"].ToString() + "','" + dstmp.Tables["CenOilPrice"].Rows[i]["cnvcUnit"].ToString() + "'," + dstmp.Tables["CenOilPrice"].Rows[i]["cnnOilPrice"].ToString() + ",'" + dstmp.Tables["CenOilPrice"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenOilPrice"].Rows[i]["cnvcDeptID"].ToString() + "');";
}
}
if (sql2 != "")
{
cmd = new SqlCommand(sql2, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：油价信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：会员信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新本地tbMember
sql2 = "";
int MebCount = 0;
for (i = 0; i < dstmp.Tables["CenMember"].Rows.Count; i++)
{
MebCount = 0;
sql = "select count(*) from tbMember where cnvcCardID='" + dstmp.Tables["CenMember"].Rows[i]["cnvcCardID"].ToString() + "'";
cmd = new SqlCommand(sql, con, transLocal);
drr = cmd.ExecuteReader();
drr.Read();
MebCount = int.Parse(drr[0].ToString());
drr.Close();
if (MebCount == 0)
{
sql2 += "insert into tbMember values('" + dstmp.Tables["CenMember"].Rows[i]["cnvcCardID"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcCompanyID"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcCompanyName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcLicenseTag"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcGoodsName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcGoodsType"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcDeptID"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcState"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcComments"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cndCreateDate"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcOperName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cndOperDate"].ToString() + "');";
}
else
{
MebCount = 0;
sql = "select count(*) from tbMember where cnvcCardID='" + dstmp.Tables["CenMember"].Rows[i]["cnvcCardID"].ToString() + "' and cndOperDate<'" + dstmp.Tables["CenMember"].Rows[i]["cndOperDate"].ToString() + "'";
cmd = new SqlCommand(sql, con, transLocal);
drr = cmd.ExecuteReader();
drr.Read();
MebCount = int.Parse(drr[0].ToString());
drr.Close();
if (MebCount > 0)
{
sql2 += "delete from tbMember where cnvcCardID='" + dstmp.Tables["CenMember"].Rows[i]["cnvcCardID"].ToString() + "';";
sql2 += "insert into tbMember values('" + dstmp.Tables["CenMember"].Rows[i]["cnvcCardID"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcCompanyID"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcCompanyName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcLicenseTag"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcGoodsName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcGoodsType"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcDeptID"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcState"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcComments"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cndCreateDate"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cnvcOperName"].ToString() + "','" + dstmp.Tables["CenMember"].Rows[i]["cndOperDate"].ToString() + "');";
}
}
}
if (sql2 != "")
{
cmd = new SqlCommand(sql2, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：会员信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.listBox1.Items.Add("更新本地数据：专供油单位及合同信息...");
this.Refresh();
#region 更新本地tbSpecialOilDept
sql2 = "";
for (i = 0; i < dstmp.Tables["CenSpecOilDept"].Rows.Count; i++)
{
sql = "select count(*) from tbSpecialOilDept where cnvcContractNo='" + dstmp.Tables["CenSpecOilDept"].Rows[i]["cnvcContractNo"].ToString() + "'";
cmd = new SqlCommand(sql, con, transLocal);
drr = cmd.ExecuteReader();
drr.Read();
int SpecDeptCount = int.Parse(drr[0].ToString());
drr.Close();
if (SpecDeptCount == 0)
{
sql2 += "insert into tbSpecialOilDept values('" + dstmp.Tables["CenSpecOilDept"].Rows[i]["cnvcContractNo"].ToString() + "','" + dstmp.Tables["CenSpecOilDept"].Rows[i]["cnvcDeliveryCompany"].ToString() + "')";
}
}
if (sql2 != "")
{
cmd = new SqlCommand(sql2, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
this.listBox1.Items.Add("更新本地数据：专供油单位及合同信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.Refresh();
this.listBox1.Items.Add("更新中心和本地数据：会员单位及余额信息...");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
#region 更新本地tbMebCompanyPrepay
sql2 = "";
for (i = 0; i < dstmp.Tables["CenMebCompanyPrepay"].Rows.Count; i++)
{
sql = "select count(*) from tbMebCompanyPrepay where cnvcCompanyID='" + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnvcCompanyID"].ToString() + "'";
cmd = new SqlCommand(sql, con, transLocal);
drr = cmd.ExecuteReader();
drr.Read();
int MebCompCount = int.Parse(drr[0].ToString());
drr.Close();
if (MebCompCount == 0)
{
sql2 += "insert into tbMebCompanyPrepay values('" + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnvcCompanyID"].ToString() + "','" + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnvcCompanyName"].ToString() + "','" + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnvcAcctID"].ToString() + "'," + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnnPrepayFee"].ToString() + ",'" + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["CenMebCompanyPrepay"].Rows[i]["cnvcDeptID"].ToString() + "');";
}
}
if (sql2 != "")
{
cmd = new SqlCommand(sql2, con, transLocal);
cmd.ExecuteNonQuery();
}
#endregion
#region tbConsItem，并进行余额计算，更新中心和本地
//上传tbConsItem
sql2 = "";
for (i = 0; i < dstmp.Tables["LocalConsItem"].Rows.Count; i++)
{
sql = "select count(*) from tbConsItem where cnnSerial='" + dstmp.Tables["LocalConsItem"].Rows[i]["cnnSerial"].ToString() + "'";
cmd = new SqlCommand(sql, conCenter, transCenter);
drr = cmd.ExecuteReader();
drr.Read();
int ConsCount = int.Parse(drr[0].ToString());
drr.Close();
if (ConsCount == 0)
{
sql2 += "insert into tbConsItem values('" + dstmp.Tables["LocalConsItem"].Rows[i]["cnnSerial"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcCardID"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcLicenseTags"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcGoodsName"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcGoodsType"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcUnit"].ToString() + "'," + dstmp.Tables["LocalConsItem"].Rows[i]["cnnDensity"].ToString() + "," + dstmp.Tables["LocalConsItem"].Rows[i]["cnnKGCount"].ToString() + "," + dstmp.Tables["LocalConsItem"].Rows[i]["cnnCount"].ToString() + "," + dstmp.Tables["LocalConsItem"].Rows[i]["cnnPrice"].ToString() + "," + dstmp.Tables["LocalConsItem"].Rows[i]["cnnFee"].ToString() + ",'" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcComments"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcConsType"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cndConsDate"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcCompanyID"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcCompanyName"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcAcctID"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcDeptID"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcDeptName"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cnvcOperName"].ToString() + "','" + dstmp.Tables["LocalConsItem"].Rows[i]["cndOperDate"].ToString() + "');";
}
}
if (sql2 != "")
{
cmd = new SqlCommand(sql2, conCenter, transCenter);
cmd.ExecuteNonQuery();
}
sql = "insert into tbConsItemHis select * from tbConsItem";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
sql = "truncate table tbConsItem";
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
//计算中心本地部门的单位余额
sql = "select cnvcCompanyID,isnull(sum(cnnFillFee),0) as TolFill from tbFillFee where cnvcDeptID='" + SysInitial.LocalDeptID + "' group by cnvcCompanyID order by cnvcCompanyID";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenCompFill");
sql = "select cnvcCompanyID,isnull(sum(cnnFee),0) as TolCons from tbConsItem where cnvcDeptID='" + SysInitial.LocalDeptID + "' group by cnvcCompanyID union select cnvcCompanyID,0 as TolCons from tbMebCompanyPrepay where cnvcCompanyID not in(select distinct cnvcCompanyID from tbConsItem where cnvcDeptID='" + SysInitial.LocalDeptID + "') order by cnvcCompanyID";
cmd = new SqlCommand(sql, conCenter, transCenter);
daTmp = new SqlDataAdapter(cmd);
daTmp.Fill(dstmp, "CenCompCons");
double TolFill = 0;
double TolCons = 0;
double TolCompPrepay = 0;
for (i = 0; i < dstmp.Tables["CenCompFill"].Rows.Count; i++)
{
for (int j = 0; j < dstmp.Tables["CenCompCons"].Rows.Count; j++)
{
if (dstmp.Tables["CenCompFill"].Rows[i]["cnvcCompanyID"].ToString() == dstmp.Tables["CenCompCons"].Rows[j]["cnvcCompanyID"].ToString())
{
TolFill = double.Parse(dstmp.Tables["CenCompFill"].Rows[i]["TolFill"].ToString());
TolCons = double.Parse(dstmp.Tables["CenCompCons"].Rows[j]["TolCons"].ToString());
TolCompPrepay = TolFill - TolCons;
//修正余额为负更新余额
// if(TolCompPrepay>=0)
// {
//更新中心单位余额
sql = "update tbMebCompanyPrepay set cnnPrepayFee=" + TolCompPrepay.ToString() + " where cnvcCompanyID='" + dstmp.Tables["CenCompFill"].Rows[i]["cnvcCompanyID"].ToString() + "'";
cmd = new SqlCommand(sql, conCenter, transCenter);
cmd.ExecuteNonQuery();
//更新本地单位余额
cmd = new SqlCommand(sql, con, transLocal);
cmd.ExecuteNonQuery();
// }
}
}
}
#endregion
this.listBox1.Items.Add("更新中心和本地数据：会员单位及余额信息更新成功...");
this.listBox1.Items.Add("--------------------------------");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
transLocal.Commit();
transCenter.Commit();
this.listBox1.Items.Add("");
this.listBox1.Items.Add("所有数据更新完成！");
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
this.Refresh();
this.pictureBox1.Visible = false;
this.sbtnClose.Enabled = true;
Exception err = null;
SysInitial.CreatDS(out err);
if (err != null)
{
MessageBox.Show("系统参数刷新失败，将自动关闭，稍后请重新登录系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
clog.WriteLine(err);
Application.Exit();
}
}
catch (Exception err)
{
transLocal.Rollback();
transCenter.Rollback();
if (con.State == ConnectionState.Open)
{
con.Close();
}
if (conCenter.State == ConnectionState.Open)
{
conCenter.Close();
}
clog.WriteLine(err);
this.listBox1.Items.Add("----------------------------------------------------------------------");
this.listBox1.Items.Add("更新过程中发生意外错误，更新未完全！");
this.listBox1.Items.Add("----------------------------------------------------------------------");
MessageBox.Show("更新过程中发生意外错误，更新未完全，请重新选择手工更新或重新启动系统！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
this.sbtnClose.Enabled = true;
return;
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
if (conCenter.State == ConnectionState.Open)
{
conCenter.Close();
}
#endregion
}
