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 <DpkStruct> receiveOrderList = new List <DpkStruct>();
try
{
SqlConnection mConn = new SqlConnection(Constlist.ConStr);
mConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select dpk_type,KEYPN,KEYID,KEYSERIAL,_status,burn_date,custom_serial_no from DPK_table where upload_date between '" + startTime + "' and '" + endTime + "'";
SqlDataReader querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
DpkStruct temp = new DpkStruct();
temp.dpk_type = querySdr[0].ToString();
temp.KEYPN = querySdr[1].ToString();
temp.KEYID = querySdr[2].ToString();
temp.KEYSERIAL = querySdr[3].ToString();
temp._status = querySdr[4].ToString();
temp.burn_date = querySdr[5].ToString();
temp.custom_serial_no = querySdr[6].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 <DpkStruct> receiveOrderList = new List <DpkStruct>();
try
{
SqlConnection mConn = new SqlConnection(Constlist.ConStr);
mConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandType = CommandType.Text;
string queryColumn = "";
if (this.inputdateradioButton.Checked)
{
queryColumn = "upload_date";
}
else if (this.usedateradioButton.Checked)
{
queryColumn = "burn_date";
}
cmd.CommandText = "select dpk_type,KEYPN,KEYID,KEYSERIAL,_status,burn_date,custom_serial_no,Id,dpk_order_no,upload_date from DPK_table where " + queryColumn + " between '" + startTime + "' and '" + endTime + "'";
SqlDataReader querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
DpkStruct temp = new DpkStruct();
temp.dpk_type = querySdr[0].ToString();
temp.KEYPN = querySdr[1].ToString();
temp.KEYID = querySdr[2].ToString();
temp.KEYSERIAL = querySdr[3].ToString();
temp._status = querySdr[4].ToString();
temp.burn_date = querySdr[5].ToString();
temp.custom_serial_no = querySdr[6].ToString();
temp.id = querySdr[7].ToString();
temp.dpk_order_no = querySdr[8].ToString();
temp.upload_date = querySdr[9].ToString();
receiveOrderList.Add(temp);
}
querySdr.Close();
mConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
generateExcelToCheck(receiveOrderList, startTime, endTime);
}
