/// <summary>
/// Grid 数据绑定
/// </summary>
#region DataBinder() Author: Micro ( 2011-08-26 )
void DataBinder()
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_DomesticKid_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "List")
.Append("dept", userDept)
.Append("dk_STAT", FSecurityHelper.CurrentUserDataGET()[12])
}).GetList(); //修改grace 2014-09-23 用于决定是否分站
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
//if (!string.IsNullOrEmpty(Request["txtCode"]))
//{
//}
if (txtCode.Text != "")
{
div_bottom.Html = "<p class=''>Status : Edit the record of <span>" + txtCode.Text + "</span>.</p>";
txtCode.Disabled = true;
}
StoreDomestic.DataSource = ds;
StoreDomestic.DataBind();
}
else
{
div_bottom.Html = "<p class=''>Status: New Container Size record .</p>";
}
}
/// <summary>
/// Grid 数据绑定
/// </summary>
#region DataBinder() Author: Micro ( 2011-08-26 )
void DataBinder()
{
DataFactory dal = new DataFactory();
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_SystemString_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "List")
}).GetList();
StoreDomestic.DataSource = ds;
StoreDomestic.DataBind();
}
/// <summary>
/// Grid 数据绑定
/// </summary>
#region DataBinder() Author: Micro ( 2011-08-27 ) 修改时间2014-09-20 Grace
void DataBinder()
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Item_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "List").Append("itm_ROWID", txtRowID.Text)
.Append("itm_STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("itm_code", Request["code"])
.Append("itm_SYS", sys)//FSecurityHelper.CurrentUserDataGET()[11].Substring(0,1))
.Append("dept", userDept)
}).GetList();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
txtRowID.Text = ds.Tables[1].Rows[0]["itm_RowID"].ToString();
txtCode.Text = ds.Tables[1].Rows[0]["itm_Code"].ToString();
txtShort.Text = ds.Tables[1].Rows[0]["itm_Short"].ToString();
txtDes.Text = ds.Tables[1].Rows[0]["itm_Description"].ToString();
txtDesCN.Text = ds.Tables[1].Rows[0]["itm_Description_CN"].ToString();
cmbFCurrency.Text = ds.Tables[1].Rows[0]["itm_FCurrency"].ToString();
cmbFby.Text = ds.Tables[1].Rows[0]["itm_FCalcQty"].ToString();
cmbFUnit.Text = ds.Tables[1].Rows[0]["itm_FUnit"].ToString();
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_FMin"].ToString()))
{
txtFMain.Clear();
}
else
{
txtFMain.Text = ds.Tables[1].Rows[0]["itm_FMin"].ToString();
}
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_FRate"].ToString()))
{
txtFRate.Clear();
}
else
{
txtFRate.Text = ds.Tables[1].Rows[0]["itm_FRate"].ToString();
}
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_FAmount"].ToString()))
{
txtFAmount.Clear();
}
else
{
txtFAmount.Text = ds.Tables[1].Rows[0]["itm_FAmount"].ToString();
}
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_FRound"].ToString()))
{
txtFRound.Clear();
}
else
{
txtFRound.Text = ds.Tables[1].Rows[0]["itm_FRound"].ToString();
}
chbFUp.Checked = Convert.ToBoolean(ds.Tables[1].Rows[0]["itm_FMarkUp"]);
chbFDown.Checked = Convert.ToBoolean(ds.Tables[1].Rows[0]["itm_FMarkDown"]);
labCurrency.Text = ds.Tables[1].Rows[0]["itm_LCurrency"].ToString(); //保存获取不到Text值
txtlab.Text = ds.Tables[1].Rows[0]["itm_LCurrency"].ToString();
cmbLby.Text = ds.Tables[1].Rows[0]["itm_LCalcQty"].ToString();
cmbLUnit.Text = ds.Tables[1].Rows[0]["itm_LUnit"].ToString();
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_LMin"].ToString()))
{
txtLMin.Clear();
}
else
{
txtLMin.Text = ds.Tables[1].Rows[0]["itm_LMin"].ToString();
}
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_LRate"].ToString()))
{
txtLRate.Clear();
}
else
{
txtLRate.Text = ds.Tables[1].Rows[0]["itm_LRate"].ToString();
}
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_LAmount"].ToString()))
{
txtLAmount.Clear();
}
else
{
txtLAmount.Text = ds.Tables[1].Rows[0]["itm_LAmount"].ToString();
}
if (string.IsNullOrEmpty(ds.Tables[1].Rows[0]["itm_LRound"].ToString()))
{
txtLRound.Clear();
}
else
{
txtLRound.Text = ds.Tables[1].Rows[0]["itm_LRound"].ToString();
}
chbLUp.Checked = Convert.ToBoolean(ds.Tables[1].Rows[0]["itm_LMarkUp"]);
chbLDown.Checked = Convert.ToBoolean(ds.Tables[1].Rows[0]["itm_LMarkDown"]);
chbActive.Checked = Convert.ToBoolean(ds.Tables[1].Rows[0]["itm_Active"]);
labFvalues.Text = ds.Tables[1].Rows[0]["Fvalues"].ToString();
labFRound.Text = ds.Tables[1].Rows[0]["FRound"].ToString();
labLValues.Text = ds.Tables[1].Rows[0]["Lvalues"].ToString();
labLRound.Text = ds.Tables[1].Rows[0]["LRound"].ToString();
string[] statlist = string.IsNullOrEmpty(ds.Tables[1].Rows[0]["StatList"].ToString()) ? new string[] { } : ds.Tables[1].Rows[0]["StatList"].ToString().Split(',');
CheckGroupClear();
foreach (string str in statlist)
{
for (int i = 0; i < tblChkGroup.Items.Count(); ++i)
{
if (tblChkGroup.Items[i].Tag.ToString().Trim().ToUpper() == str.Trim().ToUpper())
{
tblChkGroup.Items[i].Checked = true;
break;
}
}
}
}
//txtCode.Focus(true);
if (txtCode.Text != "")
{
div_bottom.Html = "<p class=''>Status : Edit the record of <span>" + txtCode.Text + "</span>.</p>";
txtCode.Disabled = true;
}
StoreDomestic.DataSource = ds.Tables[0];
StoreDomestic.DataBind();
}
else
{
div_bottom.Html = "<p class=''>Status: New Item record.</p>";
}
}
