/// <summary> /// 添加 /// </summary> /// <param name="essentialInformation"></param> /// <returns></returns> public int Add(EssentialInformation essentialInformation) { using (MySqlConnection conn = DapperHelper.GetConnString()) { conn.Open(); DynamicParameters parameters = new DynamicParameters(); parameters.Add("@PartnerName", essentialInformation.PartnerName, null, null, null); parameters.Add("@PartnerCategory", essentialInformation.PartnerCategory, null, null, null); parameters.Add("@BusinessLicenseName", essentialInformation.BusinessLicenseName, null, null, null); parameters.Add("@BusinessLicenseURL", essentialInformation.BusinessLicenseURL, null, null, null); parameters.Add("@IsStart", essentialInformation.IsStart, null, null, null); parameters.Add("@Remark", essentialInformation.Remark, null, null, null); parameters.Add("@Post", essentialInformation.Post, null, null, null); parameters.Add("@TechnicalGrade", essentialInformation.TechnicalGrade, null, null, null); parameters.Add("@MonthlyPay", essentialInformation.MonthlyPay, null, null, null); parameters.Add("@BankCard", essentialInformation.BankCard, null, null, null); parameters.Add("@CreationTime", essentialInformation.CreationTime, null, null, null); parameters.Add("@ModificationTime", essentialInformation.ModificationTime, null, null, null); parameters.Add("@IsDelete", essentialInformation.IsDelete, null, null, null); string sql = string.Format("INSERT INTO EssentialInformation(PartnerName, PartnerCategory, BusinessLicenseName, BusinessLicenseURL, IsStart, Remark, Post, TechnicalGrade, MonthlyPay, BankCard, CreationTime, ModificationTime, IsDelete)" + "VALUES(@PartnerName, @PartnerCategory, @BusinessLicenseName, @BusinessLicenseURL, @IsStart, @Remark, @Post, @TechnicalGrade, @MonthlyPay, @BankCard, @CreationTime, @ModificationTime, @IsDelete)"); int i = conn.Execute(sql, parameters); return(i); } }
/// <summary> /// 修改 /// </summary> /// <param name="essentialInformation"></param> /// <returns></returns> public int Update(EssentialInformation essentialInformation) { using (MySqlConnection conn = DapperHelper.GetConnString()) { conn.Open(); essentialInformation.CreationTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd HH:mm")); essentialInformation.ModificationTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd HH:mm")); DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Id", essentialInformation.Id, null, null, null); parameters.Add("@PartnerName", essentialInformation.PartnerName, null, null, null); parameters.Add("@PartnerCategory", essentialInformation.PartnerCategory, null, null, null); parameters.Add("@BusinessLicenseName", essentialInformation.BusinessLicenseName, null, null, null); parameters.Add("@BusinessLicenseURL", essentialInformation.BusinessLicenseURL, null, null, null); parameters.Add("@IsStart", essentialInformation.IsStart, null, null, null); parameters.Add("@Remark", essentialInformation.Remark, null, null, null); parameters.Add("@Post", essentialInformation.Post, null, null, null); parameters.Add("@TechnicalGrade", essentialInformation.TechnicalGrade, null, null, null); parameters.Add("@MonthlyPay", essentialInformation.MonthlyPay, null, null, null); parameters.Add("@BankCard", essentialInformation.BankCard, null, null, null); parameters.Add("@CreationTime", essentialInformation.CreationTime, null, null, null); parameters.Add("@ModificationTime", essentialInformation.ModificationTime, null, null, null); parameters.Add("@IsDelete", essentialInformation.IsDelete, null, null, null); string sql = string.Format("UPDATE EssentialInformation SET PartnerName = @PartnerName, PartnerCategory = @PartnerCategory, BusinessLicenseName = @BusinessLicenseName," + " BusinessLicenseURL = @BusinessLicenseURL, IsStart = @IsStart, Remark =@Remark, Post = @Post, TechnicalGrade = @TechnicalGrade, MonthlyPay = @MonthlyPay, BankCard =@BankCard, " + "CreationTime =@CreationTime, ModificationTime = @ModificationTime, IsDelete = @IsDelete WHERE Id = @Id"); int i = conn.Execute(sql, parameters); return(i); } }
public int Update(EssentialInformation essentialInformation) { int i = this.essentialInformation.Update(essentialInformation); return(i); }
public int Add(EssentialInformation essentialInformation) { int i = this.essentialInformation.Add(essentialInformation); return(i); }