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