private void btn_save_Click(object sender, EventArgs e)
{
//保存刷单记录
if (sr != null)
{
sr.sddate = DateTime.Now;
sr.sdremark2 = "1";
sr.sdremark3 = "1";
sr.sdremark4 = "1";
sr.sdremark6 = "2";
sr.sdstatepay = isauto ? "1" : "2";
if (ispayed)
{
sr.sdstatepay = "1";
}
try
{
string sqlcom = "server=sqloledb;data source=qds16257965.my3w.com;User ID=qds16257965;pwd=QW013368zj@;Initial Catalog=qds16257965_db";
SqlConnection com = new SqlConnection(sqlcom);
com.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = com;
if (!string.IsNullOrEmpty(sr.sdorderid))
{
cmd.CommandText = "select count(*) from shuadan_records where sdorderid = '" + sr.sdorderid + "'";
int res = (int)cmd.ExecuteScalar();
if (res != 0)
{
res.ToString().ToShow();
}
if (res > 0)
{
this.Text = "订单" + sr.sdorderid + "已经存储";
return;
}
}
cmd.CommandText = "insert into shuadan_records (sdgoodsname,sdgoodsurl,sddptype,sddate,sdorderid,sdphone,sdvpn,sdaddress,sdwuliu,sdremark1,sdremark3,sdremark2,sdremark4,sdremark5,sdremark6,sdstatepay,sdremark7,sdremark8,sdremark9,sdremark10)values(@sdgoodsname,@sdgoodsurl,@sddptype,@sddate,@sdorderid,@sdphone,@sdvpn,@sdaddress,@sdwuliu,@sdremark1,@sdremark3,@sdremark2,@sdremark4,@sdremark5,@sdremark6,@sdstatepay,@sdremark7,@sdremark8,@sdremark9,@sdremark10)";
SqlParameter[] sp = GetSqlParameters(sr);
cmd.Parameters.AddRange(sp);
int result = cmd.ExecuteNonQuery();
com.Close();
}
catch (Exception ex)
{
ex.ToShow();
}
if (isauto)
{
this.Text = "保存成功,付款成功";
}
else
{
"添加记录成功".ToShow();
}
sr = null;
}
}
public CefBrowser()
{
InitializeComponent();
Cef.EnableHighDPISupport();
System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;//用于多线程访问控件
//获取启动参数
string[] CmdArgs = System.Environment.GetCommandLineArgs();
#region bak
//for (int i = 0; i < CmdArgs.Length; i++)
//{
// //参数0是它本身的路径
// MessageBox.Show(CmdArgs[i]);
//}
//测试
//string args = "{'sdid':0,'sdgoodsname':null,'sdgoodsurl':'mobile.yangkeduo.com/duo_coupon_landing.html?goods_id=2586741146&pid=9648809_137935113&cpsSign=CC_200423_9648809_137935113_15965411c45e29c13611906b9a2940fa&duoduo_type=3','sddptype':'3','sddate':'0001-01-01T00:00:00','sdorderid':null,'sdphone':'4412705686695','sdvpn':'58.218.214.132:8063','sdaddress':'T5QQT6PDG2ZZ2NREK3VTJ2PUTW6XRVRSGFHQ4CY5NAPWIUYA4AQQ110a782','sdwuliu':null,'sdremark1':null,'sdremark3':null,'sdremark2':null,'sdremark4':null,'sdremark5':null,'sdremark6':'2'}";
//sr = Newtonsoft.Json.JsonConvert.DeserializeObject<Entity.shuadan_records>(args);
//if (sr != null)
//{
// sr.sddate = DateTime.Now;
//}
//return;
//string args = "{sdid:0,sdgoodsname:null,sdgoodsurl:mobile.yangkeduo.com/duo_coupon_landing.html?goods_id=2586741146&pid=9648809_137935113&cpsSign=CC_200423_9648809_137935113_15965411c45e29c13611906b9a2940fa&duoduo_type=3,sddptype:3,sddate:0001-01-01T00:00:00,sdorderid:null,sdphone:4412705686695,sdvpn:58.218.214.132:8063,sdaddress:T5QQT6PDG2ZZ2NREK3VTJ2PUTW6XRVRSGFHQ4CY5NAPWIUYA4AQQ110a782,sdwuliu:null,sdremark1:null,sdremark3:null,sdremark2:null,sdremark4:null,sdremark5:null,sdremark6:2}";
//sr = new Entity.shuadan_records();
//string[] agrs = args.ToSplit(",");
//foreach (var item in agrs)
//{
// string[] agrs2 = item.ToSplit(":");
// string temp = agrs2[0];
// if (agrs2[0] == "sdgoodsurl")
// {
// sr.sdgoodsurl = agrs2[1];
// }
// else if (agrs2[0] == "sddptype")
// {
// sr.sddptype = agrs2[1];
// }
// else if (agrs2[0] == "sdphone")
// {
// sr.sdphone = agrs2[1];
// }
// else if (agrs2[0] == "sdvpn")
// {
// sr.sdvpn = agrs2[1];
// }
// else if (agrs2[0] == "sdaddress")
// {
//sr.sdaddress = agrs2[1];
// }
//}
//测试插入数据
//sr = new Entity.shuadan_records();
//sr.sdgoodsurl = "";
//sr.sddptype = "3";
//sr.sdphone = "5472535098";
//sr.sdvpn = "";
//sr.sdaddress = "OTGXAXDS5ICX4SEZBBTK5GPG7B3GW6K7KBVRYF5RXSVEIOSMLBJQ1123a4a";
//bind();
//return;
#endregion
//CmdArgs.Length.ToString().ToShow();
if (CmdArgs.Length > 1)
{
// txt_url.Text = CmdArgs[1];
//CmdArgs[1].ToShow();
try
{
sr = new Entity.shuadan_records();
string[] agrs = CmdArgs[1].ToSplit(",");
foreach (var item in agrs)
{
//item.ToShow();
string[] agrs2 = item.ToSplit(":");
if (agrs2.Length > 1)
{
string temp = agrs2[0];
if (temp == "sdgoodsurl")
{
sr.sdgoodsurl = agrs2[1];
}
else if (temp == "sddptype")
{
sr.sddptype = agrs2[1];
}
else if (temp == "sdphone")
{
sr.sdphone = agrs2[1];
}
else if (temp == "sdvpn")
{
try
{
sr.sdvpn = agrs2[1] + ":" + agrs2[2];
}
catch { }
}
else if (temp == "sdaddress")
{
sr.sdaddress = agrs2[1];
}
}
}
sr.sddate = DateTime.Now;
sr.sdremark6 = "2";
//sr = Newtonsoft.Json.JsonConvert.DeserializeObject<Entity.shuadan_records>(CmdArgs[1].Replace("\"","'"));
//if (sr != null)
//{
// sr.sddate = DateTime.Now;
//}
}
catch (Exception ex)
{
ex.ToShow();
sr = null;
}
}
if (CmdArgs.Length > 2)
{
try
{
string temp = CmdArgs[2];
bool.TryParse(temp, out isauto);
}
catch
{
}
}
if (CmdArgs.Length > 3)
{
try
{
string temp = CmdArgs[3];
bool.TryParse(temp, out ispayed);
}
catch
{
}
}
//MessageBox.Show(isauto.ToString());
if (sr != null)
{
bind(sr.sdgoodsurl);
txt_url.Text = sr.sdgoodsurl;
}
else
{
bind();
}
}
