/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Message model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Message("); strSql.Append("Id,SMSType,Title,Content,Status,Sender,Action,ActionDes)"); strSql.Append(" values ("); strSql.Append("@Id,@SMSType,@Title,@Content,@Status,@Sender,@Action,@ActionDes)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@SMSType", SqlDbType.Int,4), new SqlParameter("@Title", SqlDbType.NVarChar,100), new SqlParameter("@Content", SqlDbType.NVarChar,500), new SqlParameter("@Status", SqlDbType.Int,4), new SqlParameter("@Sender", SqlDbType.NVarChar,500), new SqlParameter("@Action", SqlDbType.NVarChar,50), new SqlParameter("@ActionDes", SqlDbType.NVarChar)}; parameters[0].Value = model.Id; parameters[1].Value = model.SMSType; parameters[2].Value = model.Title; parameters[3].Value = model.Content; parameters[4].Value = model.Status; parameters[5].Value = model.Sender; parameters[6].Value = model.Action; parameters[7].Value = model.ActionDes; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("declare @Id uniqueidentifier ;"); strSql.Append("SET @Id = NEWID();"); strSql.Append("insert into Customer("); strSql.Append("Id,Name,UserSex,UserAge,Area,BabyName,BabySex,BadyBirthday,Phone,Address,Des,AgentId,status,AddTime,AddUserId)"); strSql.Append(" values ("); strSql.Append("@Id,@Name,@UserSex,@UserAge,@Area,@BabyName,@BabySex,@BadyBirthday,@Phone,@Address,@Des,@AgentId,@status,@AddTime,@AddUserId)"); strSql.Append(";select @Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@UserSex", SqlDbType.Int,4), new SqlParameter("@UserAge", SqlDbType.Int,4), new SqlParameter("@Area", SqlDbType.UniqueIdentifier,16), new SqlParameter("@BabyName", SqlDbType.NVarChar,50), new SqlParameter("@BabySex", SqlDbType.Int,4), new SqlParameter("@BadyBirthday", SqlDbType.DateTime), new SqlParameter("@Phone", SqlDbType.NVarChar,30), new SqlParameter("@Address", SqlDbType.NVarChar,500), new SqlParameter("@Des", SqlDbType.NVarChar), new SqlParameter("@AgentId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@status", SqlDbType.Int,4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@AddUserId", SqlDbType.UniqueIdentifier,16)}; parameters[0].Value = model.Name; parameters[1].Value = model.UserSex; parameters[2].Value = model.UserAge; parameters[3].Value = model.Area; parameters[4].Value = model.BabyName; parameters[5].Value = model.BabySex; parameters[6].Value = model.BadyBirthday; parameters[7].Value = model.Phone; parameters[8].Value = model.Address; parameters[9].Value = model.Des; parameters[10].Value = model.AgentId; parameters[11].Value = model.status; parameters[12].Value = model.AddTime; parameters[13].Value = model.AddUserId; SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters); if (reader != null && !reader.IsClosed && reader.Read()) { if (!reader.IsDBNull(0)) { if (reader.GetValue(0).ToString() != "") { Guid id = new Guid(reader.GetValue(0).ToString()); model.Id = id; } } reader.Close(); } else { if (reader != null && !reader.IsClosed) reader.Close(); } }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Product model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Product("); strSql.Append("Name,status)"); strSql.Append(" values ("); strSql.Append("@Name,@status)"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,30), new SqlParameter("@status", SqlDbType.Int,4)}; parameters[0].Value = model.Name; parameters[1].Value = model.status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Festivals model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Festivals("); strSql.Append("Status,FName,FDateTime)"); strSql.Append(" values ("); strSql.Append("@Status,@FName,@FDateTime)"); SqlParameter[] parameters = { new SqlParameter("@Status", SqlDbType.Int,4), new SqlParameter("@FName", SqlDbType.NVarChar,50), new SqlParameter("@FDateTime", SqlDbType.DateTime)}; parameters[0].Value = model.Status; parameters[1].Value = model.FName; parameters[2].Value = model.FDateTime; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.AreaType model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into AreaType("); strSql.Append("Id,Name,status)"); strSql.Append(" values ("); strSql.Append("@Id,@Name,@status)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Name", SqlDbType.NVarChar,30), new SqlParameter("@status", SqlDbType.Int,4)}; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.AgentArea model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into AgentArea("); strSql.Append("AgentId,AreaId,Status)"); strSql.Append(" values ("); strSql.Append("@AgentId,@AreaId,@Status)"); SqlParameter[] parameters = { new SqlParameter("@AgentId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@AreaId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Status", SqlDbType.Int,4)}; parameters[0].Value = model.AgentId; parameters[1].Value = model.AreaId; parameters[2].Value = model.Status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Syssetting model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Syssetting("); strSql.Append("Id,Name,Value)"); strSql.Append(" values ("); strSql.Append("@Id,@Name,@Value)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Name", SqlDbType.NVarChar,200), new SqlParameter("@Value", SqlDbType.NVarChar,1000)}; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Value; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.CustomerProduct model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into CustomerProduct("); strSql.Append("CustomerId,ProductId,Status)"); strSql.Append(" values ("); strSql.Append("@CustomerId,@ProductId,@Status)"); SqlParameter[] parameters = { new SqlParameter("@CustomerId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ProductId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Status", SqlDbType.Int,4)}; parameters[0].Value = model.CustomerId; parameters[1].Value = model.ProductId; parameters[2].Value = model.Status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.MessageTemplate model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into MessageTemplate("); strSql.Append("Name,Content,status)"); strSql.Append(" values ("); strSql.Append("@Name,@Content,@status)"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,100), new SqlParameter("@Content", SqlDbType.NVarChar,500), new SqlParameter("@status", SqlDbType.Int,4)}; parameters[0].Value = model.Name; parameters[1].Value = model.Content; parameters[2].Value = model.status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.MessageDespatch model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into MessageDespatch("); strSql.Append("MessageId,CustomerId,DepatchTime,Type)"); strSql.Append(" values ("); strSql.Append("@MessageId,@CustomerId,@DepatchTime,@Type)"); SqlParameter[] parameters = { new SqlParameter("@MessageId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@CustomerId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@DepatchTime", SqlDbType.DateTime), new SqlParameter("@Type", SqlDbType.UniqueIdentifier,16)}; parameters[0].Value = model.MessageId; parameters[1].Value = model.CustomerId; parameters[2].Value = model.DepatchTime; parameters[3].Value = model.Type; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Agent model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Agent("); strSql.Append("UserName,Password,Name,Position,Phone,Mobile,Email,Address,IDCard,Remark,UserType,Des,Sex,status,AreaId)"); strSql.Append(" values ("); strSql.Append("@UserName,@Password,@Name,@Position,@Phone,@Mobile,@Email,@Address,@IDCard,@Remark,@UserType,@Des,@Sex,@status,@AreaId)"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar,50), new SqlParameter("@Password", SqlDbType.NVarChar,50), new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Position", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Phone", SqlDbType.NVarChar,30), new SqlParameter("@Mobile", SqlDbType.NVarChar,30), new SqlParameter("@Email", SqlDbType.NVarChar,100), new SqlParameter("@Address", SqlDbType.NVarChar,300), new SqlParameter("@IDCard", SqlDbType.NVarChar,100), new SqlParameter("@Remark", SqlDbType.NVarChar,1000), new SqlParameter("@UserType", SqlDbType.Int,4), new SqlParameter("@Des", SqlDbType.NVarChar), new SqlParameter("@Sex", SqlDbType.Int,4), new SqlParameter("@status", SqlDbType.Int,4), new SqlParameter("@AreaId", SqlDbType.UniqueIdentifier,16)}; parameters[0].Value = model.UserName; parameters[1].Value = model.Password; parameters[2].Value = model.Name; parameters[3].Value = model.Position; parameters[4].Value = model.Phone; parameters[5].Value = model.Mobile; parameters[6].Value = model.Email; parameters[7].Value = model.Address; parameters[8].Value = model.IDCard; parameters[9].Value = model.Remark; parameters[10].Value = model.UserType; parameters[11].Value = model.Des; parameters[12].Value = model.Sex; parameters[13].Value = model.status; parameters[14].Value = model.AreaId; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Area model) { StringBuilder strSql=new StringBuilder(); strSql.Append("declare @Id uniqueidentifier ;"); strSql.Append("SET @Id = NEWID();"); strSql.Append("insert into Area("); strSql.Append("Id,Name,WBS,Des,status)"); strSql.Append(" values ("); strSql.Append("@Id,@Name,@WBS,@Des,@status)"); strSql.Append(";select @Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,100), new SqlParameter("@WBS", SqlDbType.NVarChar,500), new SqlParameter("@Des", SqlDbType.NVarChar), new SqlParameter("@status", SqlDbType.Int,4)}; parameters[0].Value = model.Name; parameters[1].Value = model.WBS; parameters[2].Value = model.Des; parameters[3].Value = model.status; SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters); if (reader != null && !reader.IsClosed && reader.Read()) { if (!reader.IsDBNull(0)) { if (reader.GetValue(0).ToString() != "") { Guid id = new Guid(reader.GetValue(0).ToString()); model.Id = id; } } reader.Close(); } else { if (reader != null && !reader.IsClosed) reader.Close(); } }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.Agent model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Syssetting model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.Syssetting model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.MessageTemplate model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.MessageTemplate model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.CustomerProduct model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Product model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.AreaType model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.MessageTemplate model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update MessageTemplate set "); strSql.Append("Name=@Name,"); strSql.Append("Content=@Content,"); strSql.Append("status=@status"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Name", SqlDbType.NVarChar,100), new SqlParameter("@Content", SqlDbType.NVarChar,500), new SqlParameter("@status", SqlDbType.Int,4)}; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Content; parameters[3].Value = model.status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.CustomerProduct model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.Agent model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.Message model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Message set "); strSql.Append("SMSType=@SMSType,"); strSql.Append("Title=@Title,"); strSql.Append("Content=@Content,"); strSql.Append("Status=@Status,"); strSql.Append("Sender=@Sender,"); strSql.Append("Action=@Action,"); strSql.Append("ActionDes=@ActionDes"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@SMSType", SqlDbType.Int,4), new SqlParameter("@Title", SqlDbType.NVarChar,100), new SqlParameter("@Content", SqlDbType.NVarChar,500), new SqlParameter("@Status", SqlDbType.Int,4), new SqlParameter("@Sender", SqlDbType.NVarChar,500), new SqlParameter("@Action", SqlDbType.NVarChar,50), new SqlParameter("@ActionDes", SqlDbType.NVarChar)}; parameters[0].Value = model.Id; parameters[1].Value = model.SMSType; parameters[2].Value = model.Title; parameters[3].Value = model.Content; parameters[4].Value = model.Status; parameters[5].Value = model.Sender; parameters[6].Value = model.Action; parameters[7].Value = model.ActionDes; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.Area model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Area set "); strSql.Append("Name=@Name,"); strSql.Append("WBS=@WBS,"); strSql.Append("Des=@Des,"); strSql.Append("status=@status"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Name", SqlDbType.NVarChar,100), new SqlParameter("@WBS", SqlDbType.NVarChar,500), new SqlParameter("@Des", SqlDbType.NVarChar), new SqlParameter("@status", SqlDbType.Int,4)}; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.WBS; parameters[3].Value = model.Des; parameters[4].Value = model.status; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.Syssetting model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Syssetting set "); strSql.Append("Name=@Name,"); strSql.Append("Value=@Value"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Name", SqlDbType.NVarChar,200), new SqlParameter("@Value", SqlDbType.NVarChar,1000)}; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Value; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
void bindddl(SYCRM.Model.Agent manauser) { DDLLayer.DataSource = GetOwnArea(manauser.AreaId); DDLLayer.DataBind(); SYCRM.BLL.Position BP = new SYCRM.BLL.Position(); string strWhere = " status=1 "; List<SYCRM.Model.Position> listPost = BP.GetModelList(strWhere); ddlPost.DataSource = listPost; ddlPost.DataBind(); }
/// <summary> /// ����һ������ /// </summary> public void Update(SYCRM.Model.MessageDespatch model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.AreaType model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(SYCRM.Model.MessageDespatch model) { dal.Add(model); }