110,536
社区成员
发帖
与我相关
我的任务
分享
try
{
string strSql = string.Empty;
strSql = "SELECT * FROM TY_VIEW_SO_MATERIAL WHERE DTM>="+ this.dugStr.Text.ToString() +" AND DTM<="+ this.dugEnd.Text.ToString() + (this.chkHideDel.Checked ? " AND OLD=0 ": string.Empty) + " ORDER BY SONO,BOMID,ITM,OLD,ITM2 DESC";
RemoteCallReturnWithDataset rmtPrdt = ErpBasic.Cls_Common.GetDataFromDB(strSql);
DataTable dtbPrdt = rmtPrdt.ExecuteReturnData.Tables[0];
dgvPrdt.DataSource = dtbPrdt;
if (null != dtbPrdt)
{
this.txtInfo.Text = "查询完成,共" + dtbPrdt.Rows.Count + "条信息.";
}
}
catch
{
MessageBox.Show("查询出错,请检查你选择的日期!");
return;
}
我还在页面的Load事件里加了这个 this.dgvPrdt.AutoGenerateColumns = false;
this.txtInfo.Text = string.Empty;
if (!this.IsDisposed)
{
this.dugStr.Text = DateTime.Today.AddDays(1 - DateTime.Today.Day).ToString("yyyy-MM-dd");
this.dugEnd.Text = DateTime.Today.AddDays(0 - DateTime.Today.Day).AddMonths(1).ToString("yyyy-MM-dd");
}
DTM>="+ this.dugStr.Text.ToString("yyyy-MM-dd HH:mm:ss") +" A