public ActionResult <object> Delete(int AC_ID)
{
b_appointment_consultation_Entity entity = new b_appointment_consultation_Entity();
this.SetUpdateUserInfo(entity);
this._repository.Update(entity, AC_ID);
return(this._repository.Delete(AC_ID).ResponseSuccess());
}
public ActionResult <object> UpdateStatus([FromBody] b_appointment_consultationVM model, int AC_ID)
{
b_appointment_consultation_Entity entity = new b_appointment_consultation_Entity
{
AC_Status = 1,
Processing_Result = model.Processing_Result
};
this.SetUpdateUserInfo(entity);
return(this._repository.Update(entity, AC_ID).ResponseSuccess());
}
public ActionResult <object> GetList(string Company, string Phone, int AC_Status, int pageindex = 1, int pagesize = 24)
{
b_appointment_consultation_Entity entity = new b_appointment_consultation_Entity
{
Company = Company,
Phone = Phone,
AC_Status = AC_Status
};
var(list, total) = this._repository.GetList(entity, pageindex, pagesize);
return(list.ResponseSuccess("", total));
}
/// <summary>
/// 获取列表
/// <summary>
public (IEnumerable <b_appointment_consultation_Entity>, int) GetList(b_appointment_consultation_Entity model, int pageindex, int pagesize)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
if (model.AC_ID != 0)
{
dic["AC_ID"] = model.AC_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.Material != null)
{
dic["Material"] = model.Material;
}
if (model.AC_Status >= 0)
{
dic["AC_Status"] = model.AC_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_appointment_consultation_Entity>("Select_b_appointment_consultation_List", dic, out int total);
return(list, total);
}
public ActionResult <object> Post([FromBody] b_appointment_consultationVM 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_appointment_consultation_Entity entity = model.ConvertToT <b_appointment_consultation_Entity>();
entity.Create_User = model.Contacts;
entity.Create_UserId = "-1";
return(this._repository.Insert(entity).ResponseSuccess());
}
/// <summary>
/// 修改
/// <summary>
public bool Update(b_appointment_consultation_Entity model, int AC_ID)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic["AC_ID"] = AC_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.Material != null)
{
dic["Material"] = model.Material;
}
dic["AC_Status"] = model.AC_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_appointment_consultation", dic) > 0);
}
