/// <summary>
/// 更新資料
/// </summary>
protected void ProductsLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
RedGlovePermission.Model.Products model = new RedGlovePermission.Model.Products();
model.ProductID = ProductsLists.DataKeys[e.RowIndex].Values[0].ToString();
model.ProductName = ((TextBox)ProductsLists.Rows[e.RowIndex].FindControl("txt_name")).Text.Trim();
model.ProductSpec = ((TextBox)ProductsLists.Rows[e.RowIndex].FindControl("txt_spec")).Text.Trim();
model.StorageUnit = ((TextBox)ProductsLists.Rows[e.RowIndex].FindControl("txt_unit")).Text.Trim();
UserSession user = SessionBox.GetUserSession();
model.Modifier = user.LoginName.ToString();
model.Modi_Date = DateTime.Now.ToString("yyyyMMdd");
if (!bll.UpdateProduct(model))
{
//ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "')", true);
}
//返回瀏覽狀態
ProductsLists.EditIndex = -1;
BindOrder2();
}
/// <summary>
/// 新增資料
/// </summary>
protected void btn_add_Click(object sender, EventArgs e)
{
if (txt_Name.Text.Trim() != "" || txt_ID.Text.Trim() != "")
{
RedGlovePermission.Model.Products model = new RedGlovePermission.Model.Products();
model.ProductID = txt_ID.Text.Trim();
model.ProductName = txt_Name.Text.Trim();
model.ProductSpec = txt_Spec.Text.Trim();
model.StorageUnit = txt_Unit.Text.Trim();
UserSession user = SessionBox.GetUserSession();
model.Creator = user.LoginName.ToString();
model.Create_Date = DateTime.Now.ToString("yyyyMMdd");
if (!bll.Exists(txt_ID.Text.Trim()))
{
if (bll.CreateProduct(model))
{
//ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "')", true);
}
else
{
//ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "')", true);
}
ClearText();
BindOrder();
}
else
{
//ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_IsCustomer") + "')", true);
}
}
}
/// <summary>
/// 得到一筆產品資料
/// </summary>
/// <param name="ProductID">產品ID</param>
/// <returns></returns>
public RedGlovePermission.Model.Products GetProductModel(string ProductID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 MB001,MB002,MB003,MB004 from INVMB ");
strSql.Append(" where MB001=@ProductID ");
SqlParameter[] parameters = {
new SqlParameter("@ProductID", SqlDbType.Char,20)};
parameters[0].Value = ProductID;
RedGlovePermission.Model.Products model = new RedGlovePermission.Model.Products();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
//if (ds.Tables[0].Rows[0]["ProductID"].ToString() != "")
//{
model.ProductID = ds.Tables[0].Rows[0]["MB001"].ToString();
//}
model.ProductName = ds.Tables[0].Rows[0]["MB002"].ToString();
model.ProductSpec = ds.Tables[0].Rows[0]["MB003"].ToString();
model.StorageUnit = ds.Tables[0].Rows[0]["MB004"].ToString();
return model;
}
else
{
return null;
}
}
