private void ShowInfo() { WebDemo.BLL.WebDemo.InvoiceTemplate bll = new WebDemo.BLL.WebDemo.InvoiceTemplate(); WebDemo.Model.WebDemo.InvoiceTemplate model = bll.GetModel(); this.lblTemplateID.Text = model.TemplateID.ToString(); this.lblTemplateName.Text = model.TemplateName; this.lblTemplatePath.Text = model.TemplatePath; this.lblFlag.Text = model.Flag.ToString(); this.lblTemplateFile.Text = model.TemplateFile.ToString(); this.lblLastOperTime.Text = model.LastOperTime.ToString(); this.lblLastOperatorId.Text = model.LastOperatorId.ToString(); this.lblRemark.Text = model.Remark; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.InvoiceTemplate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update InvoiceTemplate set "); strSql.Append("TemplateID=@TemplateID,"); strSql.Append("TemplateName=@TemplateName,"); strSql.Append("TemplatePath=@TemplatePath,"); strSql.Append("Flag=@Flag,"); strSql.Append("TemplateFile=@TemplateFile,"); strSql.Append("LastOperTime=@LastOperTime,"); strSql.Append("LastOperatorId=@LastOperatorId,"); strSql.Append("Remark=@Remark"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@TemplateID", SqlDbType.Int, 4), new SqlParameter("@TemplateName", SqlDbType.VarChar, 200), new SqlParameter("@TemplatePath", SqlDbType.VarChar, 200), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@TemplateFile", SqlDbType.VarBinary, 1), new SqlParameter("@LastOperTime", SqlDbType.DateTime), new SqlParameter("@LastOperatorId", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.TemplateID; parameters[1].Value = model.TemplateName; parameters[2].Value = model.TemplatePath; parameters[3].Value = model.Flag; parameters[4].Value = model.TemplateFile; parameters[5].Value = model.LastOperTime; parameters[6].Value = model.LastOperatorId; parameters[7].Value = model.Remark; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.InvoiceTemplate DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.InvoiceTemplate model = new WebDemo.Model.WebDemo.InvoiceTemplate(); if (row != null) { if (row["TemplateID"] != null && row["TemplateID"].ToString() != "") { model.TemplateID = int.Parse(row["TemplateID"].ToString()); } if (row["TemplateName"] != null) { model.TemplateName = row["TemplateName"].ToString(); } if (row["TemplatePath"] != null) { model.TemplatePath = row["TemplatePath"].ToString(); } if (row["Flag"] != null && row["Flag"].ToString() != "") { model.Flag = int.Parse(row["Flag"].ToString()); } if (row["TemplateFile"] != null && row["TemplateFile"].ToString() != "") { model.TemplateFile = (byte[])row["TemplateFile"]; } if (row["LastOperTime"] != null && row["LastOperTime"].ToString() != "") { model.LastOperTime = DateTime.Parse(row["LastOperTime"].ToString()); } if (row["LastOperatorId"] != null && row["LastOperatorId"].ToString() != "") { model.LastOperatorId = int.Parse(row["LastOperatorId"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.InvoiceTemplate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into InvoiceTemplate("); strSql.Append("TemplateID,TemplateName,TemplatePath,Flag,TemplateFile,LastOperTime,LastOperatorId,Remark)"); strSql.Append(" values ("); strSql.Append("@TemplateID,@TemplateName,@TemplatePath,@Flag,@TemplateFile,@LastOperTime,@LastOperatorId,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@TemplateID", SqlDbType.Int, 4), new SqlParameter("@TemplateName", SqlDbType.VarChar, 200), new SqlParameter("@TemplatePath", SqlDbType.VarChar, 200), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@TemplateFile", SqlDbType.VarBinary, 1), new SqlParameter("@LastOperTime", SqlDbType.DateTime), new SqlParameter("@LastOperatorId", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.TemplateID; parameters[1].Value = model.TemplateName; parameters[2].Value = model.TemplatePath; parameters[3].Value = model.Flag; parameters[4].Value = model.TemplateFile; parameters[5].Value = model.LastOperTime; parameters[6].Value = model.LastOperatorId; parameters[7].Value = model.Remark; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.InvoiceTemplate GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TemplateID,TemplateName,TemplatePath,Flag,TemplateFile,LastOperTime,LastOperatorId,Remark from InvoiceTemplate "); strSql.Append(" where "); SqlParameter[] parameters = { }; WebDemo.Model.WebDemo.InvoiceTemplate model = new WebDemo.Model.WebDemo.InvoiceTemplate(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtTemplateID.Text)) { strErr += "TemplateID格式错误!\\n"; } if (this.txtTemplateName.Text.Trim().Length == 0) { strErr += "TemplateName不能为空!\\n"; } if (this.txtTemplatePath.Text.Trim().Length == 0) { strErr += "TemplatePath不能为空!\\n"; } if (!PageValidate.IsNumber(txtFlag.Text)) { strErr += "Flag格式错误!\\n"; } if (!PageValidate.IsDateTime(txtLastOperTime.Text)) { strErr += "LastOperTime格式错误!\\n"; } if (!PageValidate.IsNumber(txtLastOperatorId.Text)) { strErr += "LastOperatorId格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int TemplateID = int.Parse(this.txtTemplateID.Text); string TemplateName = this.txtTemplateName.Text; string TemplatePath = this.txtTemplatePath.Text; int Flag = int.Parse(this.txtFlag.Text); byte[] TemplateFile = new UnicodeEncoding().GetBytes(this.txtTemplateFile.Text); DateTime LastOperTime = DateTime.Parse(this.txtLastOperTime.Text); int LastOperatorId = int.Parse(this.txtLastOperatorId.Text); string Remark = this.txtRemark.Text; WebDemo.Model.WebDemo.InvoiceTemplate model = new WebDemo.Model.WebDemo.InvoiceTemplate(); model.TemplateID = TemplateID; model.TemplateName = TemplateName; model.TemplatePath = TemplatePath; model.Flag = Flag; model.TemplateFile = TemplateFile; model.LastOperTime = LastOperTime; model.LastOperatorId = LastOperatorId; model.Remark = Remark; WebDemo.BLL.WebDemo.InvoiceTemplate bll = new WebDemo.BLL.WebDemo.InvoiceTemplate(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }