/// <summary> /// 更新一条数据 /// </summary> public bool Update(yinxiang.Model.smes_functionName model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update smes_functionName set "); strSql.Append("orgId=@orgId,"); strSql.Append("functionName=@functionName,"); strSql.Append("functionPath=@functionPath,"); strSql.Append("functionGroup=@functionGroup,"); strSql.Append("creater=@creater,"); strSql.Append("useNum=@useNum,"); strSql.Append("lastUser=@lastUser,"); strSql.Append("lastUseDate=@lastUseDate,"); strSql.Append("memo=@memo,"); strSql.Append("functioncode=@functioncode"); strSql.Append(" where functionid=@functionid"); SqlParameter[] parameters = { new SqlParameter("@orgId", SqlDbType.VarChar, 50), new SqlParameter("@functionName", SqlDbType.VarChar, 50), new SqlParameter("@functionPath", SqlDbType.VarChar, 250), new SqlParameter("@functionGroup", SqlDbType.VarChar, 50), new SqlParameter("@creater", SqlDbType.VarChar, 50), new SqlParameter("@useNum", SqlDbType.BigInt, 8), new SqlParameter("@lastUser", SqlDbType.VarChar, 50), new SqlParameter("@lastUseDate", SqlDbType.VarChar, 50), new SqlParameter("@memo", SqlDbType.VarChar, 500), new SqlParameter("@functioncode", SqlDbType.VarChar, 50), new SqlParameter("@functionid", SqlDbType.BigInt, 8) }; parameters[0].Value = model.orgId; parameters[1].Value = model.functionName; parameters[2].Value = model.functionPath; parameters[3].Value = model.functionGroup; parameters[4].Value = model.creater; parameters[5].Value = model.useNum; parameters[6].Value = model.lastUser; parameters[7].Value = model.lastUseDate; parameters[8].Value = model.memo; parameters[9].Value = model.functioncode; parameters[10].Value = model.functionid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public yinxiang.Model.smes_functionName DataRowToModel(DataRow row) { yinxiang.Model.smes_functionName model = new yinxiang.Model.smes_functionName(); if (row != null) { if (row["functionid"] != null && row["functionid"].ToString() != "") { model.functionid = long.Parse(row["functionid"].ToString()); } if (row["orgId"] != null) { model.orgId = row["orgId"].ToString(); } if (row["functionName"] != null) { model.functionName = row["functionName"].ToString(); } if (row["functionPath"] != null) { model.functionPath = row["functionPath"].ToString(); } if (row["functionGroup"] != null) { model.functionGroup = row["functionGroup"].ToString(); } if (row["creater"] != null) { model.creater = row["creater"].ToString(); } if (row["useNum"] != null && row["useNum"].ToString() != "") { model.useNum = long.Parse(row["useNum"].ToString()); } if (row["lastUser"] != null) { model.lastUser = row["lastUser"].ToString(); } if (row["lastUseDate"] != null) { model.lastUseDate = row["lastUseDate"].ToString(); } if (row["memo"] != null) { model.memo = row["memo"].ToString(); } if (row["functioncode"] != null) { model.functioncode = row["functioncode"].ToString(); } } return(model); }
private void ShowInfo(long functionid) { yinxiang.BLL.smes_functionName bll = new yinxiang.BLL.smes_functionName(); yinxiang.Model.smes_functionName model = bll.GetModel(functionid); this.lblfunctionid.Text = model.functionid.ToString(); this.lblorgId.Text = model.orgId; this.lblfunctionName.Text = model.functionName; this.lblfunctionPath.Text = model.functionPath; this.lblfunctionGroup.Text = model.functionGroup; this.lblcreater.Text = model.creater; this.lbluseNum.Text = model.useNum.ToString(); this.lbllastUser.Text = model.lastUser; this.lbllastUseDate.Text = model.lastUseDate; this.lblmemo.Text = model.memo; this.lblfunctioncode.Text = model.functioncode; }
/// <summary> /// 增加一条数据 /// </summary> public long Add(yinxiang.Model.smes_functionName model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into smes_functionName("); strSql.Append("orgId,functionName,functionPath,functionGroup,creater,useNum,lastUser,lastUseDate,memo,functioncode)"); strSql.Append(" values ("); strSql.Append("@orgId,@functionName,@functionPath,@functionGroup,@creater,@useNum,@lastUser,@lastUseDate,@memo,@functioncode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@orgId", SqlDbType.VarChar, 50), new SqlParameter("@functionName", SqlDbType.VarChar, 50), new SqlParameter("@functionPath", SqlDbType.VarChar, 250), new SqlParameter("@functionGroup", SqlDbType.VarChar, 50), new SqlParameter("@creater", SqlDbType.VarChar, 50), new SqlParameter("@useNum", SqlDbType.BigInt, 8), new SqlParameter("@lastUser", SqlDbType.VarChar, 50), new SqlParameter("@lastUseDate", SqlDbType.VarChar, 50), new SqlParameter("@memo", SqlDbType.VarChar, 500), new SqlParameter("@functioncode", SqlDbType.VarChar, 50) }; parameters[0].Value = model.orgId; parameters[1].Value = model.functionName; parameters[2].Value = model.functionPath; parameters[3].Value = model.functionGroup; parameters[4].Value = model.creater; parameters[5].Value = model.useNum; parameters[6].Value = model.lastUser; parameters[7].Value = model.lastUseDate; parameters[8].Value = model.memo; parameters[9].Value = model.functioncode; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public yinxiang.Model.smes_functionName GetModel(long functionid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 functionid,orgId,functionName,functionPath,functionGroup,creater,useNum,lastUser,lastUseDate,memo,functioncode from smes_functionName "); strSql.Append(" where functionid=@functionid"); SqlParameter[] parameters = { new SqlParameter("@functionid", SqlDbType.BigInt) }; parameters[0].Value = functionid; yinxiang.Model.smes_functionName model = new yinxiang.Model.smes_functionName(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtorgId.Text.Trim().Length == 0) { strErr += "orgId不能为空!\\n"; } if (this.txtfunctionName.Text.Trim().Length == 0) { strErr += "functionName不能为空!\\n"; } if (this.txtfunctionPath.Text.Trim().Length == 0) { strErr += "functionPath不能为空!\\n"; } if (this.txtfunctionGroup.Text.Trim().Length == 0) { strErr += "functionGroup不能为空!\\n"; } if (this.txtcreater.Text.Trim().Length == 0) { strErr += "creater不能为空!\\n"; } if (this.txtuseNum.Text.Trim().Length == 0) { strErr += "useNum不能为空!\\n"; } if (this.txtlastUser.Text.Trim().Length == 0) { strErr += "lastUser不能为空!\\n"; } if (this.txtlastUseDate.Text.Trim().Length == 0) { strErr += "lastUseDate不能为空!\\n"; } if (this.txtmemo.Text.Trim().Length == 0) { strErr += "memo不能为空!\\n"; } if (this.txtfunctioncode.Text.Trim().Length == 0) { strErr += "functioncode不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string orgId = this.txtorgId.Text; string functionName = this.txtfunctionName.Text; string functionPath = this.txtfunctionPath.Text; string functionGroup = this.txtfunctionGroup.Text; string creater = this.txtcreater.Text; string useNum = this.txtuseNum.Text; string lastUser = this.txtlastUser.Text; string lastUseDate = this.txtlastUseDate.Text; string memo = this.txtmemo.Text; string functioncode = this.txtfunctioncode.Text; yinxiang.Model.smes_functionName model = new yinxiang.Model.smes_functionName(); model.orgId = orgId; model.functionName = functionName; model.functionPath = functionPath; model.functionGroup = functionGroup; model.creater = creater; model.useNum = 1; model.lastUser = lastUser; model.lastUseDate = lastUseDate; model.memo = memo; model.functioncode = functioncode; yinxiang.BLL.smes_functionName bll = new yinxiang.BLL.smes_functionName(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtorgId.Text.Trim().Length == 0) { strErr += "orgId不能为空!\\n"; } if (this.txtfunctionName.Text.Trim().Length == 0) { strErr += "functionName不能为空!\\n"; } if (this.txtfunctionPath.Text.Trim().Length == 0) { strErr += "functionPath不能为空!\\n"; } if (this.txtfunctionGroup.Text.Trim().Length == 0) { strErr += "functionGroup不能为空!\\n"; } if (this.txtcreater.Text.Trim().Length == 0) { strErr += "creater不能为空!\\n"; } if (!PageValidate.IsNumber(txtuseNum.Text)) { strErr += "useNum格式错误!\\n"; } if (this.txtlastUser.Text.Trim().Length == 0) { strErr += "lastUser不能为空!\\n"; } if (this.txtlastUseDate.Text.Trim().Length == 0) { strErr += "lastUseDate不能为空!\\n"; } if (this.txtmemo.Text.Trim().Length == 0) { strErr += "memo不能为空!\\n"; } if (this.txtfunctioncode.Text.Trim().Length == 0) { strErr += "functioncode不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } long functionid = long.Parse(this.lblfunctionid.Text); string orgId = this.txtorgId.Text; string functionName = this.txtfunctionName.Text; string functionPath = this.txtfunctionPath.Text; string functionGroup = this.txtfunctionGroup.Text; string creater = this.txtcreater.Text; long useNum = long.Parse(this.txtuseNum.Text); string lastUser = this.txtlastUser.Text; string lastUseDate = this.txtlastUseDate.Text; string memo = this.txtmemo.Text; string functioncode = this.txtfunctioncode.Text; yinxiang.Model.smes_functionName model = new yinxiang.Model.smes_functionName(); model.functionid = functionid; model.orgId = orgId; model.functionName = functionName; model.functionPath = functionPath; model.functionGroup = functionGroup; model.creater = creater; model.useNum = useNum; model.lastUser = lastUser; model.lastUseDate = lastUseDate; model.memo = memo; model.functioncode = functioncode; yinxiang.BLL.smes_functionName bll = new yinxiang.BLL.smes_functionName(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }