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");
}