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