public HttpResponseMessage DeleteCusType(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_CusType = JsonConvert.DeserializeObject <CusType>(_requestedDataObject.BusinessData);
}
if (_CusType == null || string.IsNullOrWhiteSpace(_CusType.CusTypeId))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "Customer TypeId Not Found...");
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
result = _ICusTypeService.DeleteCusType(_CusType);
if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been deleted successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been deleted");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
/// <summary>
///[CusType]表查询实体的方法
/// </summary>
public static CusType getCusTypeById(int id)
{
CusType custype = null;
string sql = "select * from CusType where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
custype = new CusType();
foreach (DataRow dr in dt.Rows)
{
custype.Id = Convert.ToInt32(dr["id"]);
custype.TypeName = Convert.ToString(dr["typeName"]);
custype.Typeremark = Convert.ToString(dr["typeremark"]);
}
}
return(custype);
}
public HttpResponseMessage UpdateCusType(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_CusType = JsonConvert.DeserializeObject <CusType>(_requestedDataObject.BusinessData);
bool IsValid = ModelValidation.TryValidateModel(_CusType, out _modelErrorMsg);
if (IsValid)
{
result = _ICusTypeService.UpdateCusType(_CusType);
}
}
if (!string.IsNullOrWhiteSpace(_modelErrorMsg))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, _modelErrorMsg);
}
else if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been updated successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been updated");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public HttpResponseMessage GetCusTypeById(HttpRequestMessage reqObject)
{
string CusGroupId = string.Empty;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_CusType = JsonConvert.DeserializeObject <CusType>(_requestedDataObject.BusinessData);
CusGroupId = _CusType.CusCategoryId;
}
if (!string.IsNullOrWhiteSpace(CusGroupId))
{
_CusType = new CusType();
_CusType = _ICusTypeService.GetCusTypeById(CusGroupId);
}
if (_CusType != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(_CusType, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(_CusType, "Data Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
/// <summary>
///[CusType]表添加的方法
/// </summary>
public static int addCusType(CusType custype)
{
string sql = "insert into CusType([typeName],[typeremark]) values (@typeName,@typeremark)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@typeName", custype.TypeName),
new SqlParameter("@typeremark", custype.Typeremark)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[CusType]表修改的方法
/// </summary>
public static int updateCusTypeById(CusType custype)
{
string sql = "update CusType set typeName=@typeName,typeremark=@typeremark where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", custype.Id),
new SqlParameter("@typeName", custype.TypeName),
new SqlParameter("@typeremark", custype.Typeremark)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
public int DeleteCusType(CusType _CusType)
{
try
{
int result = 0;
bool IsRecordExist;
if (!string.IsNullOrWhiteSpace(_CusType.CusTypeId))
{
IsRecordExist = _IUoW.Repository <CusType>().IsRecordExist(x => x.CusTypeId == _CusType.CusTypeId);
if (IsRecordExist)
{
var _oldCusType = _IUoW.Repository <CusType>().GetBy(x => x.CusTypeId == _CusType.CusTypeId);
var _oldCusTypeForLog = ObjectCopier.DeepCopy(_oldCusType);
_oldCusType.AuthStatusId = _CusType.AuthStatusId = "U";
_oldCusType.LastAction = _CusType.LastAction = "DEL";
_oldCusType.LastUpdateDT = _CusType.LastUpdateDT = System.DateTime.Now;
result = _IUoW.Repository <CusType>().Update(_oldCusType);
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, _oldCusTypeForLog, _CusType, "DEL", "0001", _CusType.FunctionId, 1, "CusType", "MTK_SP_CUS_TYPE", "CusTypeId", _CusType.CusTypeId, _CusType.UserName, _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
//result = _IUoW.Repository<CusType>().Delete(_CusType);
return(result);
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "DeleteCusType(obj)", string.Empty);
return(0);
}
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static CusType getCusTypeBySql(string sql)
{
CusType custype = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
custype = new CusType();
foreach (DataRow dr in dt.Rows)
{
custype.Id = Convert.ToInt32(dr["id"]);
custype.TypeName = Convert.ToString(dr["typeName"]);
custype.Typeremark = Convert.ToString(dr["typeremark"]);
}
}
return(custype);
}
public CusType GetCreateInfoForCusType()
{
try
{
_CusType = new CusType();
_ICusCategoryService = new CusCategoryService();
_CusType.CusCategoryDD = _ICusCategoryService.GetCusCategoryForDD();
return(_CusType);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetCreateInfoForCusType()", string.Empty);
return(null);
//throw ex;
}
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
public static IList <CusType> getCusTypesBySql(string sql)
{
IList <CusType> list = new List <CusType>();
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
CusType custype = new CusType();
custype.Id = Convert.ToInt32(dr["id"]);
custype.TypeName = Convert.ToString(dr["typeName"]);
custype.Typeremark = Convert.ToString(dr["typeremark"]);
list.Add(custype);
}
}
return(list);
}
public CusType GetCusTypeBy(CusType _CusType)
{
try
{
if (_CusType == null)
{
return(_CusType);
}
return(_IUoW.Repository <CusType>().GetBy(x => x.CusTypeId == _CusType.CusTypeId &&
x.AuthStatusId == "A" &&
x.LastAction != "DEL"));
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetCusTypeBy(obj)", string.Empty);
return(null);
}
}
public HttpResponseMessage GetCusTypeBy(HttpRequestMessage reqObject)
{
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_CusType = JsonConvert.DeserializeObject <CusType>(_requestedDataObject.BusinessData);
_CusType = _ICusTypeService.GetCusTypeBy(_CusType);
}
if (_CusType != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(_CusType, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(_CusType, "Data Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
protected void imgbtnsave_Click(object sender, ImageClickEventArgs e)
{
if (tbxTypeName.Text.ToString() == "")
{
this.lblTypename.Text = "<span style='Color:red'>类别名称不能为空！<span>";
}
else if (Checktypename(tbxTypeName.Text.ToString()) > 0)
{
this.lblTypename.Text = "<span style='Color:red'>类别名称已存在<span>";
}
else
{
CusType type = new CusType();
type.TypeName = this.tbxTypeName.Text.ToString();
type.Typeremark = this.tbxTypeRemark.Text.ToString();
CusTypeManager.addCusType(type);
getAddType();
this.tbxTypeName.Text = "";
this.lblTypename.Text = "";
}
}
public static int addCusType(CusType custype)
{
return(CusTypeService.addCusType(custype));
}
public static int updateCusType(CusType custype)
{
return(CusTypeService.updateCusTypeById(custype));
}
public int UpdateCusType(CusType _CusType)
{
try
{
int result = 0;
bool IsRecordExist;
if (!string.IsNullOrWhiteSpace(_CusType.CusTypeId))
{
IsRecordExist = _IUoW.Repository <CusType>().IsRecordExist(x => x.CusTypeId == _CusType.CusTypeId);
if (IsRecordExist)
{
var _oldCusType = _IUoW.Repository <CusType>().GetBy(x => x.CusTypeId == _CusType.CusTypeId);
var _oldCusTypeForLog = ObjectCopier.DeepCopy(_oldCusType);
_oldCusType.AuthStatusId = _CusType.AuthStatusId = "U";
_oldCusType.LastAction = _CusType.LastAction = "EDT";
_oldCusType.LastUpdateDT = _CusType.LastUpdateDT = System.DateTime.Now;
_CusType.MakeBy = "mtaka";
result = _IUoW.Repository <CusType>().Update(_oldCusType);
#region Testing Purpose
//List<Test> ListTest = new List<Test>();
//for (int i = 0; i < 5; i++)
//{
// Test Obj_Test = new Test();
// Obj_Test.Id = i.ToString();
// Obj_Test.Name = "T" + i.ToString();
// ListTest.Add(Obj_Test);
//}
//_CusType.ListTest = ListTest;
//List<Test> ListTest1 = new List<Test>();
//for (int i = 0; i < 5; i++)
//{
// Test Obj_Test = new Test();
// Obj_Test.Id = i.ToString();
// Obj_Test.Name = "T" + (i + 10).ToString();
// ListTest1.Add(Obj_Test);
//}
#endregion
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, _oldCusTypeForLog, _CusType, "EDT", "0001", _CusType.FunctionId, 1, "CusType", "MTK_SP_CUS_TYPE", "CusTypeId", _CusType.CusTypeId, _CusType.UserName, _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
//_IAuthLogService.AddAuthLog(_IUoW, ListTest1, ListTest, "EDT", "0001", "010101002", 0, "TEST", "Id", null, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "UpdateCusType(obj)", string.Empty);
return(0);
}
}
public int AddCusType(CusType _CusType)
{
try
{
var _max = _IUoW.Repository <CusType>().GetMaxValue(x => x.CusTypeId) + 1;
_CusType.CusTypeId = _max.ToString().PadLeft(3, '0');
_CusType.AuthStatusId = "U";
_CusType.LastAction = "ADD";
_CusType.MakeDT = System.DateTime.Now;
_CusType.MakeBy = "mtaka";
var result = _IUoW.Repository <CusType>().Add(_CusType);
#region Tesing Purpose
//List<CusType> ListCusType = new List<CusType>();
//for (int i = 0; i < 3; i++)
//{
// CusType Obj_CusType = new CusType();
// Obj_CusType.CusTypeId = (_max++).ToString().PadLeft(3, '0');
// Obj_CusType.CusTypeNm = "Test" + i.ToString();
// Obj_CusType.CusGroupId = "01";
// Obj_CusType.AuthStatusId = "U";
// Obj_CusType.LastAction = "ADD";
// Obj_CusType.MakeDT = System.DateTime.Now;
// Obj_CusType.MakeBy = "mtaka";
// ListCusType.Add(Obj_CusType);
//}
//var result = _IUoW.Repository<CusType>().AddRange(ListCusType);
//List<Test> ListTest = new List<Test>();
//for (int i = 0; i < 5; i++)
//{
// Test Obj_Test = new Test();
// Obj_Test.Id = i.ToString();
// Obj_Test.Name = "T" + i.ToString();
// ListTest.Add(Obj_Test);
//}
//_CusType.ListTest = ListTest;
#endregion
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, null, _CusType, "ADD", "0001", _CusType.FunctionId, 1, "CusType", "MTK_SP_CUS_TYPE", "CusTypeId", _CusType.CusTypeId, _CusType.UserName, _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
//_IAuthLogService.AddAuthLog(_IUoW, null, ListTest, "ADD", "0001", "010101002", 0, "TEST", "ID", null, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddCusType(obj)", string.Empty);
return(0);
}
}
