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(); } }