private void LoadInfoSearch(int type = 0)
{
//string[] paraName = new string[2];
//object[] paraValue = new object[2];
if (type == 0)
{
_catID = TextUtils.ToInt(treeData.FocusedNode.GetValue(colIDTree));
}
else
{
_catID = 0;
}
//paraName[0] = "@GroupID"; paraValue[0] = _catID;
//paraName[1] = "@TextFilter"; paraValue[1] = txtName.Text.Trim();
DataTable arr = LibIE.LoadDataFromSP("spGetProductData"
, "A"
, new string[] { "@GroupID", "@TextFilter" }
, new object[] { _catID, txtName.Text.Trim() }
);
grdData.DataSource = arr;
}
void loadData()
{
DataTable dt = LibIE.LoadDataFromSP("spGetHistoryCheckOrderDataDetailH", "A"
, new string[] { "orderCode" }
, new object[] { _OrderCode });
int count = dt.Columns.Count;
if (count > 9)
{
string RealValue1 = Lib.ToString(dt.Columns[9]);
colRealValue1.FieldName = RealValue1;
colRealValue1.Caption = RealValue1;
}
else
{
colRealValue1.Visible = false;
}
if (count > 10)
{
string realvalue2 = Lib.ToString(dt.Columns[10]);
colRealValue2.FieldName = realvalue2;
colRealValue2.Caption = realvalue2;
}
else
{
colRealValue2.Visible = false;
}
if (count > 11)
{
string realvalue3 = Lib.ToString(dt.Columns[11]);
colRealValue3.FieldName = realvalue3;
colRealValue3.Caption = realvalue3;
}
else
{
colRealValue3.Visible = false;
}
if (count > 12)
{
string realvalue4 = Lib.ToString(dt.Columns[12]);
colRealValue4.FieldName = realvalue4;
colRealValue4.Caption = realvalue4;
}
else
{
colRealValue4.Visible = false;
}
if (count > 13)
{
string realvalue5 = Lib.ToString(dt.Columns[13]);
colRealValue5.FieldName = realvalue5;
colRealValue5.Caption = realvalue5;
}
else
{
colRealValue5.Visible = false;
}
grdData.DataSource = dt;
}
void loadData()
{
DataTable dt = LibIE.LoadDataFromSP("spGetHistoryCheckDataDetail", "A"
, new string[] { "QRCode" }
, new object[] { QRCode });
grdData.DataSource = dt;
}
void loadData()
{
DataTable dt = LibIE.LoadDataFromSP("spFindDataCD1", "A"
, new string[] { "@TextFind" }
, new object[] { txtFindText.Text.Trim() });
grdData.DataSource = dt;
}
void loadData()
{
DateTime from = new DateTime(dtpFromDate.Value.Year, dtpFromDate.Value.Month, dtpFromDate.Value.Day, 0, 0, 0);
DateTime to = new DateTime(dtpEndDate.Value.Year, dtpEndDate.Value.Month, dtpEndDate.Value.Day, 23, 59, 59);
DataTable dt = LibIE.LoadDataFromSP("spGetHistoryCheckData", "A"
, new string[] { "@FromDate", "@EndDate", "@TextFind" }
, new object[] { from, to, txtFindText.Text.Trim() });
grdData.DataSource = dt;
}
private void grvData_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
string[] _paraName = new string[1];
object[] _paraValue = new object[1];
_paraName[0] = "@VthhID"; _paraValue[0] = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colFK_VTHH));
DataTable dtXT = LibIE.LoadDataFromSP("spGetXT", "Source", _paraName, _paraValue);
grdXuat.DataSource = dtXT;
DataTable dtNT = LibIE.LoadDataFromSP("spGetNT", "Source", _paraName, _paraValue);
grdNhap.DataSource = dtNT;
}
void loadWorking()
{
int stepID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colStepID));
if (chkAll.Checked)
{
stepID = 0;
}
DataTable dt = new DataTable();
//dt = TextUtils.Select(string.Format("SELECT * FROM dbo.ProductWorking WHERE ProductStepID = {0} ORDER BY SortOrder", stepID));
dt = LibIE.LoadDataFromSP("spGetProductWorking_ByProductID", "A"
, new string[] { "@ProductID", "@ProductStepID" }
, new object[] { this.ProductID, stepID });
grdDetail.DataSource = dt;
}
void LoadInfoSearch()
{
dtpFrom.Value = dtpFrom.Value.Date.AddHours(0).AddMinutes(00).AddSeconds(00);
dtpTo.Value = dtpTo.Value.Date.AddHours(23).AddMinutes(59).AddSeconds(59);
DataTable dt = LibIE.LoadDataFromSP("spGetCheckWorkingFindDate"
, "A"
, new string[] { "@DateStart", "@DateEnd ", "@TextFilter", "@CboIsApproved", "@UserApproved" }
, new object[] { dtpFrom.Value.ToString("yyyy/MM/dd HH:mm:ss")
, dtpTo.Value.ToString("yyyy/MM/dd HH:mm:ss")
, txtAssyOrderId.Text.Trim()
, cboIsApproveds.SelectedIndex + 1
, cboUserApproved.Text }
);
grdData.DataSource = dt;
}
void LoadInfoSearch()
{
DataTable dt = new DataTable();
dtpFrom.Value = dtpFrom.Value.Date.AddHours(0).AddMinutes(00).AddSeconds(00);
dtpTo.Value = dtpTo.Value.Date.AddHours(23).AddMinutes(59).AddSeconds(59);
dt = LibIE.LoadDataFromSP(
"spGetProductionPlanFindDate"
, "A"
, new string[] { "@DateStart", "@DateEnd ", "@TextFilter", "@IsShow", "@UnFinished" }
, new object[] { dtpFrom.Value.ToString("yyyy/MM/dd HH:mm:ss")
, dtpTo.Value.ToString("yyyy/MM/dd HH:mm:ss")
, txtAssyOrderId.Text.Trim()
, chkIsShow.Checked
, chkUnFinished.Checked }
);
grdData.DataSource = dt;
}
void loadData()
{
string[] _paraName = new string[1];
object[] _paraValue = new object[1];
_paraName[0] = "@Type"; _paraValue[0] = TextUtils.ToInt(cboType.SelectedIndex);
_dtData = LibIE.LoadDataFromSP("spGetReportNXT1", "Source", _paraName, _paraValue);
grdData.DataSource = _dtData;
if (_rownIndex >= grvData.RowCount)
{
_rownIndex = 0;
}
if (_rownIndex > 0)
{
grvData.FocusedRowHandle = _rownIndex;
}
grvData.SelectRow(_rownIndex);
grvData.BestFitColumns();
}
void LoadInfoSearch()
{
try
{
DataTable dt = new DataTable();
dt = LibIE.LoadDataFromSP(
"spGetProductCheckHistoryDetailPCA"
, "A"
, new string[] { "@DateStart", "@DateEnd ", "@TextFilter" }
, new object[] { dtpFrom.Value.ToString("yyyy/MM/dd HH:mm:ss")
, dtpTo.Value.ToString("yyyy/MM/dd HH:mm:ss")
, txtTextFilter.Text.Trim() }
);
grdData.DataSource = dt;
}
catch
{
}
}
void loadData()
{
string[] _paraName = new string[2];
object[] _paraValue = new object[2];
_paraName[0] = "@Year"; _paraValue[0] = TextUtils.ToInt(cboYear.SelectedItem);
_paraName[1] = "@Month"; _paraValue[1] = cboMonth.SelectedIndex < 0 ? 0 : cboMonth.SelectedIndex;
DataTable Source = LibIE.LoadDataFromSP("spGetFCM", "Source", _paraName, _paraValue);
grdData.DataSource = Source;
if (_rownIndex >= grvData.RowCount)
{
_rownIndex = 0;
}
if (_rownIndex > 0)
{
grvData.FocusedRowHandle = _rownIndex;
}
grvData.SelectRow(_rownIndex);
}
void loadData()
{
removeColumn();
DateTime from = new DateTime(dtpFromDate.Value.Year, dtpFromDate.Value.Month, dtpFromDate.Value.Day, 0, 0, 0);
DateTime to = new DateTime(dtpEndDate.Value.Year, dtpEndDate.Value.Month, dtpEndDate.Value.Day, 23, 59, 59);
if (txtFromOrder.Text.Trim() != "" && txtToOrder.Text.Trim() != "")
{
string sql = @"SELECT TOP 1 DateLR
FROM dbo.ProductCheckHistoryDetail
WHERE OrderCode LIKE '%{0}%' ORDER BY DateLR";
DateTime?date1 = TextUtils.ToDate2(LibIE.ExcuteScalar(string.Format(sql, txtFromOrder.Text.Trim())));
DateTime?date2 = TextUtils.ToDate2(LibIE.ExcuteScalar(string.Format(sql, txtToOrder.Text.Trim())));
if (date1.HasValue && date2.HasValue)
{
if (date2.Value >= date1.Value)
{
from = new DateTime(date1.Value.Year, date1.Value.Month, date1.Value.Day, 0, 0, 0);
to = new DateTime(date2.Value.Year, date2.Value.Month, date2.Value.Day, 0, 0, 0);
}
else
{
to = new DateTime(date1.Value.Year, date1.Value.Month, date1.Value.Day, 0, 0, 0);
from = new DateTime(date2.Value.Year, date2.Value.Month, date2.Value.Day, 0, 0, 0);
}
}
}
List <string> listColumnText = new List <string>();
if (txtFindText.Text.Trim() == "")
{
return;
}
string[] arr = txtFindText.Text.Trim().Split(';');
for (int i = 0; i < arr.Length; i++)
{
listColumnText.Add(string.Format("[{0}]", arr[i]));
grvData.Columns[i + 1].VisibleIndex = i + 1;
grvData.Columns[i + 1].Caption = arr[i];
grvData.Columns[i + 1].FieldName = arr[i];
grvData.Columns[i + 1].Width = 200;
}
DataTable dt = LibIE.LoadDataFromSP("spThongKePhanTichData", "A"
, new string[] { "@From", "@To", "@FistColumnText" }
, new object[] { from, to, string.Join(",", listColumnText) });
//DataColumn c = new DataColumn();
//c.Caption = "STT";
//c.ColumnName = "STT";
//c.DataType = typeof(int);
//c.AutoIncrement = true;
//c.AutoIncrementSeed = 1;
//c.AutoIncrementStep = 1;
//c.AllowDBNull = false;
////c.Unique = true;
//dt.Columns.Add(c);
//dt.Columns["STT"].SetOrdinal(0);
grdData.DataSource = dt;
}
