/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Numbers model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_Numbers(");
strSql.Append("Number,Remark,UserId,GroupId)");
strSql.Append(" values (");
strSql.Append("@Number,@Remark,@UserId,@GroupId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Number", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,50),
new SqlParameter("@UserId", SqlDbType.VarChar,50),
new SqlParameter("@GroupId", SqlDbType.Int,4)};
parameters[0].Value = model.Number;
parameters[1].Value = model.Remark;
parameters[2].Value = model.UserId;
parameters[3].Value = model.GroupId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_UserSmsAccount model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_UserSmsAccount(");
strSql.Append("UserId,SmsType,InitNum,LargessNum,LeaveNum,AwokeNum)");
strSql.Append(" values (");
strSql.Append("@UserId,@SmsType,@InitNum,@LargessNum,@LeaveNum,@AwokeNum)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@SmsType", SqlDbType.VarChar,10),
new SqlParameter("@InitNum", SqlDbType.Int,4),
new SqlParameter("@LargessNum", SqlDbType.Int,4),
new SqlParameter("@LeaveNum", SqlDbType.Int,4),
new SqlParameter("@AwokeNum", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.SmsType;
parameters[2].Value = model.InitNum;
parameters[3].Value = model.LargessNum;
parameters[4].Value = model.LeaveNum;
parameters[5].Value = model.AwokeNum;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_PhraseGroup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_PhraseGroup(");
strSql.Append("Name,ParentId,UserId)");
strSql.Append(" values (");
strSql.Append("@Name,@ParentId,@UserId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@ParentId", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.VarChar,50)};
parameters[0].Value = model.Name;
parameters[1].Value = model.ParentId;
parameters[2].Value = model.UserId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Advice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_Advice(");
strSql.Append("Content,State,SubmitTime,UserId,DoneTime,DoneUserId)");
strSql.Append(" values (");
strSql.Append("@Content,@State,@SubmitTime,@UserId,@DoneTime,@DoneUserId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Content", SqlDbType.VarChar,2000),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@SubmitTime", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@DoneTime", SqlDbType.DateTime),
new SqlParameter("@DoneUserId", SqlDbType.Int,4)};
parameters[0].Value = model.Content;
parameters[1].Value = model.State;
parameters[2].Value = model.SubmitTime;
parameters[3].Value = model.UserId;
parameters[4].Value = model.DoneTime;
parameters[5].Value = model.DoneUserId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(ECSMS.Model.EC_SmsChannel model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_SmsChannel(");
strSql.Append("Code,Name,Account,Pwd,CorpId,ProductCode,OtherPara,TotalNum,MaxSendNum,AwokeNum,State)");
strSql.Append(" values (");
strSql.Append("@Code,@Name,@Account,@Pwd,@CorpId,@ProductCode,@OtherPara,@TotalNum,@MaxSendNum,@AwokeNum,@State)");
SqlParameter[] parameters = {
new SqlParameter("@Code", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Account", SqlDbType.VarChar,50),
new SqlParameter("@Pwd", SqlDbType.VarChar,50),
new SqlParameter("@CorpId", SqlDbType.Int,4),
new SqlParameter("@ProductCode", SqlDbType.VarChar,20),
new SqlParameter("@OtherPara", SqlDbType.VarChar,50),
new SqlParameter("@TotalNum", SqlDbType.Int,4),
new SqlParameter("@MaxSendNum", SqlDbType.Int,4),
new SqlParameter("@AwokeNum", SqlDbType.Int,4),
new SqlParameter("@State", SqlDbType.Int,4)};
parameters[0].Value = model.Code;
parameters[1].Value = model.Name;
parameters[2].Value = model.Account;
parameters[3].Value = model.Pwd;
parameters[4].Value = model.CorpId;
parameters[5].Value = model.ProductCode;
parameters[6].Value = model.OtherPara;
parameters[7].Value = model.TotalNum;
parameters[8].Value = model.MaxSendNum;
parameters[9].Value = model.AwokeNum;
parameters[10].Value = model.State;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Config model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_Config(");
strSql.Append("DelPwd,PlatMax,UserMax)");
strSql.Append(" values (");
strSql.Append("@DelPwd,@PlatMax,@UserMax)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@DelPwd", SqlDbType.VarChar,50),
new SqlParameter("@PlatMax", SqlDbType.Int,4),
new SqlParameter("@UserMax", SqlDbType.Int,4)};
parameters[0].Value = model.DelPwd;
parameters[1].Value = model.PlatMax;
parameters[2].Value = model.UserMax;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_AutoPay model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_AutoPay(");
strSql.Append("Name,Account,UserId,UserKey,Expenses,Enabled,PostUser)");
strSql.Append(" values (");
strSql.Append("@Name,@Account,@UserId,@UserKey,@Expenses,@Enabled,@PostUser)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Account", SqlDbType.VarChar,50),
new SqlParameter("@UserId", SqlDbType.Decimal,9),
new SqlParameter("@UserKey", SqlDbType.VarChar,50),
new SqlParameter("@Expenses", SqlDbType.VarChar,50),
new SqlParameter("@Enabled", SqlDbType.Int,4),
new SqlParameter("@PostUser", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.Account;
parameters[2].Value = model.UserId;
parameters[3].Value = model.UserKey;
parameters[4].Value = model.Expenses;
parameters[5].Value = model.Enabled;
parameters[6].Value = model.PostUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_ProChannel model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_ProChannel(");
strSql.Append("ProCode,SpCode,Channel)");
strSql.Append(" values (");
strSql.Append("@ProCode,@SpCode,@Channel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ProCode", SqlDbType.VarChar,50),
new SqlParameter("@SpCode", SqlDbType.VarChar,50),
new SqlParameter("@Channel", SqlDbType.VarChar,50)};
parameters[0].Value = model.ProCode;
parameters[1].Value = model.SpCode;
parameters[2].Value = model.Channel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Calendar model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_Calendar(");
strSql.Append("Title,Content,ToDoTime,PostTime,IsDone,UserId)");
strSql.Append(" values (");
strSql.Append("@Title,@Content,@ToDoTime,@PostTime,@IsDone,@UserId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.VarChar,100),
new SqlParameter("@Content", SqlDbType.VarChar,2000),
new SqlParameter("@ToDoTime", SqlDbType.DateTime),
new SqlParameter("@PostTime", SqlDbType.DateTime),
new SqlParameter("@IsDone", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.Int,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Content;
parameters[2].Value = model.ToDoTime;
parameters[3].Value = model.PostTime;
parameters[4].Value = model.IsDone;
parameters[5].Value = model.UserId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_DownLoad model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_DownLoad(");
strSql.Append("FullFileName,ShowName,Remark,PostTime,Price)");
strSql.Append(" values (");
strSql.Append("@FullFileName,@ShowName,@Remark,@PostTime,@Price)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@FullFileName", SqlDbType.VarChar,50),
new SqlParameter("@ShowName", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,50),
new SqlParameter("@PostTime", SqlDbType.DateTime),
new SqlParameter("@Price", SqlDbType.VarChar,50)};
parameters[0].Value = model.FullFileName;
parameters[1].Value = model.ShowName;
parameters[2].Value = model.Remark;
parameters[3].Value = model.PostTime;
parameters[4].Value = model.Price;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.SendMsgTable model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SendMsgTable(");
strSql.Append("PhoneNumber,MsgTitle,MMSInfoFile,TimeSend,MsgStatus,MsgType,SentTime,RunInfo,SendReport,ServerMsgID,SpId,UserId,IsExperNum,SendNum,SendTime,ExerNumbers,NumbersCount,ServerID)");
strSql.Append(" values (");
strSql.Append("@PhoneNumber,@MsgTitle,@MMSInfoFile,@TimeSend,@MsgStatus,@MsgType,@SentTime,@RunInfo,@SendReport,@ServerMsgID,@SpId,@UserId,@IsExperNum,@SendNum,@SendTime,@ExerNumbers,@NumbersCount,@ServerID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PhoneNumber", SqlDbType.Text),
new SqlParameter("@MsgTitle", SqlDbType.VarChar,500),
new SqlParameter("@MMSInfoFile", SqlDbType.VarChar,100),
new SqlParameter("@TimeSend", SqlDbType.VarChar,50),
new SqlParameter("@MsgStatus", SqlDbType.Int,4),
new SqlParameter("@MsgType", SqlDbType.VarChar,50),
new SqlParameter("@SentTime", SqlDbType.VarChar,50),
new SqlParameter("@RunInfo", SqlDbType.VarChar,50),
new SqlParameter("@SendReport", SqlDbType.VarChar,50),
new SqlParameter("@ServerMsgID", SqlDbType.VarChar,50),
new SqlParameter("@SpId", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@IsExperNum", SqlDbType.Int,4),
new SqlParameter("@SendNum", SqlDbType.Int,4),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@ExerNumbers", SqlDbType.Int,4),
new SqlParameter("@NumbersCount", SqlDbType.Int,4),
new SqlParameter("@ServerID", SqlDbType.VarChar,80)};
parameters[0].Value = model.PhoneNumber;
parameters[1].Value = model.MsgTitle;
parameters[2].Value = model.MMSInfoFile;
parameters[3].Value = model.TimeSend;
parameters[4].Value = model.MsgStatus;
parameters[5].Value = model.MsgType;
parameters[6].Value = model.SentTime;
parameters[7].Value = model.RunInfo;
parameters[8].Value = model.SendReport;
parameters[9].Value = model.ServerMsgID;
parameters[10].Value = model.SpId;
parameters[11].Value = model.UserId;
parameters[12].Value = model.IsExperNum;
parameters[13].Value = model.SendNum;
parameters[14].Value = model.SendTime;
parameters[15].Value = model.ExerNumbers;
parameters[16].Value = model.NumbersCount;
parameters[17].Value = model.ServerID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.RecvMsgTable model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RecvMsgTable(");
strSql.Append("PhoneNumber,MsgTilte,RecvMMSFileDir,MsgStatus,MsgType,RecvTime,ResFile1,ResFile2,ResFile3,ResFile4,ResFile5)");
strSql.Append(" values (");
strSql.Append("@PhoneNumber,@MsgTilte,@RecvMMSFileDir,@MsgStatus,@MsgType,@RecvTime,@ResFile1,@ResFile2,@ResFile3,@ResFile4,@ResFile5)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PhoneNumber", SqlDbType.VarChar,50),
new SqlParameter("@MsgTilte", SqlDbType.VarChar,500),
new SqlParameter("@RecvMMSFileDir", SqlDbType.VarChar,50),
new SqlParameter("@MsgStatus", SqlDbType.Int,4),
new SqlParameter("@MsgType", SqlDbType.Int,4),
new SqlParameter("@RecvTime", SqlDbType.DateTime),
new SqlParameter("@ResFile1", SqlDbType.VarChar,50),
new SqlParameter("@ResFile2", SqlDbType.VarChar,50),
new SqlParameter("@ResFile3", SqlDbType.VarChar,50),
new SqlParameter("@ResFile4", SqlDbType.VarChar,50),
new SqlParameter("@ResFile5", SqlDbType.VarChar,50)};
parameters[0].Value = model.PhoneNumber;
parameters[1].Value = model.MsgTilte;
parameters[2].Value = model.RecvMMSFileDir;
parameters[3].Value = model.MsgStatus;
parameters[4].Value = model.MsgType;
parameters[5].Value = model.RecvTime;
parameters[6].Value = model.ResFile1;
parameters[7].Value = model.ResFile2;
parameters[8].Value = model.ResFile3;
parameters[9].Value = model.ResFile4;
parameters[10].Value = model.ResFile5;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(ECSMS.Model.EC_SmsType model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_SmsType(");
strSql.Append("Type,Name,Remark,ChannelCode,Price)");
strSql.Append(" values (");
strSql.Append("@Type,@Name,@Remark,@ChannelCode,@Price)");
SqlParameter[] parameters = {
new SqlParameter("@Type", SqlDbType.VarChar,10),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,50),
new SqlParameter("@ChannelCode", SqlDbType.VarChar,50),
new SqlParameter("@Price", SqlDbType.VarChar,50)};
parameters[0].Value = model.Type;
parameters[1].Value = model.Name;
parameters[2].Value = model.Remark;
parameters[3].Value = model.ChannelCode;
parameters[4].Value = model.Price;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_SmsAssignLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_SmsAssignLog(");
strSql.Append("ToUserId,ActType,SmsCount,SmsType,FromUserId,OperTime,IsPay,Remark,LeaveNum)");
strSql.Append(" values (");
strSql.Append("@ToUserId,@ActType,@SmsCount,@SmsType,@FromUserId,@OperTime,@IsPay,@Remark,@LeaveNum)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ToUserId", SqlDbType.Int,4),
new SqlParameter("@ActType", SqlDbType.VarChar,10),
new SqlParameter("@SmsCount", SqlDbType.Int,4),
new SqlParameter("@SmsType", SqlDbType.VarChar,10),
new SqlParameter("@FromUserId", SqlDbType.Int,4),
new SqlParameter("@OperTime", SqlDbType.DateTime),
new SqlParameter("@IsPay", SqlDbType.Int,4),
new SqlParameter("@Remark", SqlDbType.VarChar,50),
new SqlParameter("@LeaveNum", SqlDbType.Int,4)};
parameters[0].Value = model.ToUserId;
parameters[1].Value = model.ActType;
parameters[2].Value = model.SmsCount;
parameters[3].Value = model.SmsType;
parameters[4].Value = model.FromUserId;
parameters[5].Value = model.OperTime;
parameters[6].Value = model.IsPay;
parameters[7].Value = model.Remark;
parameters[8].Value = model.LeaveNum;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_SmsSp model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_SmsSp(");
strSql.Append("Name,Limit)");
strSql.Append(" values (");
strSql.Append("@Name,@Limit)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Limit", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.Limit;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_SmsSegment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EC_SmsSegment(");
strSql.Append("SpId,Segment)");
strSql.Append(" values (");
strSql.Append("@SpId,@Segment)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@SpId", SqlDbType.Int,4),
new SqlParameter("@Segment", SqlDbType.VarChar,50)};
parameters[0].Value = model.SpId;
parameters[1].Value = model.Segment;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.RecvMsgTable model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update RecvMsgTable set ");
strSql.Append("PhoneNumber=@PhoneNumber,");
strSql.Append("MsgTilte=@MsgTilte,");
strSql.Append("RecvMMSFileDir=@RecvMMSFileDir,");
strSql.Append("MsgStatus=@MsgStatus,");
strSql.Append("MsgType=@MsgType,");
strSql.Append("RecvTime=@RecvTime,");
strSql.Append("ResFile1=@ResFile1,");
strSql.Append("ResFile2=@ResFile2,");
strSql.Append("ResFile3=@ResFile3,");
strSql.Append("ResFile4=@ResFile4,");
strSql.Append("ResFile5=@ResFile5");
strSql.Append(" where MsgIndex=@MsgIndex");
SqlParameter[] parameters = {
new SqlParameter("@PhoneNumber", SqlDbType.VarChar,50),
new SqlParameter("@MsgTilte", SqlDbType.VarChar,500),
new SqlParameter("@RecvMMSFileDir", SqlDbType.VarChar,50),
new SqlParameter("@MsgStatus", SqlDbType.Int,4),
new SqlParameter("@MsgType", SqlDbType.Int,4),
new SqlParameter("@RecvTime", SqlDbType.DateTime),
new SqlParameter("@ResFile1", SqlDbType.VarChar,50),
new SqlParameter("@ResFile2", SqlDbType.VarChar,50),
new SqlParameter("@ResFile3", SqlDbType.VarChar,50),
new SqlParameter("@ResFile4", SqlDbType.VarChar,50),
new SqlParameter("@ResFile5", SqlDbType.VarChar,50),
new SqlParameter("@MsgIndex", SqlDbType.Int,4)};
parameters[0].Value = model.PhoneNumber;
parameters[1].Value = model.MsgTilte;
parameters[2].Value = model.RecvMMSFileDir;
parameters[3].Value = model.MsgStatus;
parameters[4].Value = model.MsgType;
parameters[5].Value = model.RecvTime;
parameters[6].Value = model.ResFile1;
parameters[7].Value = model.ResFile2;
parameters[8].Value = model.ResFile3;
parameters[9].Value = model.ResFile4;
parameters[10].Value = model.ResFile5;
parameters[11].Value = model.MsgIndex;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Customer model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_UserSmsAccount model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update EC_UserSmsAccount set ");
strSql.Append("UserId=@UserId,");
strSql.Append("SmsType=@SmsType,");
strSql.Append("InitNum=@InitNum,");
strSql.Append("LargessNum=@LargessNum,");
strSql.Append("LeaveNum=@LeaveNum,");
strSql.Append("AwokeNum=@AwokeNum");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@SmsType", SqlDbType.VarChar,10),
new SqlParameter("@InitNum", SqlDbType.Int,4),
new SqlParameter("@LargessNum", SqlDbType.Int,4),
new SqlParameter("@LeaveNum", SqlDbType.Int,4),
new SqlParameter("@AwokeNum", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.SmsType;
parameters[2].Value = model.InitNum;
parameters[3].Value = model.LargessNum;
parameters[4].Value = model.LeaveNum;
parameters[5].Value = model.AwokeNum;
parameters[6].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_AutoPay model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_Customer model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Advice model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_PhraseGroup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update EC_PhraseGroup set ");
strSql.Append("Name=@Name,");
strSql.Append("ParentId=@ParentId,");
strSql.Append("UserId=@UserId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@ParentId", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.VarChar,50),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.ParentId;
parameters[2].Value = model.UserId;
parameters[3].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_Bank model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_Advice model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_Bank model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_NumbersGroup model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_Advice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update EC_Advice set ");
strSql.Append("Content=@Content,");
strSql.Append("State=@State,");
strSql.Append("SubmitTime=@SubmitTime,");
strSql.Append("UserId=@UserId,");
strSql.Append("DoneTime=@DoneTime,");
strSql.Append("DoneUserId=@DoneUserId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Content", SqlDbType.VarChar,2000),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@SubmitTime", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@DoneTime", SqlDbType.DateTime),
new SqlParameter("@DoneUserId", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Content;
parameters[1].Value = model.State;
parameters[2].Value = model.SubmitTime;
parameters[3].Value = model.UserId;
parameters[4].Value = model.DoneTime;
parameters[5].Value = model.DoneUserId;
parameters[6].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(ECSMS.Model.EC_NumbersGroup model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(ECSMS.Model.EC_Numbers model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update EC_Numbers set ");
strSql.Append("Number=@Number,");
strSql.Append("Remark=@Remark,");
strSql.Append("UserId=@UserId,");
strSql.Append("GroupId=@GroupId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Number", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,50),
new SqlParameter("@UserId", SqlDbType.VarChar,50),
new SqlParameter("@GroupId", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Number;
parameters[1].Value = model.Remark;
parameters[2].Value = model.UserId;
parameters[3].Value = model.GroupId;
parameters[4].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
