Beispiel #1
0
        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);
        }
Beispiel #2
0
        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();
        }