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