private void BtnNumber_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
OutRuturnStorageEDIT ors;
switch (btn.Name)
{
case "New": //数据参数新增
ors = new OutRuturnStorageEDIT("", 1);
ors.ShowDialog();
break;
case "Edit": //数据参数新增
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "等待寄回" || WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "确认收货" || WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "等待收货") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
SqlConnection conn = sqlcon.getcon("");
conn.Open();
int ID_ = WPHbROWDGV.CurrentCell.RowIndex;
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('修改','" + DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "','" + frmlogin.userID + "');", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
ors = new OutRuturnStorageEDIT(WPHbROWDGV[5, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString(), 2);
ors.ShowDialog();
brows();
WPHbROWDGV.Rows[ID_].Selected = true;
}
else
{
MessageBox.Show("此状态不能修改单据！！");
}
}
else
{
MessageBox.Show("没有你要修改的数据！！");
}
break;
case "Select": //数据参数新增
if (WPHbROWDGV.Rows.Count > 0)
{
ors = new OutRuturnStorageEDIT(WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString(), 0);
ors.ShowDialog();
BTNbROW_Click(sender, e);
}
break;
case "ERPlook": //ERP审核
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "确认收货") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
int ID_ = WPHbROWDGV.CurrentCell.RowIndex;
SqlConnection conn = sqlcon.getcon("");
conn.Open();
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('ERP审核','" + DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString().Trim() + "','" + frmlogin.userID + "');update CS_OutRuturnStorage set Type='6' where OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString().Trim() + "' and type='3'", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
WPHbROWDGV.Rows[ID_].Selected = true;
brows();
}
else
{
MessageBox.Show("要先确认收货才可以审核！！");
}
}
break;
case "CK": //从新发货
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["CadeType"].Value.ToString() != "退货" && WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "ERP已审核") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
OutStorageEdit orsE = new OutStorageEdit(WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString(), 1);
orsE.ShowDialog();
brows();
}
else
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() != "ERP已审核") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
MessageBox.Show("此单ERP未审核不能从新发货！！");
}
else
{
MessageBox.Show("此单为退货不能从新发货！！");
}
}
}
break;
case "look": //退款审核
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["CadeType"].Value.ToString() == "退货" && WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "ERP已审核") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
String PM = Interaction.InputBox("请输入金额", "输入金额", WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["SumMoney"].Value.ToString(), 70, 100);
if (PM != string.Empty)
{
SqlConnection conn = sqlcon.getcon("");
conn.Open();
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('退款审核','" + DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "','" + frmlogin.userID + "'); update CS_OutRuturnStorage set Type='5',sumMoney='" + PM + "' where OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "'and BarCode='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["BarCode"].Value.ToString() + "'", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
brows();
}
}
else
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() != "ERP已审核") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
MessageBox.Show("此单ERP未审核不能退款！！");
}
else
{
MessageBox.Show("此单不是退货不能退款！！");
}
}
}
break;
case "Canle": //作废
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "等待寄回" || WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "等待收货") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
String PM = Interaction.InputBox("请输入原因", "输入原因", "", 70, 100);
if (PM != string.Empty)
{
int ID_ = WPHbROWDGV.CurrentCell.RowIndex;
SqlConnection conn = sqlcon.getcon("");
conn.Open();
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('作废','"
+ DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "','" + frmlogin.userID +
"');update CS_OutRuturnStorage set Type='0',Remarks='(" + PM + ")" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Remarks"].Value.ToString() +
"' where OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "'", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
WPHbROWDGV.Rows[ID_].Selected = true;
brows();
}
}
else
{
MessageBox.Show("要先确认收货才可以作废！！");
}
}
break;
case "ReturnCanle": //取消作废
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "订单关闭") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
int ID_ = WPHbROWDGV.CurrentCell.RowIndex;
SqlConnection conn = sqlcon.getcon("");
conn.Open();
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('取消作废','" + DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "','" + frmlogin.userID + "');update CS_OutRuturnStorage set Type='1' where OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "'", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
WPHbROWDGV.Rows[ID_].Selected = true;
brows();
}
else
{
MessageBox.Show("该订单没有关闭不能取消关闭！！");
}
}
break;
case "Returnlook": //取消退款
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "退款完毕") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
int ID_ = WPHbROWDGV.CurrentCell.RowIndex;
SqlConnection conn = sqlcon.getcon("");
conn.Open();
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('取消退款','" + DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "','" + frmlogin.userID + "');update CS_OutRuturnStorage set Type='6' where OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "'", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
WPHbROWDGV.Rows[ID_].Selected = true;
brows();
}
else
{
MessageBox.Show("要先确认收货才可以审核！！");
}
}
break;
case "ReturnERPlook": //取消审核
if (WPHbROWDGV.Rows.Count > 0)
{
if (WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Type"].Value.ToString() == "ERP已审核") //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
int ID_ = WPHbROWDGV.CurrentCell.RowIndex;
SqlConnection conn = sqlcon.getcon("");
conn.Open();
SqlCommand sqlcom = new SqlCommand("insert into CS_OutRuturnStorageOperate (Operate,Operatedatetime,OrderCade,username)values('取消审核','" + DateTime.Now.ToString() + "','" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "','" + frmlogin.userID + "');update CS_OutRuturnStorage set Type='3' where OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "'", conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
WPHbROWDGV.Rows[ID_].Selected = true;
brows();
}
else
{
MessageBox.Show("要先确认收货才可以取消审核！！");
}
}
break;
case "Operate":
if (WPHbROWDGV.Rows.Count > 0)
{
Common.CommonForm comm = new Common.CommonForm("OrderCade='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["OrderCade"].Value.ToString() + "'", "CS_OutRuturnStorageOperate");
comm.ShowDialog();
}
break;
}
}
private void TxtBarCode_KeyDown(object sender, KeyEventArgs e)
{
SqlConnection conn = sqlcon.getcon("");
DataSet ds = new DataSet();
if (e.KeyCode == Keys.Enter)
{
string strsql = "select ID,Case when type>2 then CAST ('True' as bit) else CAST ('False' as bit)end as ok,ShopName,CadeType,case when type=1 then '等待寄回' when type=2 then '等待收货' when type=3 then '确认收货' when type=4 then '换货完毕' when type=5 then '退款完毕' when type=6 then 'ERP已审核' else '订单关闭' end type,CadeDate,barCodeDate,VipName,Mobile,OrderCade,BarCode,Remarks,ExpressName,ExpressBarCode," +
"userName from CS_OutRuturnStorage where type>0 and (OrderCade like '%" + TxtBarCode.Text.ToString() + "%' or VipName='" + TxtBarCode.Text.ToString() + "' or ExpressBarCode='" + TxtBarCode.Text.ToString() + "' or Mobile='" + TxtBarCode.Text.ToString() + "')";
SqlDataAdapter sqlDaper = new SqlDataAdapter(strsql, conn);
conn.Open();
sqlDaper.Fill(ds);
conn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
ProudctDGV.DataSource = ds.Tables[0];
ProudctDGV.Columns["ShopName"].HeaderText = "店铺";
ProudctDGV.Columns["ok"].HeaderText = "选";
ProudctDGV.Columns["ok"].Width = 45;
ProudctDGV.Columns["ShopName"].ReadOnly = true;
ProudctDGV.Columns["CadeType"].HeaderText = "类型";
ProudctDGV.Columns["CadeType"].Width = 60;
ProudctDGV.Columns["CadeType"].ReadOnly = true;
ProudctDGV.Columns["VipName"].HeaderText = "会员";
ProudctDGV.Columns["VipName"].ReadOnly = true;
ProudctDGV.Columns["Mobile"].HeaderText = "电话";
ProudctDGV.Columns["Mobile"].ReadOnly = true;
ProudctDGV.Columns["OrderCade"].HeaderText = "订单";
ProudctDGV.Columns["OrderCade"].ReadOnly = true;
ProudctDGV.Columns["CadeDate"].HeaderText = "登记日期";
ProudctDGV.Columns["CadeDate"].ReadOnly = true;
ProudctDGV.Columns["BarCodeDate"].HeaderText = "收货日期";
ProudctDGV.Columns["BarCodeDate"].ReadOnly = false;
ProudctDGV.Columns["BarCode"].HeaderText = "货品条码";
ProudctDGV.Columns["BarCode"].ReadOnly = true;
ProudctDGV.Columns["Remarks"].HeaderText = "问题";
ProudctDGV.Columns["Remarks"].ReadOnly = true;
ProudctDGV.Columns["Type"].HeaderText = "状态";
ProudctDGV.Columns["Type"].ReadOnly = true;
ProudctDGV.Columns["ExpressName"].HeaderText = "退回快递公司";
ProudctDGV.Columns["ExpressBarCode"].HeaderText = "退回快递单";
ProudctDGV.Columns["UserName"].HeaderText = "操作员";
ProudctDGV.Columns["UserName"].ReadOnly = true;
ProudctDGV.Columns["ID"].Visible = false;
for (int i = 0; i < ProudctDGV.Rows.Count; i++)
{
if (ProudctDGV.Rows[i].Cells["barCodeDate"].Value.ToString().Trim() == "")
{
ProudctDGV.Rows[i].Cells["barCodeDate"].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
}
//ProudctDGV.Columns["barCodeDate"].Visible = false;
}
else
{
DialogResult result = MessageBox.Show("没有此相关信息，“是”新增退货单,“否”输入无信息", "消息提示！", MessageBoxButtons.YesNoCancel);
if (result == DialogResult.Yes)
{
OutRuturnStorageEDIT ors = new OutRuturnStorageEDIT("", 3);
ors.ShowDialog();
}
else if (result == DialogResult.No)
{
OutRuturnNOinforMation ornm = new OutRuturnNOinforMation("");
ornm.ShowDialog();
}
else
{
return;
}
}
TxtBarCode.Text = "";
}
}
