public static IntrodureInfo getInfo(string pkIntrodureID) { DataTable mydata = iTechProData.FillDataTable("spIntrodure_selectbyID", "@pkIntrodureID", pkIntrodureID); IntrodureInfo _introdure = new IntrodureInfo(); _introdure.sTitle = mydata.Rows[0]["sTitle"].ToString(); _introdure.sImage = mydata.Rows[0]["sImage"].ToString(); _introdure.sSumary = mydata.Rows[0]["sSumary"].ToString(); _introdure.sComment = mydata.Rows[0]["sComment"].ToString(); _introdure.sPage = mydata.Rows[0]["sPage"].ToString(); _introdure.sLang = mydata.Rows[0]["sLang"].ToString(); _introdure.iPosition = int.Parse(mydata.Rows[0]["iPosition"].ToString()); return _introdure; }
public static void Update(IntrodureInfo _introdure) { string[] Parameters = new string[7] { "@pkIntrodureID", "@sTitle", "@sImage", "@sSumary", "@sComment", "@sPage", "@iPosition" }; string[] Values = new string[7] { _introdure.sTitle, _introdure.sImage, _introdure.sSumary, _introdure.sComment, _introdure.sPage, _introdure.sLang, _introdure.iPosition.ToString() }; executeData("spIntrodure_edit", Parameters, Values); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ListControlHelper.FillDataToDropDownList(ddlCompany, "Company", "CompanyName", "pkCompanyID"); ListControlHelper.FillDataToRadioButtonList(RadioButtonList1, "Company", "CompanyName", "pkCompanyID"); ListControlHelper.FillDataToListBox(ListBox1, "tblUser", "Name", "pkUserID"); ListControlHelper.FillDataToCheckBoxList(CheckBoxList1, "Company", "CompanyName", "pkCompanyID"); setMenuTest(); } IntrodureInfo intro = new IntrodureInfo(); intro = IntrodureDB.getInfo("12"); //IntrodureDB.Delete("11"); }