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