private void exportxmlbutton_Click(object sender, EventArgs e)
{
DateTime time1 = Convert.ToDateTime(this.dateTimePickerstart.Value.Date.ToString("yyyy/MM/dd"));
DateTime time2 = Convert.ToDateTime(this.dateTimePickerend.Value.Date.ToString("yyyy/MM/dd"));
if (DateTime.Compare(time1, time2) > 0) //判断日期大小
{
MessageBox.Show("开始日期大于结束");
return;
}
string startTime = this.dateTimePickerstart.Value.ToString("yyyy/MM/dd");
string endTime = this.dateTimePickerend.Value.ToString("yyyy/MM/dd");
List <ReceiveOrderStruct> receiveOrderList = new List <ReceiveOrderStruct>();
try
{
SqlConnection mConn = new SqlConnection(Constlist.ConStr);
mConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select custom_order,track_serial_no,custommaterialNo,custom_serial_no,dpk_status,mac,mpn,mb_describe from DeliveredTable where order_receive_date between '" + startTime + "' and '" + endTime + "'";
SqlDataReader querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
ReceiveOrderStruct temp = new ReceiveOrderStruct();
temp.orderNo = querySdr[0].ToString();
temp.trackno = querySdr[1].ToString();
temp.customMaterialNo = querySdr[2].ToString();
temp.custom_serial_no = querySdr[3].ToString();
temp.dpktype = querySdr[4].ToString();
temp.mac = querySdr[5].ToString();
temp.mpn = querySdr[6].ToString();
temp.mbdescribe = querySdr[7].ToString();
receiveOrderList.Add(temp);
}
querySdr.Close();
mConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
generateExcelToCheck(receiveOrderList, startTime, endTime);
}
private void exportxmlbutton_Click(object sender, EventArgs e)
{
DateTime time1 = Convert.ToDateTime(this.dateTimePickerstart.Value.Date.ToString("yyyy-MM-dd", System.Globalization.DateTimeFormatInfo.InvariantInfo));
DateTime time2 = Convert.ToDateTime(this.dateTimePickerend.Value.Date.ToString("yyyy-MM-dd", System.Globalization.DateTimeFormatInfo.InvariantInfo));
if (DateTime.Compare(time1, time2) > 0) //判断日期大小
{
MessageBox.Show("开始日期大于结束");
return;
}
string startTime = this.dateTimePickerstart.Value.ToString("yyyy-MM-dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
string endTime = this.dateTimePickerend.Value.ToString("yyyy-MM-dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
List <ReceiveOrderStruct> receiveOrderList = new List <ReceiveOrderStruct>();
try
{
SqlConnection mConn = new SqlConnection(Constlist.ConStr);
mConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select vendor,product, source_brief,storehouse,custom_order,order_out_date,order_receive_date,custom_machine_type,mb_brief," +
"custommaterialNo,dpk_status,track_serial_no,custom_serial_no,vendor_serail_no,uuid,mac,mpn,mb_describe,mb_make_date,warranty_period,custom_fault," +
"guarantee,customResponsibility,lenovo_custom_service_no,lenovo_maintenance_no,lenovo_repair_no,whole_machine_no,inputuser from DeliveredTable where order_receive_date between '" + startTime + "' and '" + endTime + "'";
SqlDataReader querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
ReceiveOrderStruct temp = new ReceiveOrderStruct();
temp.vendor = querySdr[0].ToString();
temp.product = querySdr[1].ToString();
temp.source_brief = querySdr[2].ToString();
temp.storehouse = querySdr[3].ToString();
temp.custom_order = querySdr[4].ToString();
temp.order_out_date = querySdr[5].ToString();
temp.order_receive_date = querySdr[6].ToString();
temp.custom_machine_type = querySdr[7].ToString();
temp.mb_brief = querySdr[8].ToString();
temp.custommaterialNo = querySdr[9].ToString();
temp.dpk_status = querySdr[10].ToString();
temp.track_serial_no = querySdr[11].ToString();
temp.custom_serial_no = querySdr[12].ToString();
temp.vendor_serail_no = querySdr[13].ToString();
temp.uuid = querySdr[14].ToString();
temp.mac = querySdr[15].ToString();
temp.mpn = querySdr[16].ToString();
temp.mb_describe = querySdr[17].ToString();
temp.mb_make_date = querySdr[18].ToString();
temp.warranty_period = querySdr[19].ToString();
temp.custom_fault = querySdr[20].ToString();
temp.guarantee = querySdr[21].ToString();
temp.customResponsibility = querySdr[22].ToString();
temp.lenovo_custom_service_no = querySdr[23].ToString();
temp.lenovo_maintenance_no = querySdr[24].ToString();
temp.lenovo_repair_no = querySdr[25].ToString();
temp.whole_machine_no = querySdr[26].ToString();
temp.inputuser = querySdr[27].ToString();
receiveOrderList.Add(temp);
}
querySdr.Close();
mConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
generateExcelToCheck(receiveOrderList, startTime, endTime);
}
