private void BtnAdd_Click(object sender, EventArgs e)
{
rStorageNew rsn = new rStorageNew(0, 1);
rsn.ShowDialog();
brows();
}
private void BtnNumber_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
rStorageNew ors;
switch (btn.Name)
{
case "New": //数据参数新增
ors = new rStorageNew(0, 1);
ors.ShowDialog();
brows();
break;
case "Select": //数据参数查看
if (WPHbROWDGV.Rows.Count > 0)
{
rStorageNew rsn = new rStorageNew(Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()), 0);
rsn.ShowDialog();
brows();
}
break;
case "Edit": //数据参数修改
if (WPHbROWDGV.Rows.Count > 0)
{
if (Convert.ToInt32(WPHbROWDGV[10, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) == 1) //取状态为1的才能修改，0为作废，1为编辑，2为审核
{
ors = new rStorageNew(Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()), 1);
ors.ShowDialog();
brows();
}
else
{
MessageBox.Show("此单据不能修改！！");
}
}
else
{
MessageBox.Show("没有你要修改的数据！！");
}
break;
case "ToVoid": //作废
if (WPHbROWDGV.Rows.Count > 0)
{
if (Convert.ToInt32(WPHbROWDGV[10, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) == 1)
{
SqlConnection conn = sqlcon.getcon("");
string sql = "SELECT RID from BR_PassToStockReturn where Rid='" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) +
"' union all SELECT RID from BR_PassToStock where Rid='" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "'";
SqlDataAdapter sqlDaper = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
conn.Open();
sqlDaper.Fill(ds, "RID");
conn.Close();
if (ds.Tables["RID"].Rows.Count > 0)
{
MessageBox.Show("此单于生成入库（退货）不能作废！！");
return;
}
//SqlConnection conn = sqlcon.getcon("");
conn.Open();
string str = "insert into BR_RstorageOperateList (Operate,Operatedatetime,RID,username)values('作废','" + DateTime.Now.ToString() + "','" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "','" + frmlogin.userID + "')" +
"update BR_RStorageList set listtype=0 where id='" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "'";
SqlCommand sqlcom = new SqlCommand(str, conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
BTNbROW_Click(sender, e);
MessageBox.Show("此单作废！！");
}
else
{
MessageBox.Show("此单已审核或已作废不能作废！！");
}
}
break;
case "look": //审核
if (WPHbROWDGV.Rows.Count > 0)
{
if (Convert.ToInt32(WPHbROWDGV[10, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) == 1)
{
SqlConnection conn = sqlcon.getcon("");
string str = "insert into BR_RstorageOperateList (Operate,Operatedatetime,RID,username)values('审核','" + DateTime.Now.ToString() + "','" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "','" + frmlogin.userID + "')" +
"update BR_RStorageList set listtype=2 where id='" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "'";
conn.Open();
SqlCommand sqlcom = new SqlCommand(str, conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
MessageBox.Show("审核成功！！");
string sql = "SELECT * from M_user where mobile !=''";
string sqlstr = "select item_no,s_color,mobile,sum(qty)qty from BR_PassToStock " +
"left join M_DProductSubscribe on M_DProductSubscribe.pid=BR_PassToStock.pid " +
"left join m_user on M_DProductSubscribe.username=m_user.username " +
"left join M_product on M_product.id=BR_PassToStock.pid " +
"left join M_productsub on M_productsub.id=BR_PassToStock.ColourID " +
"where BR_PassToStock.rid='" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "' group by item_no,s_color,mobile";
SqlDataAdapter sqldaper2 = new SqlDataAdapter("select * from M_ShortMessage", conn);
SqlDataAdapter sqlDaper = new SqlDataAdapter(sql, conn);
SqlDataAdapter sqlDaper1 = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
conn.Open();
sqlDaper1.Fill(ds, "Data");
sqldaper2.Fill(ds, "MSM");
sqlDaper.Fill(ds, "RID");
conn.Close();
if (ds.Tables["MSM"].Rows[0]["Type"].ToString() == "True")
{
for (int i = 0; i < ds.Tables["RID"].Rows.Count; i++)
{
string strs = "";
for (int j = 0; j < ds.Tables["Data"].Rows.Count; j++)
{
if (ds.Tables["RID"].Rows[i]["mobile"].ToString() == ds.Tables["Data"].Rows[j]["mobile"].ToString())
{
strs += ds.Tables["Data"].Rows[j]["item_no"].ToString() + "." + ds.Tables["Data"].Rows[j]["s_color"].ToString() + "." + ds.Tables["Data"].Rows[j]["qty"].ToString() + "|";
}
}
if (strs != "" && ds.Tables["RID"].Rows[i]["mobile"].ToString() != "")
{
SMS.GETpost("ac=send&uid=" + ds.Tables["MSM"].Rows[0]["UserName"].ToString() +
"&pwd=" + ds.Tables["MSM"].Rows[0]["PWD"].ToString() + "&mobile=" + ds.Tables["RID"].Rows[i]["mobile"].ToString() +
"&content=", ds.Tables["MSM"].Rows[0]["IPAdd"].ToString(), strs + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["Cade"].Value.ToString() + "&encode=utf8");
///http://api.cnsms.cn/?ac=send&uid=100860&pwd=fa246d0262c3925617b0c72bb20eeb1d&mobile=15102110086,18297974783&content=%D6%D0%B9%FA%B6%CC%D0%C5%CD%F8%B7%A2%CB%CD%B2%E2%CA%D4
}
}
}
BTNbROW_Click(sender, e);
}
else
{
MessageBox.Show("此单已审核或已作废不能作废！！");
}
}
break;
case "Returnlook": //反审核
if (WPHbROWDGV.Rows.Count > 0)
{
if (Convert.ToInt32(WPHbROWDGV[10, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) == 2)
{
SqlConnection conn = sqlcon.getcon("");
conn.Open();
string str = "insert into BR_RstorageOperateList (Operate,Operatedatetime,RID,username)values('反审','" + DateTime.Now.ToString() + "','" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "','" + frmlogin.userID + "')" +
"update BR_RStorageList set listtype=1 where id='" + Convert.ToInt32(WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString()) + "'";
SqlCommand sqlcom = new SqlCommand(str, conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
BTNbROW_Click(sender, e);
MessageBox.Show("此单可以修改！！");
}
else
{
MessageBox.Show("此单没有审核不能反审！！");
}
}
break;
case "Operate": //日志
if (WPHbROWDGV.Rows.Count > 0)
{
Common.CommonForm comm = new Common.CommonForm("RID='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["ID"].Value.ToString() + "'", "BR_RstorageOperateList");
comm.ShowDialog();
}
break;
}
}
