/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Applications DataRowToModel(DataRow row) { Maticsoft.Model.sys_Applications model=new Maticsoft.Model.sys_Applications(); if (row != null) { if(row["ApplicationID"]!=null && row["ApplicationID"].ToString()!="") { model.ApplicationID=int.Parse(row["ApplicationID"].ToString()); } if(row["A_AppName"]!=null) { model.A_AppName=row["A_AppName"].ToString(); } if(row["A_AppDescription"]!=null) { model.A_AppDescription=row["A_AppDescription"].ToString(); } if(row["A_AppUrl"]!=null) { model.A_AppUrl=row["A_AppUrl"].ToString(); } if(row["A_Order"]!=null && row["A_Order"].ToString()!="") { model.A_Order=int.Parse(row["A_Order"].ToString()); } } return model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.sys_Applications model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sys_Applications set "); strSql.Append("A_AppName=@A_AppName,"); strSql.Append("A_AppDescription=@A_AppDescription,"); strSql.Append("A_AppUrl=@A_AppUrl,"); strSql.Append("A_Order=@A_Order"); strSql.Append(" where ApplicationID=@ApplicationID"); SqlParameter[] parameters = { new SqlParameter("@A_AppName", SqlDbType.NVarChar, 50), new SqlParameter("@A_AppDescription", SqlDbType.NVarChar, 200), new SqlParameter("@A_AppUrl", SqlDbType.VarChar, 50), new SqlParameter("@A_Order", SqlDbType.Int, 4), new SqlParameter("@ApplicationID", SqlDbType.Int, 4) }; parameters[0].Value = model.A_AppName; parameters[1].Value = model.A_AppDescription; parameters[2].Value = model.A_AppUrl; parameters[3].Value = model.A_Order; parameters[4].Value = model.ApplicationID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.sys_Applications model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_Applications("); strSql.Append("A_AppName,A_AppDescription,A_AppUrl,A_Order)"); strSql.Append(" values ("); strSql.Append("@A_AppName,@A_AppDescription,@A_AppUrl,@A_Order)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@A_AppName", SqlDbType.NVarChar, 50), new SqlParameter("@A_AppDescription", SqlDbType.NVarChar, 200), new SqlParameter("@A_AppUrl", SqlDbType.VarChar, 50), new SqlParameter("@A_Order", SqlDbType.Int, 4) }; parameters[0].Value = model.A_AppName; parameters[1].Value = model.A_AppDescription; parameters[2].Value = model.A_AppUrl; parameters[3].Value = model.A_Order; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Applications DataRowToModel(DataRow row) { Maticsoft.Model.sys_Applications model = new Maticsoft.Model.sys_Applications(); if (row != null) { if (row["ApplicationID"] != null && row["ApplicationID"].ToString() != "") { model.ApplicationID = int.Parse(row["ApplicationID"].ToString()); } if (row["A_AppName"] != null) { model.A_AppName = row["A_AppName"].ToString(); } if (row["A_AppDescription"] != null) { model.A_AppDescription = row["A_AppDescription"].ToString(); } if (row["A_AppUrl"] != null) { model.A_AppUrl = row["A_AppUrl"].ToString(); } if (row["A_Order"] != null && row["A_Order"].ToString() != "") { model.A_Order = int.Parse(row["A_Order"].ToString()); } } return(model); }
private void ShowInfo(int ApplicationID) { Maticsoft.BLL.sys_Applications bll = new Maticsoft.BLL.sys_Applications(); Maticsoft.Model.sys_Applications model = bll.GetModel(ApplicationID); this.lblApplicationID.Text = model.ApplicationID.ToString(); this.lblA_AppName.Text = model.A_AppName; this.lblA_AppDescription.Text = model.A_AppDescription; this.lblA_AppUrl.Text = model.A_AppUrl; this.lblA_Order.Text = model.A_Order.ToString(); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtA_AppName.Text.Trim().Length == 0) { strErr += "应用名称不能为空!\\n"; } if (this.txtA_AppDescription.Text.Trim().Length == 0) { strErr += "应用介绍不能为空!\\n"; } if (this.txtA_AppUrl.Text.Trim().Length == 0) { strErr += "应用Url地址不能为空!\\n"; } if (!PageValidate.IsNumber(txtA_Order.Text)) { strErr += "应用排序格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ApplicationID = int.Parse(this.lblApplicationID.Text); string A_AppName = this.txtA_AppName.Text; string A_AppDescription = this.txtA_AppDescription.Text; string A_AppUrl = this.txtA_AppUrl.Text; int A_Order = int.Parse(this.txtA_Order.Text); Maticsoft.Model.sys_Applications model = new Maticsoft.Model.sys_Applications(); model.ApplicationID = ApplicationID; model.A_AppName = A_AppName; model.A_AppDescription = A_AppDescription; model.A_AppUrl = A_AppUrl; model.A_Order = A_Order; Maticsoft.BLL.sys_Applications bll = new Maticsoft.BLL.sys_Applications(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtA_AppName.Text.Trim().Length==0) { strErr+="应用名称不能为空!\\n"; } if(this.txtA_AppDescription.Text.Trim().Length==0) { strErr+="应用介绍不能为空!\\n"; } if(this.txtA_AppUrl.Text.Trim().Length==0) { strErr+="应用Url地址不能为空!\\n"; } if(!PageValidate.IsNumber(txtA_Order.Text)) { strErr+="应用排序格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int ApplicationID=int.Parse(this.lblApplicationID.Text); string A_AppName=this.txtA_AppName.Text; string A_AppDescription=this.txtA_AppDescription.Text; string A_AppUrl=this.txtA_AppUrl.Text; int A_Order=int.Parse(this.txtA_Order.Text); Maticsoft.Model.sys_Applications model=new Maticsoft.Model.sys_Applications(); model.ApplicationID=ApplicationID; model.A_AppName=A_AppName; model.A_AppDescription=A_AppDescription; model.A_AppUrl=A_AppUrl; model.A_Order=A_Order; Maticsoft.BLL.sys_Applications bll=new Maticsoft.BLL.sys_Applications(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Applications GetModel(int ApplicationID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ApplicationID,A_AppName,A_AppDescription,A_AppUrl,A_Order from sys_Applications "); strSql.Append(" where ApplicationID=@ApplicationID"); SqlParameter[] parameters = { new SqlParameter("@ApplicationID", SqlDbType.Int, 4) }; parameters[0].Value = ApplicationID; Maticsoft.Model.sys_Applications model = new Maticsoft.Model.sys_Applications(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Applications GetModel(int ApplicationID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ApplicationID,A_AppName,A_AppDescription,A_AppUrl,A_Order from sys_Applications "); strSql.Append(" where ApplicationID=@ApplicationID"); SqlParameter[] parameters = { new SqlParameter("@ApplicationID", SqlDbType.Int,4) }; parameters[0].Value = ApplicationID; Maticsoft.Model.sys_Applications model=new Maticsoft.Model.sys_Applications(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }