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