/// <summary>
/// 获取客户订单账目列表
/// </summary>
public static List <ClientOrderAccount> GetClientOrderAccounts(string keyWords, string orderID, string clientID, int payType, int status, int type, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string sqlWhere = "a.Status<>9";
if (!string.IsNullOrEmpty(keyWords))
{
sqlWhere += " and ( a.OrderID like '%" + keyWords + "%' or a.ClientID like '%" + keyWords + "%' )";
}
if (!string.IsNullOrEmpty(orderID))
{
sqlWhere += " and ( a.OrderID ='" + orderID + "' )";
}
if (!string.IsNullOrEmpty(clientID))
{
sqlWhere += " and ( a.ClientID ='" + clientID + "' )";
}
if (payType > 0)
{
sqlWhere += " and ( a.PayType ='" + payType + "' )";
}
if (type > 0)
{
sqlWhere += " and ( a.Type ='" + type + "' )";
}
if (status > 0)
{
sqlWhere += " and ( a.Status ='" + status + "' )";
}
string sqlColumn = @" * ";
DataTable dt = CommonBusiness.GetPagerData("ClientOrderAccount a", sqlColumn, sqlWhere, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ClientOrderAccount> list = new List <ClientOrderAccount>();
ClientOrderAccount model;
foreach (DataRow item in dt.Rows)
{
model = new ClientOrderAccount();
model.FillData(item);
if (!string.IsNullOrEmpty(model.CreateUserID))
{
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
if (string.IsNullOrEmpty(model.CreateUser.Name))
{
M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID);
model.CreateUser.Name = mUser != null ? mUser.Name : "";
model.CreateUser.UserID = model.CreateUserID;
}
}
if (!string.IsNullOrEmpty(model.CheckUserID))
{
model.CheckerUser = M_UsersBusiness.GetUserDetail(model.CheckUserID);
}
list.Add(model);
}
return(list);
}
public JsonResult AddOrderAccount(string orderAccount)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
ClientOrderAccount model = serializer.Deserialize <ClientOrderAccount>(orderAccount);
int result = 0;
model.CreateUserID = CurrentUser.UserID;
result = ClientOrderAccountBusiness.AddClientOrderAccount(model);
JsonDictionary.Add("Result", result);
return(new JsonResult()
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public static ClientOrderAccount GetClientOrderAccountByAutoID(string autoid)
{
DataTable dt = ClientOrderAccountDAL.BaseProvider.ClientOrderAccountByAutoIDDAL(autoid);
ClientOrderAccount model = new ClientOrderAccount();
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
model.FillData(row);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 新增订单账目明细
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int AddClientOrderAccount(ClientOrderAccount model)
{
return(ClientOrderAccountDAL.BaseProvider.InsertClientOrderAccount(model.OrderID, model.PayType, model.RealAmount, model.Type, model.ClientID, model.CreateUserID, model.Remark));
}
