protected Boolean check_itemExist() { Boolean bl_rtnflag = false; using (ODBCconn = new MyODBCConnection()) { OdbcCommand cmd = new OdbcCommand(strodbccmd); cmd.Parameters.Add("item_code", OdbcType.VarChar).Value = txtItemCode.Text; DataTable dt = ODBCconn.GetData(cmd); if (dt.Rows.Count > 0) //--資料庫裡面找不到資料 { txtItemName.Text = dt.Rows[0].Field <string>("f_desc"); txtItemPrice.Text = dt.Rows[0].Field <decimal>("amt_ex").ToString(); bl_rtnflag = true; } else { PublicLib.showAlert("資料庫無此細項代碼喔"); txtItemCode.Text = ""; txtItemName.Text = ""; txtItemPrice.Text = ""; bl_rtnflag = false; } cmd.Cancel(); ODBCconn.Dispose(); } return(bl_rtnflag); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.Equals("cmdEdit")) { string strUrl = ResolveUrl(string.Format("~/RunDownAddEdit.aspx?id={0}", e.CommandArgument.ToString())); Response.Redirect(strUrl); } if (e.CommandName.Equals("cmdDel")) { conn = new MyConnection(); string strsql = "select * from [HMC_PkgRundown] where Rundown_Id=@Rundown_Id "; SqlCommand cmd = new SqlCommand(strsql); cmd.Parameters.Add("@Rundown_Id", SqlDbType.Int).Value = e.CommandArgument.ToString(); dt = conn.GetData(cmd); if (dt.Rows.Count > 0) { PublicLib.showAlert("此流程已被設定在套餐內,無法刪除"); } else { deleteData(e.CommandArgument.ToString()); querySql(); } } } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.Equals("cmdView")) { string strUrl = ResolveUrl(string.Format("~/PkgRelative.aspx?PID={0}", e.CommandArgument.ToString())); Response.Redirect(strUrl, false); } if (e.CommandName.Equals("cmdEdit")) { string strUrl = ResolveUrl(string.Format("~/ClassAddEdit.aspx?cmd={0}&pid={1}&ID={2}", "edit", strPID, e.CommandArgument)); Response.Redirect(strUrl); } if (e.CommandName.Equals("cmdDel")) { if (have_child(e.CommandArgument.ToString())) { PublicLib.showAlert("請先刪除子項目內的資料"); } else { delete_Relative(e.CommandArgument.ToString()); querySql(); } } } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { var list_seq = new List <string>(); foreach (GridViewRow row in GridView1.Rows) { TextBox txtseq = (TextBox)row.FindControl("txtSeqNo"); if (list_seq.Contains(txtseq.Text)) { PublicLib.showAlert("歐歐 排序有重複喔"); return; } list_seq.Add(txtseq.Text); } conn = new MyConnection(); if (1 == 1) { Delete_PkgRunDown(); Insert_PkgRunDown(); conn.Muti_Insert(list_sqlcmd); } } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } Response.Redirect("~/PkgIndex.aspx"); }
private void BindGrid() //新增/編輯 套餐 { DataTable dt = new DataTable(); string strcmd = "SELECT ItemCode FROM HMC_PkgD WHERE 1=0"; if (strPkgCode != null && strPkgCode != "") { strcmd = "SELECT ItemCode FROM HMC_PkgD WHERE PkgCode = @Param"; } SqlCommand cmd = new SqlCommand(strcmd); if (strPkgCode != null && strPkgCode != "") { cmd.Parameters.Add("@Param", SqlDbType.NVarChar).Value = strPkgCode; } conn = new MyConnection(); dt = conn.GetData(cmd); dt.Columns.Add("ItemName", typeof(string)); dt.Columns.Add("ItemPrice", typeof(string)); if (dt.Rows.Count == 0) { dt.Rows.Add(); } else { foreach (DataRow row in dt.Rows) //細項名稱 { string stritemCode = row["ItemCode"].ToString(); using (ODBCconn = new MyODBCConnection()) { OdbcCommand odbccmd = new OdbcCommand(strodbccmd); odbccmd.Parameters.Add("item_code", OdbcType.VarChar).Value = stritemCode; DataTable odbcdt = ODBCconn.GetData(odbccmd); if (odbcdt.Rows.Count > 0) { row["ItemName"] = odbcdt.Rows[0].Field <string>("f_desc");; row["ItemPrice"] = odbcdt.Rows[0].Field <decimal>("amt_ex"); } else { string strmsg = string.Format("代碼{0},資料庫中無此代碼", stritemCode); PublicLib.showAlert(strmsg); } odbccmd.Cancel(); ODBCconn.Dispose(); } } } ViewState["Pkg_Detail"] = dt; GridView1.DataSource = dt; GridView1.DataBind(); }
protected void BindGrid() { try { string strSql = "Select RunDown_ID,Seq_No From [HMC_PkgRunDown] Where Pkg_Id = '" + strQuePkgId + "' order by seq_no"; SqlCommand cmd = new SqlCommand(strSql); conn = new MyConnection(); DataTable dt = conn.GetData(cmd); dt.Columns.Add("Name", typeof(string)); if (dt.Rows.Count == 0) { dt.Rows.Add(); } else { foreach (DataRow row in dt.Rows) //細項名稱 { string strRunDounID = row["RunDown_ID"].ToString(); using (conn = new MyConnection()) { string strSql1 = "Select Name From [HMC_RunDown] Where Id = @Id"; SqlCommand cmd1 = new SqlCommand(strSql1); cmd1.Parameters.Add("Id", SqlDbType.Int).Value = int.Parse(strRunDounID); DataTable dt1 = conn.GetData(cmd1); if (dt1.Rows.Count > 0) { row["Name"] = dt1.Rows[0].Field <string>("Name"); } else { string strmsg = string.Format("代碼{0},資料庫中無此流程", strRunDounID); PublicLib.showAlert(strmsg); } cmd1.Cancel(); conn.Dispose(); } } } ViewState["Pkg_Rundown"] = dt; GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (ViewState["Pkg_Rundown"] != null) { DataTable dt = (DataTable)ViewState["Pkg_Rundown"]; DataRow drow = null; string strRundown_ID = ddlRunDown.SelectedValue; string strRundown_Name = ddlRunDown.SelectedItem.Text; if (dt.Rows.Count > 0) { var list_RundownID = new List <string>(); foreach (DataRow dr in dt.Rows) { list_RundownID.Add(dr["RunDown_ID"].ToString()); if (list_RundownID.Contains(strRundown_ID)) { PublicLib.showAlert("歐歐 此排程已經存在"); return; } list_RundownID.Add(dr["RunDown_ID"].ToString()); } drow = dt.NewRow(); drow["RunDown_ID"] = int.Parse(strRundown_ID); drow["Name"] = strRundown_Name; } if (dt.Rows[0][0].ToString() == "") { dt.Rows[0].Delete(); dt.AcceptChanges(); } //add created Rows into dataTable dt.Rows.Add(drow); //Save Data table into view state after creating each row ViewState["Pkg_Rundown"] = dt; //Bind Gridview with latest Row GridView1.DataSource = dt; GridView1.DataBind(); } }