public ActionResult <object> Delete(int Contact_ID)
{
b_contact_Entity entity = new b_contact_Entity();
this.SetUpdateUserInfo(entity);
this._repository.Update(entity, Contact_ID);
return(this._repository.Delete(Contact_ID).ResponseSuccess());
}
/// <summary>
/// 获取列表
/// <summary>
public (IEnumerable <b_contact_Entity>, int) GetList(b_contact_Entity model, int pageindex, int pagesize)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
if (model.Contact_ID != 0)
{
dic["Contact_ID"] = model.Contact_ID;
}
if (model.Company != null)
{
dic["Company"] = model.Company;
}
if (model.Contacts != null)
{
dic["Contacts"] = model.Contacts;
}
if (model.Phone != null)
{
dic["Phone"] = model.Phone;
}
if (model.Email != null)
{
dic["Email"] = model.Email;
}
if (model.Matter != null)
{
dic["Matter"] = model.Matter;
}
if (model.Wechat != null)
{
dic["Wechat"] = model.Wechat;
}
if (model.WhatsApp != null)
{
dic["WhatsApp"] = model.WhatsApp;
}
if (model.Contact_Status >= 0)
{
dic["Contact_Status"] = model.Contact_Status;
}
if (model.Processing_Result != null)
{
dic["Processing_Result"] = model.Processing_Result;
}
if (pageindex >= 0)
{
dic["StartIndex"] = pageindex <= 1 ? 0 : (pageindex - 1) * pagesize;
}
if (pagesize > 0)
{
dic["SelectCount"] = pagesize;
}
var list = SQLHelperFactory.Instance.QueryMultipleByPage <b_contact_Entity>("Select_b_contact_List", dic, out int total);
return(list, total);
}
public ActionResult <object> UpdateStatus([FromBody] b_contactVM model, int Contact_ID)
{
b_contact_Entity entity = new b_contact_Entity
{
Contact_Status = 1,
Processing_Result = model.Processing_Result
};
this.SetUpdateUserInfo(entity);
return(this._repository.Update(entity, Contact_ID).ResponseSuccess());
}
public ActionResult <object> GetList(string Company, string Phone, int Contact_Status, int pageindex = 1, int pagesize = 24)
{
b_contact_Entity entity = new b_contact_Entity
{
Company = Company,
Phone = Phone,
Contact_Status = Contact_Status
};
var(list, total) = this._repository.GetList(entity, pageindex, pagesize);
return(list.ResponseSuccess("", total));
}
/// <summary>
/// 修改
/// <summary>
public bool Update(b_contact_Entity model, int Contact_ID)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic["Contact_ID"] = Contact_ID;
if (model.Company != null)
{
dic["Company"] = model.Company;
}
if (model.Contacts != null)
{
dic["Contacts"] = model.Contacts;
}
if (model.Phone != null)
{
dic["Phone"] = model.Phone;
}
if (model.Email != null)
{
dic["Email"] = model.Email;
}
if (model.Matter != null)
{
dic["Matter"] = model.Matter;
}
if (model.Wechat != null)
{
dic["Wechat"] = model.Wechat;
}
if (model.WhatsApp != null)
{
dic["WhatsApp"] = model.WhatsApp;
}
dic["Contact_Status"] = model.Contact_Status;
if (model.Processing_Result != null)
{
dic["Processing_Result"] = model.Processing_Result;
}
if (model.Update_Time != null && model.Update_Time.HasValue)
{
dic["Update_Time"] = model.Update_Time;
}
if (model.Update_UserId != null)
{
dic["Update_UserId"] = model.Update_UserId;
}
if (model.Update_User != null)
{
dic["Update_User"] = model.Update_User;
}
return(SQLHelperFactory.Instance.ExecuteNonQuery("Update_b_contact", dic) > 0);
}
public ActionResult <object> Post([FromBody] b_contactVM model, string code)
{
if (string.IsNullOrWhiteSpace(code) || string.IsNullOrWhiteSpace(HttpContext.Session.GetString(Constant.Session_CheckCode)) || !code.ToLower().Equals(HttpContext.Session.GetString(Constant.Session_CheckCode).ToLower()))
{
return(this.ResponseUnknown("验证码错误"));
}
HttpContext.Session.Remove(Constant.Session_CheckCode);
b_contact_Entity entity = model.ConvertToT <b_contact_Entity>();
entity.Create_User = model.Contacts;
entity.Create_UserId = "-1";
return(this._repository.Insert(entity).ResponseSuccess());
}
/// <summary>
/// 新增
/// <summary>
public bool Insert(b_contact_Entity model)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
if (model.Company != null)
{
dic["Company"] = model.Company;
}
if (model.Contacts != null)
{
dic["Contacts"] = model.Contacts;
}
if (model.Phone != null)
{
dic["Phone"] = model.Phone;
}
if (model.Email != null)
{
dic["Email"] = model.Email;
}
if (model.Matter != null)
{
dic["Matter"] = model.Matter;
}
if (model.Wechat != null)
{
dic["Wechat"] = model.Wechat;
}
if (model.WhatsApp != null)
{
dic["WhatsApp"] = model.WhatsApp;
}
dic["Contact_Status"] = model.Contact_Status;
if (model.Processing_Result != null)
{
dic["Processing_Result"] = model.Processing_Result;
}
if (model.Create_UserId != null)
{
dic["Create_UserId"] = model.Create_UserId;
}
if (model.Create_User != null)
{
dic["Create_User"] = model.Create_User;
}
return(SQLHelperFactory.Instance.ExecuteNonQuery("Insert_b_contact", dic) > 0);
}
