/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CustomerJPush model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CustomerJPush set ");
strSql.Append("CustomerId=@CustomerId,");
strSql.Append("RegId=@RegId,");
strSql.Append("Platform=@Platform,");
strSql.Append("Created=@Created");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@CustomerId", MySqlDbType.Int32, 11),
new MySqlParameter("@RegId", MySqlDbType.VarChar, 200),
new MySqlParameter("@Platform", MySqlDbType.VarChar, 2),
new MySqlParameter("@Created", MySqlDbType.DateTime),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.CustomerId;
parameters[1].Value = model.RegId;
parameters[2].Value = model.Platform;
parameters[3].Value = model.Created;
parameters[4].Value = model.Id;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CustomerJPush model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CustomerJPush(");
strSql.Append("CustomerId,RegId,Platform,Created)");
strSql.Append(" values (");
strSql.Append("@CustomerId,@RegId,@Platform,@Created)");
MySqlParameter[] parameters =
{
new MySqlParameter("@CustomerId", MySqlDbType.Int32, 11),
new MySqlParameter("@RegId", MySqlDbType.VarChar, 200),
new MySqlParameter("@Platform", MySqlDbType.VarChar, 2),
new MySqlParameter("@Created", MySqlDbType.DateTime)
};
parameters[0].Value = model.CustomerId;
parameters[1].Value = model.RegId;
parameters[2].Value = model.Platform;
parameters[3].Value = model.Created;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string idlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from CustomerJPush ");
strSql.Append(" where Id in (" + idlist + ") ");
int rows = DbHelperMySql.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SystemConfig model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SystemConfig set ");
strSql.Append("Category=@Category,");
strSql.Append("Key=@Key,");
strSql.Append("Value=@Value,");
strSql.Append("Name=@Name,");
strSql.Append("Deleted=@Deleted,");
strSql.Append("Created=@Created,");
strSql.Append("Modified=@Modified");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Category", MySqlDbType.VarChar, 2),
new MySqlParameter("@Key", MySqlDbType.VarChar, 100),
new MySqlParameter("@Value", MySqlDbType.VarChar, 1000),
new MySqlParameter("@Name", MySqlDbType.VarChar, 50),
new MySqlParameter("@Deleted", MySqlDbType.Bit),
new MySqlParameter("@Created", MySqlDbType.DateTime),
new MySqlParameter("@Modified", MySqlDbType.DateTime),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Category;
parameters[1].Value = model.Key;
parameters[2].Value = model.Value;
parameters[3].Value = model.Name;
parameters[4].Value = model.Deleted;
parameters[5].Value = model.Created;
parameters[6].Value = model.Modified;
parameters[7].Value = model.Id;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from CustomerJPush ");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = id;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SystemConfig model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemConfig(");
strSql.Append("Category,Key,Value,Name,Deleted,Created,Modified)");
strSql.Append(" values (");
strSql.Append("@Category,@Key,@Value,@Name,@Deleted,@Created,@Modified)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Category", MySqlDbType.VarChar, 2),
new MySqlParameter("@Key", MySqlDbType.VarChar, 100),
new MySqlParameter("@Value", MySqlDbType.VarChar, 1000),
new MySqlParameter("@Name", MySqlDbType.VarChar, 50),
new MySqlParameter("@Deleted", MySqlDbType.Bit),
new MySqlParameter("@Created", MySqlDbType.DateTime),
new MySqlParameter("@Modified", MySqlDbType.DateTime)
};
parameters[0].Value = model.Category;
parameters[1].Value = model.Key;
parameters[2].Value = model.Value;
parameters[3].Value = model.Name;
parameters[4].Value = model.Deleted;
parameters[5].Value = model.Created;
parameters[6].Value = model.Modified;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Customer model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Customer(");
strSql.Append("Account,Password,Sign,NickName,Name,Phone,Email,OpenId,CardType,CardNo,Photo,ReferenceId,IsGrantLibrary,Count,Platform,RegisterIP,RegisterAddredss,Deleted,Created,Modified,RedeemPassword,EnabledFingerprint,HadaCount,IsAutoRedeem,IsSetPassword)");
strSql.Append(" values (");
strSql.Append("@Account,@Password,@Sign,@NickName,@Name,@Phone,@Email,@OpenId,@CardType,@CardNo,@Photo,@ReferenceId,@IsGrantLibrary,@Count,@Platform,@RegisterIP,@RegisterAddredss,@Deleted,@Created,@Modified,@RedeemPassword,@EnabledFingerprint,@HadaCount,@IsAutoRedeem,@IsSetPassword)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Account", MySqlDbType.VarChar, 50),
new MySqlParameter("@Password", MySqlDbType.VarChar, 100),
new MySqlParameter("@Sign", MySqlDbType.VarChar, 50),
new MySqlParameter("@NickName", MySqlDbType.VarChar, 50),
new MySqlParameter("@Name", MySqlDbType.VarChar, 50),
new MySqlParameter("@Phone", MySqlDbType.VarChar, 11),
new MySqlParameter("@Email", MySqlDbType.VarChar, 100),
new MySqlParameter("@OpenId", MySqlDbType.VarChar, 200),
new MySqlParameter("@CardType", MySqlDbType.VarChar, 2),
new MySqlParameter("@CardNo", MySqlDbType.VarChar, 50),
new MySqlParameter("@Photo", MySqlDbType.VarChar, 500),
new MySqlParameter("@ReferenceId", MySqlDbType.Int32, 11),
new MySqlParameter("@IsGrantLibrary", MySqlDbType.Bit),
new MySqlParameter("@Count", MySqlDbType.Int32, 11),
new MySqlParameter("@Platform", MySqlDbType.VarChar, 50),
new MySqlParameter("@RegisterIP", MySqlDbType.VarChar, 20),
new MySqlParameter("@RegisterAddredss", MySqlDbType.VarChar, 20),
new MySqlParameter("@Deleted", MySqlDbType.Bit),
new MySqlParameter("@Created", MySqlDbType.DateTime),
new MySqlParameter("@Modified", MySqlDbType.DateTime),
new MySqlParameter("@RedeemPassword", MySqlDbType.VarChar, 200),
new MySqlParameter("@EnabledFingerprint", MySqlDbType.Bit),
new MySqlParameter("@HadaCount", MySqlDbType.Int32, 11),
new MySqlParameter("@IsAutoRedeem", MySqlDbType.Bit),
new MySqlParameter("@IsSetPassword", MySqlDbType.Bit)
};
parameters[0].Value = model.Account;
parameters[1].Value = model.Password;
parameters[2].Value = model.Sign;
parameters[3].Value = model.NickName;
parameters[4].Value = model.Name;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Email;
parameters[7].Value = model.OpenId;
parameters[8].Value = model.CardType;
parameters[9].Value = model.CardNo;
parameters[10].Value = model.Photo;
parameters[11].Value = model.ReferenceId;
parameters[12].Value = model.IsGrantLibrary;
parameters[13].Value = model.Count;
parameters[14].Value = model.Platform;
parameters[15].Value = model.RegisterIP;
parameters[16].Value = model.RegisterAddredss;
parameters[17].Value = model.Deleted;
parameters[18].Value = model.Created;
parameters[19].Value = model.Modified;
parameters[20].Value = model.RedeemPassword;
parameters[21].Value = model.EnabledFingerprint;
parameters[22].Value = model.HadaCount;
parameters[23].Value = model.IsAutoRedeem;
parameters[24].Value = model.IsSetPassword;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Customer model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Customer set ");
strSql.Append("Account=@Account,");
strSql.Append("Password=@Password,");
strSql.Append("Sign=@Sign,");
strSql.Append("NickName=@NickName,");
strSql.Append("Name=@Name,");
strSql.Append("Phone=@Phone,");
strSql.Append("Email=@Email,");
strSql.Append("OpenId=@OpenId,");
strSql.Append("CardType=@CardType,");
strSql.Append("CardNo=@CardNo,");
strSql.Append("Photo=@Photo,");
strSql.Append("ReferenceId=@ReferenceId,");
strSql.Append("IsGrantLibrary=@IsGrantLibrary,");
strSql.Append("Count=@Count,");
strSql.Append("Platform=@Platform,");
strSql.Append("RegisterIP=@RegisterIP,");
strSql.Append("RegisterAddredss=@RegisterAddredss,");
strSql.Append("Deleted=@Deleted,");
strSql.Append("Created=@Created,");
strSql.Append("Modified=@Modified,");
strSql.Append("RedeemPassword=@RedeemPassword,");
strSql.Append("EnabledFingerprint=@EnabledFingerprint,");
strSql.Append("HadaCount=@HadaCount,");
strSql.Append("IsAutoRedeem=@IsAutoRedeem,");
strSql.Append("IsSetPassword=@IsSetPassword");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Account", MySqlDbType.VarChar, 50),
new MySqlParameter("@Password", MySqlDbType.VarChar, 100),
new MySqlParameter("@Sign", MySqlDbType.VarChar, 50),
new MySqlParameter("@NickName", MySqlDbType.VarChar, 50),
new MySqlParameter("@Name", MySqlDbType.VarChar, 50),
new MySqlParameter("@Phone", MySqlDbType.VarChar, 11),
new MySqlParameter("@Email", MySqlDbType.VarChar, 100),
new MySqlParameter("@OpenId", MySqlDbType.VarChar, 200),
new MySqlParameter("@CardType", MySqlDbType.VarChar, 2),
new MySqlParameter("@CardNo", MySqlDbType.VarChar, 50),
new MySqlParameter("@Photo", MySqlDbType.VarChar, 500),
new MySqlParameter("@ReferenceId", MySqlDbType.Int32, 11),
new MySqlParameter("@IsGrantLibrary", MySqlDbType.Bit),
new MySqlParameter("@Count", MySqlDbType.Int32, 11),
new MySqlParameter("@Platform", MySqlDbType.VarChar, 50),
new MySqlParameter("@RegisterIP", MySqlDbType.VarChar, 20),
new MySqlParameter("@RegisterAddredss", MySqlDbType.VarChar, 20),
new MySqlParameter("@Deleted", MySqlDbType.Bit),
new MySqlParameter("@Created", MySqlDbType.DateTime),
new MySqlParameter("@Modified", MySqlDbType.DateTime),
new MySqlParameter("@RedeemPassword", MySqlDbType.VarChar, 200),
new MySqlParameter("@EnabledFingerprint", MySqlDbType.Bit),
new MySqlParameter("@HadaCount", MySqlDbType.Int32, 11),
new MySqlParameter("@IsAutoRedeem", MySqlDbType.Bit),
new MySqlParameter("@IsSetPassword", MySqlDbType.Bit),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Account;
parameters[1].Value = model.Password;
parameters[2].Value = model.Sign;
parameters[3].Value = model.NickName;
parameters[4].Value = model.Name;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Email;
parameters[7].Value = model.OpenId;
parameters[8].Value = model.CardType;
parameters[9].Value = model.CardNo;
parameters[10].Value = model.Photo;
parameters[11].Value = model.ReferenceId;
parameters[12].Value = model.IsGrantLibrary;
parameters[13].Value = model.Count;
parameters[14].Value = model.Platform;
parameters[15].Value = model.RegisterIP;
parameters[16].Value = model.RegisterAddredss;
parameters[17].Value = model.Deleted;
parameters[18].Value = model.Created;
parameters[19].Value = model.Modified;
parameters[20].Value = model.RedeemPassword;
parameters[21].Value = model.EnabledFingerprint;
parameters[22].Value = model.HadaCount;
parameters[23].Value = model.IsAutoRedeem;
parameters[24].Value = model.IsSetPassword;
parameters[25].Value = model.Id;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
