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