/// <summary> /// 模糊搜索 /// </summary> /// <param name="s">起始位置1</param> /// <param name="e">结束位置</param> /// <param name="key">关键词</param> /// <param name="state">店铺类型</param> /// <param name="state_kongbao">空包状态</param> /// <param name="state_fahuo">发货状态</param> /// <param name="startdate">开始时间</param> /// <param name="enddate">结束时间</param> /// <param name="orderby">排序方式</param> /// <returns></returns> public IList <shuadan_records> Search(int s, int e, string key, string state, string orderstate, string state_kongbao, string state_shoucai, string state_fahuo, DateTime startdate, DateTime enddate, string orderby) { string sql1 = "select * from shuadan_records where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( sdgoodsname like '%" + key + "%' or sdgoodsurl like '%" + key + "%' or sdorderid like '%" + key + "%' or sdphone like '%" + key + "%' or sdvpn like '%" + key + "%' or sdaddress like '%" + key + "%' or sdwuliu like '%" + key + "%' or sdremark1 like '%" + key + "%' or sdremark3 like '%" + key + "%' or sdremark2 like '%" + key + "%' or sdremark4 like '%" + key + "%' or sdremark5 like '%" + key + "%' or sdremark6 like '%" + key + "%' )"; //删除无用字段,删除最后一个or string sql3 = string.IsNullOrEmpty(state) ? "" : " and sddptype= '" + state + "' "; //状态字段,无用删除 string sql33 = string.IsNullOrEmpty(orderstate) ? "" : " and sdremark6= '" + orderstate + "' "; //状态字段,无用删除 string sql4 = string.IsNullOrEmpty(state_kongbao) ? "" : " and sdremark3= '" + state_kongbao + "' "; string sql44 = string.IsNullOrEmpty(state_fahuo) ? "" : " and sdremark4= '" + state_fahuo + "' "; string sql45 = string.IsNullOrEmpty(state_shoucai) ? "" : " and sdremark2= '" + state_shoucai + "' "; //string sql4 = id == 0 ? "" : " and id字段='" + id.ToString() + "' ";//Int字段,无用删除 string sql5 = startdate == new DateTime() ? "" : " and DATEDIFF(D,'" + startdate.ToString("yyyy-MM-dd") + "',sddate)>=0 "; //时间字段,无用删除 string sql6 = enddate == new DateTime() ? "" : " and DATEDIFF(D,'" + enddate.ToString("yyyy-MM-dd") + "',sddate)<=0 "; //时间字段,无用删除 string sql7 = string.IsNullOrEmpty(orderby) ? " order by sddate asc " : " order by " + orderby; string sql10 = e == 0 ? " " : " limit " + s + "," + e; DBHelper.sqlstr = sql1 + sql2 + sql3 + sql33 + sql4 + sql44 + sql45 + sql5 + sql6 + sql7 + sql10; List <shuadan_records> list = new List <shuadan_records>(); MySqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_records Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 从一个SqlDataReader里读数据 /// </summary> /// <param name="Reader">SqlDataReader</param> /// <returns>shuadan_recordsExample</returns> public static shuadan_records GetByReader(SqlDataReader Reader) { shuadan_records shuadan_recordsExample = new shuadan_records(); shuadan_recordsExample.sdid = Reader["sdid"] == DBNull.Value ? 0 : (int)Reader["sdid"]; shuadan_recordsExample.sdgoodsname = Reader["sdgoodsname"] == DBNull.Value ? null : Reader["sdgoodsname"].ToString(); shuadan_recordsExample.sdgoodsurl = Reader["sdgoodsurl"] == DBNull.Value ? null : Reader["sdgoodsurl"].ToString(); shuadan_recordsExample.sddptype = Reader["sddptype"] == DBNull.Value ? null : Reader["sddptype"].ToString(); shuadan_recordsExample.sddate = Reader["sddate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["sddate"]); shuadan_recordsExample.sdorderid = Reader["sdorderid"] == DBNull.Value ? null : Reader["sdorderid"].ToString(); shuadan_recordsExample.sdphone = Reader["sdphone"] == DBNull.Value ? null : Reader["sdphone"].ToString(); shuadan_recordsExample.sdvpn = Reader["sdvpn"] == DBNull.Value ? null : Reader["sdvpn"].ToString(); shuadan_recordsExample.sdaddress = Reader["sdaddress"] == DBNull.Value ? null : Reader["sdaddress"].ToString(); shuadan_recordsExample.sdwuliu = Reader["sdwuliu"] == DBNull.Value ? null : Reader["sdwuliu"].ToString(); shuadan_recordsExample.sdremark1 = Reader["sdremark1"] == DBNull.Value ? null : Reader["sdremark1"].ToString(); shuadan_recordsExample.sdremark3 = Reader["sdremark3"] == DBNull.Value ? null : Reader["sdremark3"].ToString(); shuadan_recordsExample.sdremark2 = Reader["sdremark2"] == DBNull.Value ? null : Reader["sdremark2"].ToString(); shuadan_recordsExample.sdremark4 = Reader["sdremark4"] == DBNull.Value ? null : Reader["sdremark4"].ToString(); shuadan_recordsExample.sdremark5 = Reader["sdremark5"] == DBNull.Value ? null : Reader["sdremark5"].ToString(); shuadan_recordsExample.sdremark6 = Reader["sdremark6"] == DBNull.Value ? null : Reader["sdremark6"].ToString(); shuadan_recordsExample.sdstatepay = Reader["sdstatepay"] == DBNull.Value ? null : Reader["sdstatepay"].ToString(); shuadan_recordsExample.sdremark7 = Reader["sdremark7"] == DBNull.Value ? null : Reader["sdremark7"].ToString(); shuadan_recordsExample.sdremark8 = Reader["sdremark8"] == DBNull.Value ? null : Reader["sdremark8"].ToString(); shuadan_recordsExample.sdremark9 = Reader["sdremark9"] == DBNull.Value ? null : Reader["sdremark9"].ToString(); shuadan_recordsExample.sdremark10 = Reader["sdremark10"] == DBNull.Value ? null : Reader["sdremark10"].ToString(); return(shuadan_recordsExample); }
/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <shuadan_records> SearchAll() { DBHelper.sqlstr = "select * from shuadan_records order by sddate desc "; List <shuadan_records> list = new List <shuadan_records>(); MySqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_records Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_records">shuadan_records表实例</param> /// <returns>int</returns> public static int Insert(shuadan_records shuadan_recordsExample) { //判断是否已经存在如果已经有了则不保存 if (!string.IsNullOrEmpty(shuadan_recordsExample.sdorderid)) { int count = SearchNum(shuadan_recordsExample.sdorderid, "", "", "", "", new DateTime(), new DateTime()); if (count > 0) { return(0); } } return(Service.Insert(shuadan_recordsExample)); }
// #region SearchWeiFaHuo /// <summary> /// 查询未发货信息 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <shuadan_records> SearchWeiFaHuo(string t) { //DBHelper.sqlstr = "SELECT * FROM shuadan_records where 1=1 and ( sdwuliu ='' or sdwuliu is null ) " + (string.IsNullOrEmpty(t) ? "" : " and sddptype ='" + t + "' "); DBHelper.sqlstr = "SELECT * FROM shuadan_records where 1=1 and sdremark4 ='1' and sddptype ='" + t + "'"; List <shuadan_records> list = new List <shuadan_records>(); MySqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_records Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 根据sdid,查询一条数据 /// </summary> /// <param name="sdid"></param> /// <returns></returns> /*查看是否为视图*/ public shuadan_records SearchByID(int sdid) { DBHelper.sqlstr = "select * from shuadan_records where sdid = @sdid"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("@sdid", sdid) }; MySqlDataReader reader = DBHelper.ExecuteReader(param); shuadan_records Obj = null; if (reader.Read()) { Obj = GetByReader(reader); } reader.Close(); return(Obj); }
/// <summary> /// 获取补单需要的地址信息 /// </summary> /// <param name="num">获取的条数</param> /// <param name="indexx">从这里开始</param> /// <returns></returns> public IList <shuadan_records> SearchToBuDan_GetAddress(int num, int indexx) { string sql1 = "select * from shuadan_records where "; string sql2 = " [sdaddress] <>'' and [sdaddress] IS NOT NULL AND [sdid] NOT IN (select top " + indexx.ToString() + " [sdid] from [shuadan_records] WHERE [sdaddress] <>'' and [sdaddress] IS NOT NULL ) order by [sdid] ASC limit " + num.ToString(); DBHelper.sqlstr = sql1 + sql2; List <shuadan_records> list = new List <shuadan_records>(); MySqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_records Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
private void dgv_title_CellParsing(object sender, DataGridViewCellParsingEventArgs e) { try { //int i = dgv_title.CurrentCell.ColumnIndex; string colname = dgv_title.Columns[dgv_title.CurrentCell.ColumnIndex].Name; //if (dgv_title.CurrentCell.ColumnIndex == 1 || dgv_title.CurrentCell.ColumnIndex == 2 || dgv_title.CurrentCell.ColumnIndex == 3 || dgv_title.CurrentCell.ColumnIndex == 4 || dgv_title.CurrentCell.ColumnIndex == 7) if (colname.Equals("col_phone") || colname.Equals("col_orderid") || colname.Equals("col_wuliu") || colname.Equals("col_vpn") || colname.Equals("col_address") || colname.Equals("col_remark")) { shuadan_records og = (shuadan_records)dgv_title.CurrentRow.DataBoundItem; if (og != null) { string phone = dgv_title.Rows[e.RowIndex].Cells[2].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[2].EditedFormattedValue.ToString(); string orderid = dgv_title.Rows[e.RowIndex].Cells[3].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[3].EditedFormattedValue.ToString(); string wuliu = dgv_title.Rows[e.RowIndex].Cells[4].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[4].EditedFormattedValue.ToString(); string remark = dgv_title.Rows[e.RowIndex].Cells[10].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[10].EditedFormattedValue.ToString(); string vpnadd = dgv_title.Rows[e.RowIndex].Cells[11].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[11].EditedFormattedValue.ToString(); string dates = dgv_title.Rows[e.RowIndex].Cells[12].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[12].EditedFormattedValue.ToString(); string goodsname = dgv_title.Rows[e.RowIndex].Cells[13].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[13].EditedFormattedValue.ToString(); string address = dgv_title.Rows[e.RowIndex].Cells[14].EditedFormattedValue == null ? "" : dgv_title.Rows[e.RowIndex].Cells[14].EditedFormattedValue.ToString(); og.sdaddress = address; og.sdorderid = orderid; og.sdphone = phone; og.sdvpn = vpnadd; og.sdwuliu = wuliu; og.sdremark5 = remark; BLL2.shuadan_recordsManager.Update(og); } } } catch (Exception ex) { Debug.WriteLine("修改信息失败 " + ex.Message); } }
/// <summary> /// 模糊搜索 /// </summary> /// <param name="key">关键词</param> /// <param name="state_pay">店铺类型</param> /// <param name="state_fahuo">发货状态</param> /// <returns></returns> public IList <shuadan_records> Search(string key, string state_pay, string state_fahuo) { string sql1 = "select * from shuadan_records where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( sdgoodsname like '%" + key + "%' or sdgoodsurl like '%" + key + "%' or sdorderid like '%" + key + "%' or sdphone like '%" + key + "%' or sdvpn like '%" + key + "%' or sdaddress like '%" + key + "%' or sdwuliu like '%" + key + "%' or sdremark1 like '%" + key + "%' or sdremark3 like '%" + key + "%' or sdremark2 like '%" + key + "%' or sdremark4 like '%" + key + "%' or sdremark5 like '%" + key + "%' or sdremark6 like '%" + key + "%' )"; //删除无用字段,删除最后一个or string sql3 = string.IsNullOrEmpty(state_pay) ? "" : " and sdstatepay= '" + state_pay + "' and sddptype='3' "; //状态字段,无用删除 string sql4 = string.IsNullOrEmpty(state_fahuo) ? "" : " and sdremark4= '" + state_fahuo + "' "; string sql7 = " order by sddate asc "; DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql7; List <shuadan_records> list = new List <shuadan_records>(); SqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_records Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_records">shuadan_records表实例</param> /// <returns>int</returns> //public int Insert(shuadan_records shuadan_recordsExample) //{ // DBHelper.sqlstr = "insert into shuadan_records (sdgoodsname,sdgoodsurl,sddptype,sddate,sdorderid,sdphone,sdvpn,sdaddress,sdwuliu,sdremark1,sdremark3,sdremark2,sdremark4,sdremark5,sdremark6)values(@sdgoodsname,@sdgoodsurl,@sddptype,'" + shuadan_recordsExample.sddate.ToString("yyyy-MM-dd") + "',@sdorderid,@sdphone,@sdvpn,@sdaddress,@sdwuliu,@sdremark1,@sdremark3,@sdremark2,@sdremark4,@sdremark5,@sdremark6)"; // return DBHelper.ExecuteNonQuery(GetSqlParameters(shuadan_recordsExample)); //} #endregion #region Update /// <summary> /// 更新 /// </summary> /// <param name="shuadan_records">shuadan_records表实例</param> /// <returns>int</returns> public int Update(shuadan_records shuadan_recordsExample) { DBHelper.sqlstr = "update shuadan_records set sdgoodsname=@sdgoodsname,sdgoodsurl=@sdgoodsurl,sddptype=@sddptype,sddate='" + shuadan_recordsExample.sddate.ToString("yyyy-MM-dd") + "',sdorderid=@sdorderid,sdphone=@sdphone,sdvpn=@sdvpn,sdaddress=@sdaddress,sdwuliu=@sdwuliu,sdremark1=@sdremark1,sdremark3=@sdremark3,sdremark2=@sdremark2,sdremark4=@sdremark4,sdremark5=@sdremark5,sdremark6=@sdremark6 where sdid=" + shuadan_recordsExample.sdid; return(DBHelper.ExecuteNonQuery(GetSqlParameters(shuadan_recordsExample))); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_records">shuadan_records表实例</param> /// <returns>int</returns> public int Insert(shuadan_records shuadan_recordsExample) { DBHelper.sqlstr = "insert into shuadan_records (sdgoodsname,sdgoodsurl,sddptype,sddate,sdorderid,sdphone,sdvpn,sdaddress,sdwuliu,sdremark1,sdremark3,sdremark2,sdremark4,sdremark5,sdremark6)values(@sdgoodsname,@sdgoodsurl,@sddptype,@sddate,@sdorderid,@sdphone,@sdvpn,@sdaddress,@sdwuliu,@sdremark1,@sdremark3,@sdremark2,@sdremark4,@sdremark5,@sdremark6)"; return(DBHelper.ExecuteNonQuery(GetSqlParameters(shuadan_recordsExample))); }
/// <summary> /// 根据表,获取一个MySqlParameter数组 /// </summary> /// <returns>MySqlParameter[]</returns> public static MySqlParameter[] GetSqlParameters(shuadan_records shuadan_recordsExample) { List <MySqlParameter> list_param = new List <MySqlParameter>(); if (!string.IsNullOrEmpty(shuadan_recordsExample.sdgoodsname)) { list_param.Add(new MySqlParameter("@sdgoodsname", shuadan_recordsExample.sdgoodsname)); } else { list_param.Add(new MySqlParameter("@sdgoodsname", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdgoodsurl)) { list_param.Add(new MySqlParameter("@sdgoodsurl", shuadan_recordsExample.sdgoodsurl)); } else { list_param.Add(new MySqlParameter("@sdgoodsurl", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sddptype)) { list_param.Add(new MySqlParameter("@sddptype", shuadan_recordsExample.sddptype)); } else { list_param.Add(new MySqlParameter("@sddptype", DBNull.Value)); } if (shuadan_recordsExample.sddate != new DateTime() && shuadan_recordsExample.sddate != null) { //DateTime dt = new DateTime(); //DateTime.TryParse(shuadan_recordsExample.sddate.ToString("yyyy-MM-dd HH:mm:ss"), out dt); list_param.Add(new MySqlParameter("@sddate", shuadan_recordsExample.sddate.ToString("yyyy-MM-dd HH:mm:ss"))); } else { list_param.Add(new MySqlParameter("@sddate", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdorderid)) { list_param.Add(new MySqlParameter("@sdorderid", shuadan_recordsExample.sdorderid)); } else { list_param.Add(new MySqlParameter("@sdorderid", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdphone)) { list_param.Add(new MySqlParameter("@sdphone", shuadan_recordsExample.sdphone)); } else { list_param.Add(new MySqlParameter("@sdphone", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdvpn)) { list_param.Add(new MySqlParameter("@sdvpn", shuadan_recordsExample.sdvpn)); } else { list_param.Add(new MySqlParameter("@sdvpn", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdaddress)) { list_param.Add(new MySqlParameter("@sdaddress", shuadan_recordsExample.sdaddress)); } else { list_param.Add(new MySqlParameter("@sdaddress", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdwuliu)) { list_param.Add(new MySqlParameter("@sdwuliu", shuadan_recordsExample.sdwuliu)); } else { list_param.Add(new MySqlParameter("@sdwuliu", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark1)) { list_param.Add(new MySqlParameter("@sdremark1", shuadan_recordsExample.sdremark1)); } else { list_param.Add(new MySqlParameter("@sdremark1", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark3)) { list_param.Add(new MySqlParameter("@sdremark3", shuadan_recordsExample.sdremark3)); } else { list_param.Add(new MySqlParameter("@sdremark3", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark2)) { list_param.Add(new MySqlParameter("@sdremark2", shuadan_recordsExample.sdremark2)); } else { list_param.Add(new MySqlParameter("@sdremark2", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark4)) { list_param.Add(new MySqlParameter("@sdremark4", shuadan_recordsExample.sdremark4)); } else { list_param.Add(new MySqlParameter("@sdremark4", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark5)) { list_param.Add(new MySqlParameter("@sdremark5", shuadan_recordsExample.sdremark5)); } else { list_param.Add(new MySqlParameter("@sdremark5", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark6)) { list_param.Add(new MySqlParameter("@sdremark6", shuadan_recordsExample.sdremark6)); } else { list_param.Add(new MySqlParameter("@sdremark6", DBNull.Value)); } MySqlParameter[] param = new MySqlParameter[list_param.Count]; int index = 0; foreach (MySqlParameter p in list_param) { param[index] = p; index++; } return(param); }
private void dgv_title_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex > -1) { string colname = dgv_title.Columns[e.ColumnIndex].Name; shuadan_records sr = (shuadan_records)dgv_title.CurrentRow.DataBoundItem; //if (dgv_title.Columns[e.ColumnIndex] is DataGridViewButtonColumn) //{ //} if (colname == "col_kongbao") { #region 发空包 if (sr.sdremark3 == "2") { MessageBox.Show("已经获取单号"); return; } tabControl1.SelectedTab = tabPage1; webBrowser1.Load("http://580kongbao.com/buykongbao.asp"); if (Browser.WaitWebPageLoad(webBrowser1)) { //设置天天快递 string kuaidivalue = XMLHelper.GetValue("KuaiDiValue_MoGuJie"); //如果是淘宝 if (sr.sddptype == "2") { //设置申通快递 kuaidivalue = XMLHelper.GetValue("KuaiDiValue_TaoBao"); } Browser.JS_CEFBrowser_NoReturn("jsSelectItemByValue(document.getElementById('typ'),'" + kuaidivalue + "')", webBrowser1); //获取收件人信息 string userinfo = sr.sdaddress.Replace("?", " "); Browser.JS_CEFBrowser_NoReturn("document.getElementById('content').value='" + userinfo + "'", webBrowser1); //提交订单 Browser.JS_CEFBrowser_NoReturn("document.getElementById('button').click()", webBrowser1); Browser.Delay(1000); //弹出提示后按回车 Auto.Key_Enter(); Browser.Delay(1000); webBrowser1.Load("http://580kongbao.com/waitforsend.asp"); if (Browser.WaitWebPageLoad(webBrowser1)) { //获取姓名和快递单号 string name = Browser.JS_CEFBrowser("document.getElementsByClassName('tab2')[0].getElementsByTagName('tr')[1].getElementsByTagName('td')[3].innerText", webBrowser1); string wuliu = Browser.JS_CEFBrowser("document.getElementsByClassName('tab2')[0].getElementsByTagName('tr')[1].getElementsByTagName('td')[1].innerText", webBrowser1); //如果是对的 if (userinfo.IndexOf(name) != -1) { sr.sdwuliu = wuliu; sr.sdremark3 = "2"; BLL2.shuadan_recordsManager.Update(sr); //dgv_title.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = wuliu; dgv_title.Refresh(); } else { MessageBox.Show("没有找到该发货信息"); } } } #endregion } else if (colname == "col_fahuo") { #region 发货 if (sr.sdremark4 == "2") { MessageBox.Show("已经发货"); return; } if (string.IsNullOrEmpty(sr.sdwuliu)) { MessageBox.Show("该订单暂无快递单号"); return; } //如果是蘑菇街 if (sr.sddptype == "1") { tabControl1.SelectedTab = tabPage2; webBrowser2.Focus(); webBrowser2.Load("http://www.xiaodian.com/pc/home"); if (Browser.WaitWebPageLoad(webBrowser2)) { //webBrowser2.Focus(); //点击订单列表、 Browser.JS_CEFBrowser_NoReturn(" getElementsByDataReactid('.1.$2.1.$0.0')[0].click() ", webBrowser2); Browser.Delay(1500); //Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.1.$2.1.$0')[0] ", webBrowser2); //Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.1.$2.1.$0')[0] ", webBrowser2); if (Browser.WaitWebPageLoad(webBrowser2)) { webBrowser2.Focus(); Auto.Clipboard_In(sr.sdorderid); //点击订单编号输入框 Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.4.1.0.0.0.2.1')[0] ", webBrowser2); Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.4.1.0.0.0.2.1')[0] ", webBrowser2); //Browser.JS_CEFBrowser_NoReturn(" getElementsByDataReactid('.4.1.0.0.0.2.1')[0].value='" + sr.sdorderid + "' ", webBrowser2); Auto.Ctrl_V(); //点击查询 Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.4.1.0.1.1')[0] ", webBrowser2); Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.4.1.0.1.1')[0] ", webBrowser2); Browser.Delay(1500); if (Browser.WaitWebPageLoad(webBrowser2)) { //获得订单编号并对比 string orderid = Browser.JS_CEFBrowser("document.getElementsByClassName('order-num')[0].getElementsByTagName('span')[1].innerText", webBrowser2); if (orderid.Trim() == sr.sdorderid.Trim()) { Debug.WriteLine(orderid); //点击发货 Browser.JS_CEFBrowser_NoReturn(" getElementsByDataReactid('.4.1.0.4.$0.1.1.0:$0.7.0:$0.0')[0].click() ", webBrowser2); //Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.4.1.0.4.$0.1.1.0:$0.7.0:$0.0')[0] ", webBrowser2); if (Browser.WaitWebPageLoad(webBrowser2)) { //点击整单发货 Browser.JS_CEFBrowser_NoReturn(" getElementsByDataReactid('.3.1.1.0.1.0:$100.3.0.0')[0].click() ", webBrowser2); //Browser.MouseLeftByHtmlElement(" getElementsByDataReactid('.3.1.1.0.1.0:$100.3.0.0')[0] ", webBrowser2); Browser.Delay(500); Auto.Clipboard_In(sr.sdwuliu); Browser.JS_CEFBrowser_NoReturn(" document.getElementsByClassName('select-arrow')[0].click() ", webBrowser2); //Browser.JS_CEFBrowser_NoReturn(" document.getElementsByClassName('select-arrow')[0].click() ", webBrowser2); Browser.JS_CEFBrowser("document.getElementsByClassName('mc-text-input')[0].value='" + sr.sdwuliu + "'", webBrowser2); //显示已经发货 sr.sdremark4 = "2"; BLL2.shuadan_recordsManager.Update(sr); dgv_title.Refresh(); } } else { MessageBox.Show("订单信息错误"); } } } } } #endregion } else if (colname == "col_del") { #region 除 DialogResult resault = MessageBox.Show("确定要删除么?", "删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (resault == DialogResult.OK) { if (BLL2.shuadan_recordsManager.Delete(sr.sdid) == 1) { MessageBox.Show("删除成功"); //dgv_title.Rows[e.RowIndex].Visible = false; List <shuadan_records> list = (List <shuadan_records>)dgv_title.DataSource; list.Remove(sr); dgv_title.DataSource = null; dgv_title.DataSource = list; //dgv_title.Refresh(); } else { MessageBox.Show("删除失败"); } } #endregion } else if (colname == "col_wuliu") { #region 查快递 if (!string.IsNullOrEmpty(sr.sdwuliu)) { tabControl1.SelectedTab = tabPage4; webBrowser4.Focus(); webBrowser4.Load("http://www.guoguo-app.com/"); if (Browser.WaitWebPageLoad(webBrowser4)) { Browser.JS_CEFBrowser_NoReturn("document.getElementById('J_SearchInput').value='" + sr.sdwuliu + "'", webBrowser4); Browser.JS_CEFBrowser_NoReturn("document.getElementById('J_SearchBtn').click()", webBrowser4); } } #endregion } else if (colname == "col_kongbao2") { #region 发空包 sr.sdremark3 = sr.sdremark3 == "1" ? "2" : "1"; BLL2.shuadan_recordsManager.Update(sr); dgv_title.Refresh(); #endregion } else if (colname == "col_fahuo2") { #region 发货 sr.sdremark4 = sr.sdremark4 == "1" ? "2" : "1"; BLL2.shuadan_recordsManager.Update(sr); dgv_title.Refresh(); #endregion } else if (colname == "col_shoucai") { #region 收菜 sr.sdremark2 = sr.sdremark2 == "1" ? "2" : (sr.sdremark2 == "2" ? "3" : "1"); BLL2.shuadan_recordsManager.Update(sr); dgv_title.Refresh(); #endregion } else if (colname == "col_orderid") { #region 制订单编号 Auto.Clipboard_In(sr.sdorderid); #endregion } else if (colname == "col_phone") { #region 制手机号码 Auto.Clipboard_In(sr.sdphone); #endregion } } #region 全选 /* * else if (e.RowIndex == -1) * { * //如果是全选 * if (e.ColumnIndex == 0) * { * //foreach (DataGridViewRow row in dgv_title.Rows) * //{ * // if (row.Index != -1) * // { * // DataGridViewCheckBoxCell cbx = (DataGridViewCheckBoxCell)row.Cells[0]; * // cbx.Value = allselect == 0 ? true : false; * // } * //} * //allselect = allselect == 1 ? 0 : 1; * } * else * { * try * { * //dgv_title.Sort(dgv_title.Columns[e.ColumnIndex], ListSortDirection.Descending); * } * catch (Exception ex) * { * Debug.WriteLine("排序出错=========================" + ex.Message); * } * } * }*/ #endregion } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新 /// </summary> /// <param name="shuadan_records">shuadan_records表实例</param> /// <returns>int</returns> public static int Update(shuadan_records shuadan_recordsExample) { return(Service.Update(shuadan_recordsExample)); }
/// <summary> /// 更新 /// </summary> /// <param name="shuadan_records">shuadan_records表实例</param> /// <returns>int</returns> public int Update(shuadan_records shuadan_recordsExample) { DBHelper.sqlstr = "update shuadan_records set sdgoodsname=@sdgoodsname,sdgoodsurl=@sdgoodsurl,sddptype=@sddptype,sddate=@sddate,sdorderid=@sdorderid,sdphone=@sdphone,sdvpn=@sdvpn,sdaddress=@sdaddress,sdwuliu=@sdwuliu,sdremark1=@sdremark1,sdremark3=@sdremark3,sdremark2=@sdremark2,sdremark4=@sdremark4,sdremark5=@sdremark5,sdremark6=@sdremark6,sdstatepay=@sdstatepay,sdremark7=@sdremark7,sdremark8=@sdremark8,sdremark9=@sdremark9,sdremark10=@sdremark10 where sdid=" + shuadan_recordsExample.sdid; return(DBHelper.ExecuteNonQuery(GetSqlParameters(shuadan_recordsExample))); }
/// <summary> /// 根据表,获取一个SqlParameter数组 /// </summary> /// <returns>SqlParameter[]</returns> public static SqlParameter[] GetSqlParameters(shuadan_records shuadan_recordsExample) { List <SqlParameter> list_param = new List <SqlParameter>(); if (!string.IsNullOrEmpty(shuadan_recordsExample.sdgoodsname)) { list_param.Add(new SqlParameter("@sdgoodsname", shuadan_recordsExample.sdgoodsname)); } else { list_param.Add(new SqlParameter("@sdgoodsname", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdgoodsurl)) { list_param.Add(new SqlParameter("@sdgoodsurl", shuadan_recordsExample.sdgoodsurl)); } else { list_param.Add(new SqlParameter("@sdgoodsurl", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sddptype)) { list_param.Add(new SqlParameter("@sddptype", shuadan_recordsExample.sddptype)); } else { list_param.Add(new SqlParameter("@sddptype", DBNull.Value)); } if (shuadan_recordsExample.sddate != new DateTime() && shuadan_recordsExample.sddate != null) { list_param.Add(new SqlParameter("@sddate", shuadan_recordsExample.sddate.ToString("yyyy-MM-dd"))); } else { list_param.Add(new SqlParameter("@sddate", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdorderid)) { list_param.Add(new SqlParameter("@sdorderid", shuadan_recordsExample.sdorderid)); } else { list_param.Add(new SqlParameter("@sdorderid", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdphone)) { list_param.Add(new SqlParameter("@sdphone", shuadan_recordsExample.sdphone)); } else { list_param.Add(new SqlParameter("@sdphone", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdvpn)) { list_param.Add(new SqlParameter("@sdvpn", shuadan_recordsExample.sdvpn)); } else { list_param.Add(new SqlParameter("@sdvpn", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdaddress)) { list_param.Add(new SqlParameter("@sdaddress", shuadan_recordsExample.sdaddress)); } else { list_param.Add(new SqlParameter("@sdaddress", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdwuliu)) { list_param.Add(new SqlParameter("@sdwuliu", shuadan_recordsExample.sdwuliu)); } else { list_param.Add(new SqlParameter("@sdwuliu", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark1)) { list_param.Add(new SqlParameter("@sdremark1", shuadan_recordsExample.sdremark1)); } else { list_param.Add(new SqlParameter("@sdremark1", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark3)) { list_param.Add(new SqlParameter("@sdremark3", shuadan_recordsExample.sdremark3)); } else { list_param.Add(new SqlParameter("@sdremark3", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark2)) { list_param.Add(new SqlParameter("@sdremark2", shuadan_recordsExample.sdremark2)); } else { list_param.Add(new SqlParameter("@sdremark2", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark4)) { list_param.Add(new SqlParameter("@sdremark4", shuadan_recordsExample.sdremark4)); } else { list_param.Add(new SqlParameter("@sdremark4", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark5)) { list_param.Add(new SqlParameter("@sdremark5", shuadan_recordsExample.sdremark5)); } else { list_param.Add(new SqlParameter("@sdremark5", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark6)) { list_param.Add(new SqlParameter("@sdremark6", shuadan_recordsExample.sdremark6)); } else { list_param.Add(new SqlParameter("@sdremark6", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdstatepay)) { list_param.Add(new SqlParameter("@sdstatepay", shuadan_recordsExample.sdstatepay)); } else { list_param.Add(new SqlParameter("@sdstatepay", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark7)) { list_param.Add(new SqlParameter("@sdremark7", shuadan_recordsExample.sdremark7)); } else { list_param.Add(new SqlParameter("@sdremark7", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark8)) { list_param.Add(new SqlParameter("@sdremark8", shuadan_recordsExample.sdremark8)); } else { list_param.Add(new SqlParameter("@sdremark8", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark9)) { list_param.Add(new SqlParameter("@sdremark9", shuadan_recordsExample.sdremark9)); } else { list_param.Add(new SqlParameter("@sdremark9", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordsExample.sdremark10)) { list_param.Add(new SqlParameter("@sdremark10", shuadan_recordsExample.sdremark10)); } else { list_param.Add(new SqlParameter("@sdremark10", DBNull.Value)); } SqlParameter[] param = new SqlParameter[list_param.Count]; int index = 0; foreach (SqlParameter p in list_param) { param[index] = p; index++; } return(param); }