public override int Update(BaseSearchModel model)
{
try
{
foreach (RWBarcodeModel item in RWBarcodeModels)
{
//修改条码信息
ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>();
item.Status = Status;
adoBarcode.Update(item);
//添加条码历史记录
ModelAdo<RWHistoryModel> adoBarcodeHistroy = new ModelAdo<RWHistoryModel>();
RWHistoryModel historyModel = new RWHistoryModel()
{
CreateTime = DateTime.Now,
BillID = "",
BarcodeID = item.ID,
Remark = Remark
};
adoBarcodeHistroy.Insert(historyModel);
}
}
catch (Exception)
{
return 0;
}
return 1;
}
/// <summary>
/// token 信息，获取token详细信息
/// </summary>
/// <param name="accessToken"></param>
/// <returns></returns>
public UserTokenModel getUserToken(string accessToken)
{
userTokenModel = new ModelAdo <Model.UserTokenModel>();
UserTokenModel model = userTokenModel.GetModel(" accessToken=?accessToken ", "", new MySqlParameter("?accessToken", accessToken));
return(model);
}
// POST api/values
public List<UserModel> Post()
{
List<UserModel> model = this.Request.Content.ReadAsAsync<List<UserModel>>().Result;
HttpRequestMessage rm = this.Request;
ModelAdo<UserModel> mUser = new ModelAdo<UserModel>();
return mUser.GetList("", "", "");
}
public override BaseSearchModel Insert()
{
using (TransactionScope ts = new TransactionScope())
{
//修改条码中对应装箱ID信息
ModelAdo<RWBarcodeModel> apiBarcode = new ModelAdo<RWBarcodeModel>();
//添加历史记录
ModelAdo<RWHistoryModel> adoBarcodeHistroy = new ModelAdo<RWHistoryModel>();
foreach (RWBarcodeModel item in RWBarcodeModels)
{
item.BoxID = packingModel.ID;
apiBarcode.Update(item);
//创建条码历史记录【Add】
RWHistoryModel historyModel = new RWHistoryModel()
{
CreateTime = DateTime.Now,
BillID = "",
BarcodeID = item.ID,
Remark = Remark
};
adoBarcodeHistroy.Insert(historyModel);
}
//修改barcode的条码状态
ModelAdo<PackingModel> apiPacking = new ModelAdo<PackingModel>();
packingModel.Status = 2;
apiPacking.Update(packingModel);
ts.Complete();
}
return this;
}
public override BaseSearchModel Insert()
{
if (ids == null || ids.Length == 0)
{
throw new Exception("请输入待重置的用户信息");
}
else
{
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<LoginHistoryModel> adoUser = new ModelAdo<LoginHistoryModel>();
StringBuilder sb = new StringBuilder();
foreach (string item in ids)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"update UR05 set UR05005 =0 where UR05002 in( [UIDS] )";
sql = sql.Replace("[UIDS]", sb.ToString());
adoUser.ExecuteSql(sql, null);
ts.Complete();
return this;
}
}
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
{
throw new Exception("请扫描或输入领料单对应的条码标签");
}
else if (string.IsNullOrEmpty(ReceiveId))
{
throw new Exception("请扫描或输入领料单的条码标签");
}
else
{
ModelAdo<ReceiveModel> adoReceive = new ModelAdo<ReceiveModel>();
ReceiveModel receiveModel = adoReceive.GetModel(ReceiveId);
if (receiveModel == null)
{
throw new Exception("领料单不存在");
}
else
{
}
}
return base.Insert();
}
public override BaseSearchModel Insert()
{
if (String.IsNullOrEmpty(BarcodeID))
throw new Exception("请扫描或输入待入库的条码标签");
else
{
using (TransactionScope ts = new TransactionScope())
{
string sql = @"INSERT INTO [RW12]([RW12002],[RW12003],[RW12004],[RW12005],[RW12006])
VALUES
(GETDATE() ,@UserID ,@UserName,@PlanID,@Barcode);";
ModelAdo<CheckModel> adoRW = new ModelAdo<CheckModel>();
int count = adoRW.ExecuteSql(sql, new SqlParameter("@UserID", this.LoginUserID),
new SqlParameter("@UserName", this.LoginUserName),
new SqlParameter("@PlanID", ""),
new SqlParameter("@Barcode", this.BarcodeID));
if (count == 0)
{
throw new Exception("插入失败");
}
ts.Complete();
return this;
}
}
}
/// <summary>
/// token 信息，获取token详细信息
/// </summary>
/// <param name="accessToken"></param>
/// <returns></returns>
public UserTokenModel getUserToken(int uid)
{
userTokenModel = new ModelAdo <Model.UserTokenModel>();
UserTokenModel model = userTokenModel.GetModel(" uid=?uid ", "", new MySqlParameter("?uid", uid));
return(model);
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.page = Convert.ToInt32(context.Request["page"]);
requestBody.pageSize = Convert.ToInt32(context.Request["pageSize"]);
requestBody.oid = Convert.ToInt32(context.Request["oid"]);
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
ModelAdo <OrderSupplierModel> orderModel = new ModelAdo <OrderSupplierModel>();
List <OrderSupplierModel> models = null;
int pagenumber = requestBody.page == 0 ? 1 : requestBody.page;
int totalCount = 1;
orderModel.PageSize = requestBody.pageSize == 0 ? orderModel.PageSize : requestBody.pageSize;
if (requestBody.oid == 0)
{
models = orderModel.GetList(pagenumber, " cuid=?cuid ", "", out totalCount, "",
new MySqlParameter("?cuid", userTokenModel.uid)
);
}
else
{
models = orderModel.GetList(pagenumber, " cuid=?cuid AND oid=?oid", "", out totalCount, "",
new MySqlParameter("?cuid", Convert.ToInt32(userTokenModel.uid)),
new MySqlParameter("?oid", requestBody.oid)
);
}
if (models.Count >= 1)
{
responseBody = new ResponseBody
{
page = 1,
pageTotal = (totalCount + orderModel.PageSize - 1) / orderModel.PageSize,
total = totalCount,
suppliers = models
};
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.userName = context.Request["userName"];
requestBody.userPwd = context.Request["userPwd"];
requestBody.userType = context.Request["userType"];
requestBody.bpuserid = context.Request["bpuserid"];
requestBody.channelid = context.Request["channelid"];
requestBody.deviceToken = context.Request["deviceToken"];
requestBody.deviceType = context.Request["deviceType"];
if (requestBody.userType == null || requestBody.userName == null || requestBody.userPwd == null)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
string password = StringHelper.StringToMD5(requestBody.userPwd);
ModelAdo <UserModel> userModel = new ModelAdo <UserModel>();
UserModel model = userModel.GetModel(" rid=?rid and name =?name and password=?password", "",
new MySqlParameter("?rid", requestBody.userType),
new MySqlParameter("?name", requestBody.userName),
new MySqlParameter("?password", password));
if (model == null)
{
SystemResponse.Output(SystemResponse.TYPE_LOGIN_ERROR, out statusCode, out responseJson);
}
else
{
DateTime dt = DateTime.Now;
string accessToken = StringHelper.StringToMD5(dt.ToString());
TokenHelper token = new TokenHelper();
UserTokenModel modelUserToken = new UserTokenModel();
modelUserToken.uid = model.id.ToString();
modelUserToken.rid = model.rid;
modelUserToken.accessToken = accessToken;
modelUserToken.bpuserId = requestBody.bpuserid;
modelUserToken.channelId = requestBody.channelid;
modelUserToken.deviceToken = requestBody.deviceToken;
modelUserToken.deviceType = Convert.ToInt32(requestBody.deviceType);
modelUserToken.loginTime = StringHelper.ConvertDateTimeInt(DateTime.Now);
modelUserToken.isLogin = 1;
token.updateToken(modelUserToken);
responseBody = new ResponseBody
{
accessToken = accessToken,
uid = model.id.ToString(),
userName = model.name,
nickName = model.nickname,
userAvatar = model.avatar,
userType = model.rid
};
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
}
}
public override BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
throw new Exception("请扫描或输入待销毁的条码标签");
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
StringBuilder sb = new StringBuilder();
foreach (string item in Barcodes)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"
declare @RC int
declare @result nvarchar(200)
declare @dj varchar(30)
set @RC=0
set @result=N'YES'
if @result='YES'
begin
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02011)
select RW01001,getdate(),@userid,@username,@Remark from RW01 where RW01001 IN ([BIDS])
update RW01 set RW01024=@userid,RW01025=@username,RW01032=5 where RW01001 IN ([BIDS])
end
select @result MSG
";
sql = sql.Replace("[BIDS]", sb.ToString());
DataSet ds = adoRW.GetDataSet(sql, new SqlParameter("@Remark", this.Remark), new SqlParameter("@userid", this.LoginUserID), new SqlParameter("@username", this.LoginUserName));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string msg = ds.Tables[0].Rows[0][0] + "";
if (msg != "YES")
throw new Exception(msg);
else if (this.isExportFile)
{
this.ExportXML(sb.ToString());
}
}
ts.Complete();
return this;
}
}
public override BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
throw new Exception("请扫描或输入待入库的条码标签");
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<FGBarcodeModel> adoRW = new ModelAdo<FGBarcodeModel>();
StringBuilder sb = new StringBuilder();
foreach (string item in Barcodes)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"
declare @RC int
declare @result nvarchar(200)
declare @dj varchar(30)
set @RC=0
set @result=N'YES'
if @result='YES'
begin
exec PROC_GETID 'FG03',@dj output
insert into FG02(FG02002,FG02003,FG02004,FG02005,FG02010,FG02011)
select FG01001,getdate(),@userid,@username,@dj,N'装箱到'+@PackingID from FG01 where FG01001 IN ([BIDS])
update FG01 set FG01024=@userid,FG01025=@username,FG01031=@PackingID where FG01001 IN ([BIDS])
update FG07 set FG07008=@Status where FG07001 =@PackingID
end
select @result MSG
";
sql = sql.Replace("[BIDS]", sb.ToString());
DataSet ds = adoRW.GetDataSet(sql, new SqlParameter("@PackingID", this.PackingID), new SqlParameter("@userid", this.LoginUserID), new SqlParameter("@username", this.LoginUserName), new SqlParameter("@Status", this.Status));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string msg = ds.Tables[0].Rows[0][0] + "";
if (msg != "YES")
throw new Exception(msg);
}
ts.Complete();
return this;
}
}
/// <summary>
/// 通过录入数据，获取提示PO订单号码
/// </summary>
/// <returns></returns>
public override BaseSearchModel GetModelByID(string id)
{
ModelAdo<WOLineModel> modelAdo = new ModelAdo<WOLineModel>();
List<string> pos = new List<string>();
string strSql = "select top 10 T.MP64001 as WO from (select distinct(MP64001) from view_WO where charindex(@tips,MP64001)>0 ) T";
DataSet ds = modelAdo.GetDataSet(strSql, new SqlParameter("@tips", id));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string[] rs = new string[ds.Tables[0].Rows.Count];
for (int i = 0; i < rs.Length; i++)
{
rs[i] = ds.Tables[0].Rows[i][0] + "";
}
this.WOS = rs;
}
return this;
}
/// <summary>
/// 通过录入数据，获取提示PO订单号码
/// </summary>
/// <returns></returns>
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
ModelAdo<POLineModel> modelAdo = new ModelAdo<POLineModel>();
List<string> pos = new List<string>();
string strSql = "select top 10 T.PC01001 as PO from (select distinct(PC01001) from view_poline where Company=@company and charindex(@tips,PC01001)>0) T";
DataSet ds = modelAdo.GetDataSet(strSql, new SqlParameter("@company", company), new SqlParameter("@tips", tips));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string[] rs = new string[ds.Tables[0].Rows.Count];
for (int i = 0; i < rs.Length; i++)
{
rs[i] = ds.Tables[0].Rows[i][0] + "";
}
this.POS = rs;
}
return this;
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
ModelAdo <UserModel> userModel = new ModelAdo <UserModel>();
List <UserModel> models = userModel.GetList(" id NOT IN (?id) AND status != 1", "", "",
new MySqlParameter("?id", userTokenModel.uid));
if (models != null)
{
List <Friend> Friends = new List <Friend>();
foreach (UserModel model in models)
{
Friend friend = new Friend();
friend.id = model.id;
friend.name = model.name;
friend.avatar = model.avatar;
Friends.Add(friend);
}
responseBody = new ResponseBody();
responseBody.Friends = Friends;
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
}
/// <summary>
/// token 信息，修改token详细信息
/// </summary>
/// <param name="accessToken"></param>
/// <returns></returns>
public int updateToken(UserTokenModel model)
{
int obj = 0;
userTokenModel = new ModelAdo <Model.UserTokenModel>();
UserTokenModel token = userTokenModel.GetModel(" uid =?uid ", "", new MySqlParameter("?uid", model.uid));
if (token != null)
{
model.id = token.id;
obj = userTokenModel.Update(model);
}
else
{
obj = userTokenModel.Insert(model);
}
return(obj);
}
public override BaseSearchModel Insert()
{
ModelAdo<UserModel> adoUser = new ModelAdo<UserModel>();
userModel = adoUser.GetModel("UR01003=@loginName and UR01004=@pass", "", new SqlParameter("@loginName", this.LoginName), new SqlParameter("@pass", this.Password));
if (userModel != null)
{
ModelAdo<LoginHistoryModel> adoLH = new ModelAdo<LoginHistoryModel>();
loginHistoryModel = adoLH.GetModel("UR05002=@id and UR05005=1", "*", new SqlParameter("@id", userModel.ID));
if (loginHistoryModel != null)
{
this.ErrorMsg = string.Format("用户{0}已在其他{1}终端登录，请先退出", userModel.UserName, loginHistoryModel.LoginType);
this.LoginSuccess = false;
}
else
{
string id = Guid.NewGuid().ToString();
loginHistoryModel = new LoginHistoryModel()
{
ID = id,
LoginTime = DateTime.Now,
LogoutTime = DateTime.Now,
ComputerName = this.ComputerName,
IP = this.IP,
LoginStatus = 1,
LoginType = this.LoginType,
UserID = userModel.ID
};
int result = adoLH.Insert(loginHistoryModel);
if (result == 1)
{
this.Token = id;
this.UserID = userModel.ID;
this.LoginSuccess = true;
}
}
}
else
{
this.LoginSuccess = false;
this.ErrorMsg = "用户名或密码不正确";
}
return this;
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.userName = context.Request["userName"];
requestBody.userPwd = context.Request["userPwd"];
requestBody.userType = context.Request["userType"];
if (requestBody.userName == null || requestBody.userPwd == null || requestBody.userType == null)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
string password = StringHelper.StringToMD5(requestBody.userPwd);
ModelAdo <UserModel> userModel = new ModelAdo <UserModel>();
UserModel model = userModel.GetModel(" rid=?rid and name =?name", "",
new MySqlParameter("?rid", requestBody.userType),
new MySqlParameter("?name", requestBody.userName));
if (model != null)
{
SystemResponse.Output(SystemResponse.TYPE_EXIST, out statusCode, out responseJson);
}
else
{
UserModel token = new UserModel();
token.rid = Convert.ToInt32(requestBody.userType);
token.name = requestBody.userName;
token.password = password;
token.ctime = StringHelper.ConvertDateTimeInt(DateTime.Now);
if (userModel.Insert(token) >= 1)
{
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_REGISTER_ERROR, out statusCode, out responseJson);
}
}
}
}
/// <summary>
/// 依据扫描条码，是否能够进行
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public override BaseSearchModel GetModelByID(string id)
{
if (RecevieID == null || RecevieID.Length == 0)
{
throw new Exception("请扫描或输入领料单的条码标签");
}
else {
ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
RWBarcodeModel RWModel = adoRW.GetModelByID(Barcode, "*");
if (RWModel == null)
{
throw new Exception("领料条码标签不存在");
}
else
{
//依据扫描原材料条码，获取对应的数据
}
}
return base.GetModelByID(id);
}
public void ProcessRequest(HttpContext context)
{
int status = 0;
ModelAdo <OrderTypeModel> orderTypeModel = new ModelAdo <OrderTypeModel>();
List <OrderTypeModel> list = orderTypeModel.GetList("status = ?status", " sort desc", "", new MySqlParameter("?status", status));
if (list.Count == 0)
{
status = 0;
msg = "未能找到数据集合！";
goto returnJson;
}
else
{
output = from model in list
select new
{
id = model.id,
pid = model.pid,
name = model.name,
remark = model.remark,
};
}
returnJson:
Dictionary <string, object> returnJson = new Dictionary <string, object>
{
{ "status", status },
{ "msg", msg },
{ "output", output }
};
string json = JsonConvert.SerializeObject(returnJson, Formatting.Indented);
context.Response.ContentType = "application/json";
context.Response.Write(json);
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.oid = context.Request["oid"];
requestBody.action = Convert.ToInt32(context.Request["action"]);
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid.Length == 0 || requestBody.action == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
#region 客服取消供应商抢单数据、修改订单状态回派单中
if (requestBody.action == 2)
{
//获取当前订单信息
ModelAdo <OrderModel> modelAdo = new ModelAdo <OrderModel>();
OrderModel order = modelAdo.GetModel("id=?oid AND ostatus=?ostatus", "",
new MySqlParameter("?oid", requestBody.oid),
new MySqlParameter("?ostatus", 3));
if (order != null)
{
//获取派单供应商对应订单中间表数据
ModelAdo <OrderUserModel> ouModelAdo = new ModelAdo <OrderUserModel>();
OrderUserModel orderUser = ouModelAdo.GetModel("oid=?oid AND uid=?uid", "",
new MySqlParameter("?oid", requestBody.oid),
new MySqlParameter("?uid", order.sendUid));
orderUser.amount = 0;
orderUser.remark = "被供应商退回抢单数据";
orderUser.createTime = 0;
orderUser.status = 1;
if (ouModelAdo.Update(orderUser) >= 1)
{
order.ostatus = 2;
order.sendUid = 0;
order.sendTime = 0;
order.sendRemark = "被供应商退回抢单数据";
order.sendAmount = 0;
if (modelAdo.Update(order) >= 1)
{
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
#endregion
#region 客服确认供应商抢单数据
else if (requestBody.action == 4)
{
//获取当前订单信息
ModelAdo <OrderModel> modelAdo = new ModelAdo <OrderModel>();
OrderModel order = modelAdo.GetModel("id=?oid AND ostatus=?ostatus", "",
new MySqlParameter("?oid", requestBody.oid),
new MySqlParameter("?ostatus", 3));
order.ostatus = 4;
order.sendRemark = "客服确认供应商抢单数据";
if (order != null)
{
if (modelAdo.Update(order) >= 1)
{
//删除派单供应商对应订单中间表数据
ModelAdo <OrderUserModel> ouModelAdo = new ModelAdo <OrderUserModel>();
int delCount = ouModelAdo.ExecuteSql("DELETE FROM ct_order_user WHERE oid=?oid",
new MySqlParameter("?oid", requestBody.oid));
if (delCount >= 1)
{
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
#endregion
#region 客服确认关闭已确认数据
else if (requestBody.action == 5)
{
//获取当前订单信息
ModelAdo <OrderModel> closeModelAdo = new ModelAdo <OrderModel>();
OrderModel closeOrder = closeModelAdo.GetModel("id=?oid AND ostatus=?ostatus", "",
new MySqlParameter("?oid", requestBody.oid),
new MySqlParameter("?ostatus", 4));
closeOrder.ostatus = 5;
closeOrder.sendRemark = "客服确认完成订单数据";
if (closeOrder != null)
{
if (closeModelAdo.Update(closeOrder) >= 1)
{
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
//删除派单供应商对应订单中间表数据
ModelAdo <OrderUserModel> ouModelAdo = new ModelAdo <OrderUserModel>();
int delCount = ouModelAdo.ExecuteSql("DELETE FROM ct_order_user WHERE oid=?oid",
new MySqlParameter("?oid", requestBody.oid));
//if (delCount >= 1)
//{
//}
//else
//{
//}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
#endregion
#region 其他
else
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
#endregion
}
}
}
public override BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
throw new Exception("请扫描或输入待入库的条码标签");
ModelAdo<LocationModel> adoLoc = new ModelAdo<LocationModel>();
List<LocationModel> lm = adoLoc.GetList("SC36001=@wh and SC36002=@bin", "", "", new SqlParameter("@wh", this.Warehouse), new SqlParameter("@bin", this.Bin));
if (lm.Count == 0)
throw new Exception("仓库或库位不存在");
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<FGBarcodeModel> adoRW = new ModelAdo<FGBarcodeModel>();
StringBuilder sb = new StringBuilder();
foreach (string item in Barcodes)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"
declare @RC int
declare @result nvarchar(200)
declare @dj varchar(30)
set @RC=0
set @result=N'YES'
select @RC=count(FG01001) from FG01 where FG01001 IN ([BIDS]) and FG01032>1
if @RC>0
begin
set @result=N'不能对已入库的料进行入库操作'
end
set @RC=0
select @RC=count(distinct(FG01033)) from FG01 where FG01001 IN ([BIDS])
if @RC>1
begin
set @result=N'请对同一工单号进行入库操作'
end
if @result='YES'
begin
exec PROC_GETID 'FG03',@dj output
insert into FG03(FG03001,FG03002,FG03003,FG03004,FG03005,FG03006,FG03007,FG03008)
values(@dj,getdate(),@userid,@username,'','','',@Remark)
insert into FG02(FG02002,FG02003,FG02004,FG02005,FG02010,FG02011)
select FG01001,getdate(),@userid,@username,@dj,N'入库到'+@whstr from FG01 where FG01001 IN ([BIDS])
insert into FG04(FG04002,FG04003,FG04004,FG04005)
select getdate(),@dj,FG01001,N'入库到'+@whstr from FG01 where FG01001 IN ([BIDS])
update FG01 set FG01008=@wh,FG01009=@sh,FG01010=getdate(),FG01024=@userid,FG01025=@username,FG01027=@dj,FG01032=2 where FG01001 IN ([BIDS])
end
select @result MSG
";
sql = sql.Replace("[BIDS]", sb.ToString());
DataSet ds = adoRW.GetDataSet(sql, new SqlParameter("@Remark", this.Remark), new SqlParameter("@userid", this.LoginUserID), new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@wh", this.Warehouse), new SqlParameter("@sh", this.Bin), new SqlParameter("@whstr", this.Warehouse + "[" + this.Bin + "]"));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string msg = ds.Tables[0].Rows[0][0] + "";
if (msg != "YES")
throw new Exception(msg);
else
{
this.ExportXML(sb.ToString());
}
}
ts.Complete();
return this;
}
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.uTo = Convert.ToInt32(context.Request["to"]);
requestBody.content = context.Request["content"];
if (requestBody.content.Length == 0 || requestBody.accessToken.Trim().Length == 0 || requestBody.uTo == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel fromModel = token.getUserToken(requestBody.accessToken);
UserTokenModel toModel = token.getUserToken(requestBody.uTo);
if (fromModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
int msgstatus = 0;
#region 入库至本地
ModelAdo <MsgModel> modelAdo = new ModelAdo <MsgModel>();
MsgModel msg = new MsgModel();
msg.ufrom = Convert.ToInt32(fromModel.uid);
msg.uto = requestBody.uTo;
msg.content = requestBody.content;
msg.createTime = StringHelper.ConvertDateTimeInt(DateTime.Now);
msg.status = msgstatus;
if (modelAdo.Insert(msg) >= 1)
{
#region 百度推送
if (toModel != null && toModel.bpuserId.Length >= 1 && toModel.channelId.Length >= 1)
{
//获取插入本地数据
MsgModel msgPush = modelAdo.GetModel("ufrom=?ufrom AND uto=?uto AND createTime=?createTime AND status=0", "",
new MySqlParameter("?ufrom", msg.ufrom),
new MySqlParameter("?uto", msg.uto),
new MySqlParameter("?createTime", msg.createTime));
if (msgPush != null)
{
try
{
//百度配置信息
string secretKey = ConfigurationManager.AppSettings["baidu_secret_key"];
string apiKey = ConfigurationManager.AppSettings["baidu_api_key"];
uint depolyStatus = uint.Parse(ConfigurationManager.AppSettings["baidu_depoly_status"]);
String messages = "";
TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0));
uint unixTime = (uint)ts.TotalSeconds;
string messageksy = "api";
uint message_type = 1;
BaiduPush Bpush = new BaiduPush("POST", secretKey);
if (toModel.deviceType == 1)
{
message_type = 1;
toModel.deviceType = 4;
IOSNotification notifaction = new IOSNotification();
notifaction.id = msgPush.id;
notifaction.ufrom = msgPush.ufrom;
notifaction.uto = msgPush.uto;
notifaction.content = msgPush.content.Trim();
notifaction.createTime = string.Format("{0:yyyy/MM/dd HH:mm:ss}", System.DateTime.Now);
notifaction.type = msgPush.type;
notifaction.status = 1;
IOSAPS aps = new IOSAPS()
{
alert = "收到一条新消息",
};
notifaction.aps = aps;
messages = notifaction.getJsonString();
}
else
{
message_type = 0;
toModel.deviceType = 3;
BaiduPushNotification notifaction = new BaiduPushNotification();
notifaction.title = "";
//构建custom_content信息
BaiduDescription bdMsg = new BaiduDescription();
bdMsg.id = msgPush.id;
bdMsg.ufrom = msgPush.ufrom;
bdMsg.uto = msgPush.uto;
bdMsg.content = msgPush.content;
bdMsg.createTime = string.Format("{0:yyyy/MM/dd HH:mm:ss}", System.DateTime.Now);
bdMsg.type = msgPush.type;
bdMsg.status = 1;
notifaction.description = "收到一条新消息";
notifaction.custom_content = bdMsg;
messages = notifaction.getJsonString();
}
PushOptions pOpts = new PushOptions("push_msg", apiKey, toModel.bpuserId.ToString(),
toModel.channelId.ToString(), Convert.ToUInt32(toModel.deviceType), messages, messageksy, unixTime);
pOpts.message_type = message_type;
pOpts.deploy_status = depolyStatus;
pOpts.push_type = 1;
string response = Bpush.PushMessage(pOpts);
responseJson = response;
msgstatus = 1;
//处理数据为已读
if (msg.status == 0)
{
msgPush.status = 1;
modelAdo.Update(msgPush);
}
//SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
//responseJson = strBDMsg;
}
catch (Exception ex)
{
responseJson = ex.ToString();
SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
}
}
#endregion
}
else
{
SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
}
#endregion
}
}
}
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
lock (objLock)
{
using (TransactionScope ts = new TransactionScope())
{
BaseAdo ba = new BaseAdo();
BaseAdo bascala = new BaseAdo() { ConnectionStr = SysConfig.DBScalaConnection };
string sqlpo = @"
select * from view_poline where PC01001=@po and SC01003=@stockspec and Company=@company
select * from view_Stock where SC01003=@stockspec and Company=@company
";
string sql = @"
insert into RW13(RW13002,RW13003,RW13004,RW13005,RW13006,RW13007,RW13008,RW13009,RW13010,RW13011,RW13012,RW13013,RW13014,RW13015,RW13016,RW13017,RW13018,RW13019,RW13020,RW13021,RW13022)
values(getdate(),@IMPNO,@userid,@po,@poline,@stockcode,@stockname,@stockspec,@lpn,@supplierbatch,@productdate,@exdate,@qty,@unit,@company,@boxid,@supcode,@supname,@pounit,@saleunit,@stocktype)";
string strImport = System.Text.Encoding.ASCII.GetString(this.Bytes);
string[] strImportLine = strImport.Replace("\r", " ").Split('\n');
IMPNO = Guid.NewGuid().ToString();
for (int i = 1; i < strImportLine.Length; i++)
{
string BarcodeId = "";//导入文件中获取
string PackageId = "";//导入文件中获取
string StockCode = "";
string StockName = "";
string StockSpec = "";//导入文件中获取
string StockUnit = "";//导入文件中获取
string PO = "";//导入文件中获取
decimal StockUnitQty = 0;//导入文件中获取
string Company = "";//导入文件中获取
string SupplierBatch = "";//导入文件中获取
string supplierCode = "";
string supplierName = "";
double purunit = 1;
double saleunit = 1;
string stockType = "02";
string poline = "";
DateTime ProductionTime = DateTime.Now;//导入文件中获取
DateTime ValidityTime = DateTime.Now;//导入文件中获取
string[] strImprotLineItem = strImportLine[i].Split(';');
switch (strImprotLineItem[0])
{
case "11117": Company = "31"; break;
case "11116": Company = "32"; break;
default: Company = "-"; break;
}
PO = strImprotLineItem[2];
StockSpec = strImprotLineItem[3];
PackageId = strImprotLineItem[5];
BarcodeId = strImprotLineItem[6];
SupplierBatch = strImprotLineItem[7];
StockUnitQty = decimal.Parse(strImprotLineItem[10]);
DateTime.TryParse(strImprotLineItem[15], out ProductionTime);
DateTime.TryParse(strImprotLineItem[16], out ValidityTime);
DataSet ds = bascala.GetDataSet(sqlpo, new SqlParameter("@Company", Company), new SqlParameter("@stockspec", StockSpec), new SqlParameter("@po", PO));
if (ds.Tables[0].Rows.Count > 0)
{
poline = ds.Tables[0].Rows[0]["PC03002"] + "";
supplierCode = ds.Tables[0].Rows[0]["PL01001"] + "";
supplierName = ds.Tables[0].Rows[0]["PL01002"] + "";
}
if (ds.Tables[1].Rows.Count > 0)
{
double.TryParse(ds.Tables[1].Rows[0]["SC01072"] + "", out purunit);
double.TryParse(ds.Tables[1].Rows[0]["SC01073"] + "", out saleunit);
stockType = ds.Tables[1].Rows[0]["SC01035"] + "";
StockCode = ds.Tables[1].Rows[0]["SC01001"] + "";
StockName = ds.Tables[1].Rows[0]["SC01002"] + "";
StockUnit = ds.Tables[1].Rows[0]["UNIT"] + "";
}
ba.ExecuteSql(sql, new SqlParameter("@IMPNO", IMPNO),
new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@po", PO),
new SqlParameter("@poline", poline),
new SqlParameter("@stockcode", StockCode),
new SqlParameter("@stockname", StockName),
new SqlParameter("@stockspec", StockSpec),
new SqlParameter("@lpn", BarcodeId),
new SqlParameter("@supplierbatch", SupplierBatch),
new SqlParameter("@productdate", ProductionTime),
new SqlParameter("@exdate", ValidityTime),
new SqlParameter("@qty", StockUnitQty),
new SqlParameter("@unit", StockUnit),
new SqlParameter("@company", Company),
new SqlParameter("@boxid", PackageId),
new SqlParameter("@supcode", supplierCode),
new SqlParameter("@supname", supplierName),
new SqlParameter("@pounit", purunit),
new SqlParameter("@saleunit", saleunit),
new SqlParameter("@stocktype", stockType));
}
ModelAdo<USBarcodeModel> adoUB = new ModelAdo<USBarcodeModel>();
this.ReturnUSBarcodes = adoUB.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ModelAdo<USBarcodeGroup> adoUBG = new ModelAdo<USBarcodeGroup>();
this.ReturnUSBarcodeGroups = adoUBG.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ts.Complete();
}
}
return this;
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
//①：解析获取的文件数据，依据每行来读取。
//②：替换对应公司，17-31,16-32[[不存在回滚]]
//③：替换PART_CODE，通过SC01003，找到对应的StockName，StockCode[不存在回滚]
//④：条码编号：[存在回滚]
//⑤：是否存在装箱号条码。有：判断装箱条码中是否存在，如果存在：直接并入该装箱号条码。如果不存在：新建
//⑥：插入原材料： 1：插入，父单据号表；
// 2：插入，子单据号明细表；
// 3：插入，原材料条码表；
// 4：插入，条码历史记录表；
lock (objLock)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
BaseAdo ba = new BaseAdo();
string sql = @"
declare @billid varchar(30)
exec PROC_GETID 'RW03',@billid output
--单据头
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@billid,getdate(),@userid,@username,'','','',N'创建条码')
select @billid t";
DataSet dsBillId = ba.GetDataSet(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName));
string BillId = ""; //总单据号
if (dsBillId != null && dsBillId.Tables[0].Rows.Count > 0)
{
BillId = dsBillId.Tables[0].Rows[0][0] + "";
}
string strImport = System.Text.Encoding.ASCII.GetString(this.Bytes);
string[] strImportLine = strImport.Replace("\r", " ").Split('\n');
for (int i = 1; i < strImportLine.Length; i++)
{
string BarcodeId = "";//导入文件中获取
string PackageId = "";//导入文件中获取
string StockCode = "";
string StockName = "";
string StockSpec = "";//导入文件中获取
string StockUnit = "";//导入文件中获取
string PO = "";//导入文件中获取
decimal StockUnitQty = 0;//导入文件中获取
string Company = "";//导入文件中获取
string SupplierBatch = "";//导入文件中获取
DateTime ProductionTime = DateTime.Now;//导入文件中获取
DateTime ValidityTime = DateTime.Now;//导入文件中获取
string[] strImprotLineItem = strImportLine[i].Split(';');
if (strImprotLineItem[0].Contains("17"))
{
Company = "31";
}
else if (strImprotLineItem[0].Contains("16"))
{
Company = "32";
}
else
{
throw new Exception("未找到相对应的公司信息！");
}
PO = strImprotLineItem[2];
StockSpec = strImprotLineItem[3];
PackageId = strImprotLineItem[5];
BarcodeId = strImprotLineItem[6];
SupplierBatch = strImprotLineItem[7];
StockUnitQty = decimal.Parse(strImprotLineItem[10]);
DateTime.TryParse(strImprotLineItem[15], out ProductionTime);
DateTime.TryParse(strImprotLineItem[16], out ValidityTime);
ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>();
RWBarcodeModel rwModel = adoBarcode.GetModelByID(BarcodeId);
if (rwModel != null && rwModel.ID.Length >= 1)
{
throw new Exception(BarcodeId + "已存在于条码系统中！");
}
if (!string.IsNullOrEmpty(PackageId))
{
ModelAdo<PackingModel> adoPackage = new ModelAdo<PackingModel>();
PackingModel packageModel = adoPackage.GetModelByID(PackageId);
if (packageModel != null)
{
}
else
{
string sqlPackage = @"
--装箱单
insert into RW07(RW07001,RW07002,RW07003,RW07004,RW07005,RW07006,RW07007,RW07008)
values(@packageid,getdate(),@userid,@username,0,'',0,2)";
ba.ExecuteSql(sqlPackage, new SqlParameter("packageid", PackageId),
new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName));
}
}
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
List<StockModel> Stocks = adoStock.GetList("SC01003=@stockspec", "", "", new SqlParameter("@stockspec", StockSpec));
if (Stocks != null && Stocks.Count >= 1)
{
StockCode = Stocks[0].StockCode;
StockName = Stocks[0].StockName;
StockUnit = Stocks[0].Unit;
StockUnitQty = Stocks[0].UQTY;
}
else
{
//throw new Exception("未找到相对应的物料信息！");
continue;
}
string barcodeSql = @"
--单据明细
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@billid,@barcodeid,N'创建条码')
--历史记录
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@barcodeid,getdate(),@userid,@username,@billid,N'创建条码标签')
--原材料
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01014,RW01024,RW01025,RW01027,RW01031,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01043)
values(@barcodeid,@stock,@stockname,@stockspec,@unit,@qty,@po,@userid,@username,@billid,@packageid,1,@company,@supplierbatch,@productiontime ,@validitytime,@tqty,@stype,'PO')
";
ba.ExecuteSql(barcodeSql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", StockCode),
new SqlParameter("@stockname", StockName),
new SqlParameter("@barcodeid", BarcodeId),
new SqlParameter("@stockspec", StockSpec),
new SqlParameter("@packageid", PackageId),
new SqlParameter("@unit", StockUnit),
new SqlParameter("@qty", StockUnitQty),
new SqlParameter("@tqty", Stocks[0].UQTY),
new SqlParameter("@po", PO),
new SqlParameter("@stype", Stocks[0].StockType),
new SqlParameter("@company", Company),
new SqlParameter("@supplierbatch", SupplierBatch),
new SqlParameter("@productiontime", ProductionTime),
new SqlParameter("@validitytime", ValidityTime),
new SqlParameter("@billid", BillId));
}
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
}
return this;
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
string sql = @"
declare @bid varchar(30)
declare @hid int
declare @i int
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'RW01',@bid output
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01033,RW01018,RW01024,RW01025,RW01027,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01042,RW01043)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,@wo,@remark,@userid,@username,@dj,1,@company,@Batch,@ProductionTime ,@ValidityTime,@tqty,@type,@pagecode,'WO')
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
";
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
StockModel sm = adoStock.GetModelByID(this.StockCode);
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", this.StockName),
new SqlParameter("@stockspec", this.StockSpec),
new SqlParameter("@unit", this.Unit),
new SqlParameter("@qty", this.UnitQty),
new SqlParameter("@tqty", sm.StockType == "02" ? 1 : sm.UQTY),
new SqlParameter("@type", sm.StockType),
new SqlParameter("@wo", this.WorkOrder),
new SqlParameter("@remark", this.Remark),
new SqlParameter("@company", this.Company),
new SqlParameter("@printcount", this.BarcodeQty),
new SqlParameter("@Batch", this.Batch),
new SqlParameter("@ProductionTime", this.ProductDate),
new SqlParameter("@ValidityTime", this.LifeDate),
new SqlParameter("@pagecode", this.PageCode),
new SqlParameter("@dj", this.Danju));
return this;
/*
string sql = @"
declare @dj varchar(30)
exec PROC_GETID 'FG03',@dj output
declare @bid varchar(30)
declare @hid int
declare @i int
insert into FG03(FG03001,FG03002,FG03003,FG03004,FG03005,FG03006,FG03007,FG03008)
values(@dj,getdate(),@userid,@username,'','','',N'创建条码')
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'FG01',@bid output
insert into FG02(FG02002,FG02003,FG02004,FG02005,FG02010,FG02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into FG01(FG01001,FG01002,FG01003,FG01004,FG01005,FG01006,FG01012,FG01013,FG01014,FG01015,FG01018,FG01024,FG01025,FG01027,FG01032,FG01037,FG01033,FG01034,FG01035,FG01036,FG01038)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,'','','','',@remark,@userid,@username,@dj,1,@company,@workorder,@productdate,@lifedate,@pagecode,@lifeday)
insert into FG04(FG04002,FG04003,FG04004,FG04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
";
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@workorder", this.WorkOrder),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", this.StockName),
new SqlParameter("@stockspec", this.StockSpec),
new SqlParameter("@unit", this.Unit),
new SqlParameter("@qty", this.UnitQty),
new SqlParameter("@remark", this.Remark),
new SqlParameter("@company", this.Company),
new SqlParameter("@printcount", this.BarcodeQty),
new SqlParameter("@productdate", this.ProductDate.ToString("yyyy-MM-dd")),
new SqlParameter("@lifedate", this.ProductDate.AddDays(this.LifeDate).ToString("yyyy-MM-dd")),
new SqlParameter("@lifeday", this.LifeDate),
new SqlParameter("@pagecode", this.PageCode));
return this;
* */
}
public override List<BaseSearchModel> GetALL(bool enableSearch = false)
{
ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>();
List<SqlParameter> listParam = new List<SqlParameter>();
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" 1=1 ");
if (!BeginTimeInWH.Equals(DateTime.MinValue) && !EndTimeInWH.Equals(DateTime.MinValue))
{
sbWhere.Append(" AND RW01010 BETWEEN @BeginTimeInWH AND @EndTimeInWH ");
listParam.Add(new SqlParameter("@BeginTimeInWH", BeginTimeInWH));
listParam.Add(new SqlParameter("@EndTimeInWH", EndTimeInWH));
}
if (!BeginTimeOutWH.Equals(DateTime.MinValue) && !EndTimeOutWH.Equals(DateTime.MinValue))
{
sbWhere.Append(" AND RW01011 BETWEEN @BeginTimeOutWH AND @EndTimeOutWH ");
listParam.Add(new SqlParameter("@BeginTimeOutWH", BeginTimeOutWH));
listParam.Add(new SqlParameter("@EndTimeOutWH", EndTimeOutWH));
}
if (!String.IsNullOrEmpty(this.ID))
{
sbWhere.Append(" AND RW01001 = @ID");
listParam.Add(new SqlParameter("@ID", ID));
}
if (!String.IsNullOrEmpty(this.StockCode))
{
sbWhere.Append(" AND RW01002 = @StockCode");
listParam.Add(new SqlParameter("@StockCode", StockCode));
}
if (!String.IsNullOrEmpty(this.StockName))
{
sbWhere.Append(" AND RW01003 = @StockName");
listParam.Add(new SqlParameter("@StockName", StockName));
}
if (!String.IsNullOrEmpty(this.BoxID))
{
sbWhere.Append(" AND RW01031 = @BoxID ");
listParam.Add(new SqlParameter("@BoxID", this.BoxID));
}
if (!String.IsNullOrEmpty(this.SupplierBatch))
{
sbWhere.Append(" AND RW01035 = @SupplierBatch ");
listParam.Add(new SqlParameter("@SupplierBatch", this.SupplierBatch));
}
if (!String.IsNullOrEmpty(this.BatchID))
{
sbWhere.Append(" AND RW01036 = @BatchID ");
listParam.Add(new SqlParameter("@BatchID", this.BatchID));
}
if (!String.IsNullOrEmpty(this.PO))
{
sbWhere.Append(" AND RW01014 = @PO ");
listParam.Add(new SqlParameter("@PO", this.PO));
}
if (Status >= 1)
{
sbWhere.Append(" AND RW01032 = @Status ");
listParam.Add(new SqlParameter("@Status", this.Status));
}
List<BaseSearchModel> models = null;
if (this.doPager)
{
int count = 0;
adoBarcode.PageSize = this.PageSize;
models = adoBarcode.GetList(this.PageIndex, sbWhere.ToString(), SearchOrderBy, out count, "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
base.totalCount = count;
}
else
{
models = adoBarcode.GetList(sbWhere.ToString(), SearchOrderBy, "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
}
return models;
}
public override BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
throw new Exception("请扫描或输入待入库的条码标签");
ModelAdo<LocationModel> adoLoc = new ModelAdo<LocationModel>();
List<LocationModel> lm = adoLoc.GetList("SC36001=@wh and SC36002=@bin", "", "", new SqlParameter("@wh", this.Warehouse), new SqlParameter("@bin", this.Bin));
if (lm.Count == 0)
throw new Exception("仓库或库位不存在");
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
StringBuilder sb = new StringBuilder();
foreach (string item in Barcodes)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"
declare @RC int
declare @result nvarchar(200)
declare @dj varchar(30)
set @RC=0
set @result=N'YES'
select @RC=count(RW01001) from RW01 where RW01001 IN ([BIDS]) and RW01032>1
if @RC>0
begin
set @result=N'已入库的料不可再入库'
end
set @RC=0
select @RC=count(distinct(RW01014)) from RW01 where RW01001 IN ([BIDS])
if @RC>1
begin
set @result=N'多张采购单请分批收货'
end
set @RC=0
select @RC=count(distinct(RW01043)) from RW01 where RW01001 IN ([BIDS])
if @RC>1
begin
set @result=N'PO收货、WO收货以及STOCK RECEIVE请分开操作'
end
if @result='YES'
begin
exec PROC_GETID 'RW03',@dj output
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@dj,getdate(),@userid,@username,'','','',@Remark)
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
select RW01001,getdate(),@userid,@username,@dj,N'入库到'+@whstr from RW01 where RW01001 IN ([BIDS])
insert into RW04(RW04002,RW04003,RW04004,RW04005)
select getdate(),@dj,RW01001,N'入库到'+@whstr from RW01 where RW01001 IN ([BIDS])
update RW01 set RW01008=@wh,RW01009=@sh,RW01010=getdate(),RW01024=@userid,RW01025=@username,RW01027=@dj,RW01032=2 where RW01001 IN ([BIDS])
UPDATE WK01 SET WK01006=getdate() where WK01006 is null and WK01004<= (select sum(RW01006) FROM RW01 WHERE RW01032=2 and RW01033=WK01001 and RW01002=WK01002 GROUP BY RW01033,RW01002)
end
select @result MSG
";
sql = sql.Replace("[BIDS]", sb.ToString());
DataSet ds = adoRW.GetDataSet(sql, new SqlParameter("@Remark", this.Remark), new SqlParameter("@userid", this.LoginUserID), new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@wh", this.Warehouse), new SqlParameter("@sh", this.Bin), new SqlParameter("@whstr", this.Warehouse + "[" + this.Bin + "]"));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string msg = ds.Tables[0].Rows[0][0] + "";
if (msg != "YES")
throw new Exception(msg);
else
{
this.ExportXMLPO(sb.ToString());
}
}
ts.Complete();
return this;
}
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.oid = Convert.ToInt32(context.Request["oid"]);
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
ModelAdo <OrderModel> orderModel = new ModelAdo <OrderModel>();
OrderModel model = orderModel.GetModel("id=?id", "",
new MySqlParameter("?id", requestBody.oid)
);
if (model != null)
{
responseBody = new ResponseBody();
responseBody.uid = model.uid;
responseBody.title = model.title;
responseBody.subtitle = model.subtitle;
responseBody.createDate = string.Format("{0:d}", StringHelper.GetNomalTime(model.createDate));
responseBody.status = model.ostatus;
responseBody.no = model.no;
responseBody.price = model.amount.ToString("f2");
responseBody.contact = model.contact;
responseBody.contactAddress = model.contactAdress;
responseBody.contactOPhone = model.contactOPhone;
responseBody.contactPhone = model.contactPhone;
responseBody.payment = model.payment;
responseBody.type = model.otid;
responseBody.remark = model.remark;
Ext from = new Ext();
from.uid = model.uid;
from.city = model.address1;
from.date = string.Format("{0:d}", StringHelper.GetNomalTime(model.time1));
responseBody.from = from;
Ext to = new Ext();
to.uid = model.uid;
to.city = model.address2;
to.date = string.Format("{0:d}", StringHelper.GetNomalTime(model.time2));
responseBody.to = to;
if (model.ostatus == 3)
{
Send send = new Send();
send.date = string.Format("{0:d}", StringHelper.GetNomalTime(model.sendTime));
send.suid = model.sendUid;
send.price = model.sendAmount.ToString("f2");
send.remark = model.sendRemark;
responseBody.send = send;
}
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
}
public override List<BaseSearchModel> GetALL(bool enableSearch = false)
{
ModelAdo<RWInvoiceModel> ado = new ModelAdo<RWInvoiceModel>();
List<SqlParameter> listParam = new List<SqlParameter>();
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" 1=1 ");
if (!BeginInvoiceTime.Equals(DateTime.MinValue) && !EndInvoiceTime.Equals(DateTime.MinValue))
{
sbWhere.Append(" AND RW18002 BETWEEN @BeginInvoiceTime AND @EndInvoiceTime ");
listParam.Add(new SqlParameter("@BeginInvoiceTime", BeginInvoiceTime));
listParam.Add(new SqlParameter("@EndInvoiceTime", EndInvoiceTime));
}
if (!String.IsNullOrEmpty(this.ID))
{
sbWhere.Append(" AND RW18001 = @ID");
listParam.Add(new SqlParameter("@ID", ID));
}
if (Status >= 1)
{
sbWhere.Append(" AND RW18005 = @Status ");
listParam.Add(new SqlParameter("@Status", this.Status));
}
List<BaseSearchModel> models = null;
if (this.doPager)
{
int count = 0;
ado.PageSize = this.PageSize;
models = ado.GetList(this.PageIndex, sbWhere.ToString(), " RW18001 DESC ", out count, "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
base.totalCount = count;
}
else
{
models = ado.GetList(sbWhere.ToString(), " RW18001 DESC ", "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
}
return models;
}
public void ProcessRequest(HttpContext context)
{
if (context.Request["oid"] == null)
{
status = 0;
msg = "订单编号参数不能为空！";
goto returnJson;
}
string pageSize = context.Request["pageSize"];
string oid = context.Request["oid"];
ModelAdo <SupplierOrderModel> supplierSendModel = new ModelAdo <SupplierOrderModel>();
if (pageSize != null)
{
supplierSendModel.PageSize = int.Parse(pageSize);
}
int RecordCount = supplierSendModel.GetRecordCount(" userType=0 ");
List <SupplierOrderModel> list = supplierSendModel.GetList(" userType=0 AND (oid=?oid or status is NULL) ", "", "", new MySqlParameter("?oid", oid));
//List<SupplierOrderModel> list = supplierSendModel.GetList("select * from tv_view_supplier_order where userType=0 AND (oid=1 or status is NULL) ");
if (list.Count == 0)
{
status = 0;
msg = "未能找到数据集合！";
goto returnJson;
}
else
{
pageData = new
{
recordCount = RecordCount,
pageSize = supplierSendModel.PageSize
};
Data = from model in list
select new
{
uid = model.uid,
status = model.status,
oid = model.oid
};
output = new
{
pageData = pageData,
Data = Data
};
}
returnJson:
Dictionary <string, object> returnJson = new Dictionary <string, object>
{
{ "status", status },
{ "msg", msg },
{ "output", output }
};
string json = JsonConvert.SerializeObject(returnJson, Formatting.Indented);
context.Response.ContentType = "application/json";
context.Response.Write(json);
}
public override List<BaseSearchModel> GetALL(bool enableSearch = false)
{
ModelAdo<FGBillModel> adoBill = new ModelAdo<FGBillModel>();
List<SqlParameter> listParam = new List<SqlParameter>();
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" 1=1 ");
if (!BeginTime.Equals(DateTime.MinValue) && !EndTime.Equals(DateTime.MinValue))
{
sbWhere.Append(" AND FG03002 BETWEEN @BeginTime AND @EndTime ");
listParam.Add(new SqlParameter("@BeginTime", BeginTime));
listParam.Add(new SqlParameter("@EndTime", EndTime));
}
if (!string.IsNullOrEmpty(this.ID))
{
sbWhere.Append(" AND FG03001 = @ID");
listParam.Add(new SqlParameter("@ID", ID));
}
if (!string.IsNullOrEmpty(this.UserName))
{
sbWhere.Append(" AND FG03004=@UserName");
listParam.Add(new SqlParameter("@UserName", UserName));
}
if (!string.IsNullOrEmpty(this.Remark))
{
sbWhere.Append(" AND FG03008=@Remark");
listParam.Add(new SqlParameter("@Remark", Remark));
}
return adoBill.GetList(sbWhere.ToString(), " FG03002 DESC ", "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
throw new Exception("请扫描或输入待入库的条码标签");
ModelAdo<LocationModel> adoLoc = new ModelAdo<LocationModel>();
List<LocationModel> lm = adoLoc.GetList("SC36001=@wh and SC36002=@bin", "", "", new SqlParameter("@wh", this.Warehouse), new SqlParameter("@bin", this.Bin));
if (lm.Count == 0)
throw new Exception("仓库或库位不存在");
//①：修改原材料领料单RW08状态 ：RW08008 int 状态(1已申请 2部分发货 3关闭)
//②：修改原材料领料单ITEMRW09已领和剩余数量
//③：插入RW10 原材料领料单BARCODE 中间表
//④：修改条码信息表：
//⑤：插入RW03原材料单据表
//⑥：插入RW04原材料单据明细表
//⑦：插入RW02 原材料历史记录
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
List<SqlParameter> parameters = new List<SqlParameter>();
StringBuilder sb = new StringBuilder();
foreach (string item in Barcodes)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"
declare @RC int
declare @result nvarchar(200)
declare @dj varchar(30)
set @RC=0
set @result=N'YES'
select @RC=count(RW01001) from RW01 where RW01001 IN ([BIDS]) and RW01032 <> 2
if @RC>0
begin
set @result=N'存在不能做领料操作的信息，不能进行领料操作'
end
if @result='YES'
begin
declare @calcstatus int
Update RW09 set RW09005=@userid,RW09006=@username,RW09011=@ReceivedCount, RW09012=@ReceiveSurplusCount where RW09001=@ReceiveLine
set @calcstatus=2
select @calcstatus=SUM(RW09012) from RW09 where RW09003=@ReceiveID
if @calcstatus>0
begin
set @ReceiveStatus=2
end
else
begin
set @ReceiveStatus=3
end
Update RW08 set RW08008=@ReceiveStatus where RW08001=@ReceiveID
insert into RW10(RW10002,RW10003,RW10004,RW10005,RW10006,RW10007)
select getdate(),@userid,@username,@ReceiveID,@ReceiveLine,RW01001 from RW01 where RW01001 IN ([BIDS])
exec PROC_GETID 'RW03',@dj output
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@dj,getdate(),@userid,@username,'','',@ReceiveID,@Remark)
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
select RW01001,getdate(),@userid,@username,@dj,N'领料单['+ @ReceiveID +'];移库到'+@whstr from RW01 where RW01001 IN ([BIDS])
insert into RW04(RW04002,RW04003,RW04004,RW04005)
select getdate(),@dj,RW01001,N'领料单['+ @ReceiveID +']; 移库到'+@whstr from RW01 where RW01001 IN ([BIDS])
update RW01 set RW01016 =RW01008 ,RW01017 = RW01009,RW01008=@wh,RW01009=@sh,RW01024=@userid,RW01025=@username,RW01027=@dj,RW01032=3 where RW01001 IN ([BIDS])
end
select @result MSG
";
parameters.Add(new SqlParameter("@userid", this.LoginUserID));
parameters.Add(new SqlParameter("@username", this.LoginUserName));
parameters.Add(new SqlParameter("@Remark", this.Remark));
parameters.Add(new SqlParameter("@ReceiveID", this.ReceiveID));
parameters.Add(new SqlParameter("@ReceiveStatus", this.ReceiveStatus));
parameters.Add(new SqlParameter("@ReceiveLine", this.ReceiveLine));
parameters.Add(new SqlParameter("@ReceivedCount", this.ReceivedCount));
parameters.Add(new SqlParameter("@ReceiveSurplusCount", this.ReceiveSurplusCount));
parameters.Add(new SqlParameter("@wh", this.Warehouse));
parameters.Add(new SqlParameter("@sh", this.Bin));
parameters.Add(new SqlParameter("@whstr", this.Warehouse + "[" + this.Bin + "]"));
sql = sql.Replace("[BIDS]", sb.ToString());
DataSet ds = adoRW.GetDataSet(sql, parameters.ToArray());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string msg = ds.Tables[0].Rows[0][0] + "";
if (msg != "YES")
throw new Exception(msg);
else
{
this.ExportXML(sb.ToString());
}
}
ts.Complete();
return this;
}
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
if (Barcodes == null || Barcodes.Length == 0)
throw new Exception("请扫描或输入待入库的条码标签");
//①：修改成品发货单单FG08状态 ：FG08008 int 状态(1已申请 2部分发货 3关闭)
//②：修改成品发货单单ITEMFG09已领和剩余数量
//③：插入FG10 成品发货单单BARCODE 中间表
//④：修改条码信息表：
//⑤：插入FG03成品单据表
//⑥：插入FG04成品单据明细表
//⑦：插入FG02 成品历史记录
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<FGBarcodeModel> adoFG = new ModelAdo<FGBarcodeModel>();
List<SqlParameter> parameters = new List<SqlParameter>();
StringBuilder sb = new StringBuilder();
foreach (string item in Barcodes)
{
sb.Append(",'" + item + "'");
}
sb.Remove(0, 1);
string sql = @"
declare @RC int
declare @lineno varchar(10)
declare @result nvarchar(200)
declare @dj varchar(30)
set @RC=0
set @result=N'YES'
select @RC=count(FG01001) from FG01 where FG01001 IN ([BIDS]) and FG01032 <> 2
if @RC>0
begin
set @result=N'存在不能做发货操作的信息，不能进行发货操作'
end
if @result='YES'
begin
Update FG09 set FG09005=@userid,FG09006=@username,FG09011=@InvoicedCount, FG09012=@InvoiceSurplusCount where FG09001=@InvoiceLine
select @lineno=FG09002 from FG09 where FG09001=@InvoiceLine
declare @calcstatus int
set @calcstatus=2
select @calcstatus=SUM(FG09012) from FG09 where FG09003=@InvoiceID
if @calcstatus>0
begin
set @InvoiceStatus=2
end
else
begin
set @InvoiceStatus=3
end
Update FG08 set FG08008=@InvoiceStatus where FG08001=@InvoiceID
insert into FG10(FG10002,FG10003,FG10004,FG10005,FG10006,FG10007)
select getdate(),@userid,@username,@InvoiceID,@InvoiceLine,FG01001 from FG01 where FG01001 IN ([BIDS])
exec PROC_GETID 'FG03',@dj output
insert into FG03(FG03001,FG03002,FG03003,FG03004,FG03005,FG03006,FG03007,FG03008)
values(@dj,getdate(),@userid,@username,'','',@InvoiceID,@Remark)
insert into FG02(FG02002,FG02003,FG02004,FG02005,FG02010,FG02011)
select FG01001,getdate(),@userid,@username,@dj,N'发货单['+ @InvoiceID +']' from FG01 where FG01001 IN ([BIDS])
insert into FG04(FG04002,FG04003,FG04004,FG04005)
select getdate(),@dj,FG01001,N'发货单['+ @InvoiceID +']' from FG01 where FG01001 IN ([BIDS])
update FG01 set FG01016 =FG01008 ,FG01017 = FG01009,FG01024=@userid,FG01025=@username,FG01027=@dj,FG01032=3,FG01030=@InvoiceID,FG01039=@lineno where FG01001 IN ([BIDS])
end
select @result MSG
";
parameters.Add(new SqlParameter("@userid", this.LoginUserID));
parameters.Add(new SqlParameter("@username", this.LoginUserName));
parameters.Add(new SqlParameter("@Remark", this.Remark));
parameters.Add(new SqlParameter("@InvoiceID", this.InvoiceID));
parameters.Add(new SqlParameter("@InvoiceStatus", this.InvoiceStatus));
parameters.Add(new SqlParameter("@InvoiceLine", this.InvoiceLine));
parameters.Add(new SqlParameter("@InvoicedCount", this.InvoicedCount));
parameters.Add(new SqlParameter("@InvoiceSurplusCount", this.InvoiceSurplusCount));
sql = sql.Replace("[BIDS]", sb.ToString());
DataSet ds = adoFG.GetDataSet(sql, parameters.ToArray());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string msg = ds.Tables[0].Rows[0][0] + "";
if (msg != "YES")
throw new Exception(msg);
else
{
this.ExportXML(sb.ToString());
}
}
ts.Complete();
return this;
}
}
public override List<BaseSearchModel> GetALL(bool enableSearch = false)
{
ModelAdo<RWHistoryModel> adoRW = new ModelAdo<RWHistoryModel>();
List<SqlParameter> listParam = new List<SqlParameter>();
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" 1=1 ");
if (!string.IsNullOrEmpty(this.BarcodeID))
{
sbWhere.Append(" AND RW02002 = @BarcodeID");
listParam.Add(new SqlParameter("@BarcodeID", this.BarcodeID));
}
return adoRW.GetList(sbWhere.ToString(), " RW02001 DESC ", "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.page = Convert.ToInt32(context.Request["page"]);
requestBody.pageSize = Convert.ToInt32(context.Request["pageSize"]);
requestBody.status = Convert.ToInt32(context.Request["status"]);
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
ModelAdo <OrderModel> orderModel = new ModelAdo <OrderModel>();
List <OrderModel> models = null;
int pagenumber = requestBody.page == 0 ? 1 : requestBody.page;
int totalCount = 1;
orderModel.PageSize = requestBody.pageSize == 0 ? orderModel.PageSize : requestBody.pageSize;
if (requestBody.status == 0)
{
models = orderModel.GetList(pagenumber, " uid=?uid ", "", out totalCount, "",
new MySqlParameter("?uid", userTokenModel.uid)
);
}
else
{
models = orderModel.GetList(pagenumber, " uid=?uid AND ostatus=?ostatus", "", out totalCount, "",
new MySqlParameter("?uid", Convert.ToInt32(userTokenModel.uid)),
new MySqlParameter("?ostatus", requestBody.status)
);
}
if (models.Count >= 1)
{
//构建返回对象
List <Order> orders = new List <Order>();
foreach (OrderModel model in models)
{
Order order = new Order();
order.uid = model.uid.ToString();
order.title = model.title;
order.createDate = string.Format("{0:d}", StringHelper.GetNomalTime(model.createDate));
order.status = model.ostatus;
order.price = model.amount.ToString("f2");
order.oid = model.id.ToString();
order.type = model.otid;
Ext from = new Ext();
from.uid = model.uid.ToString();
from.city = model.address1;
from.date = string.Format("{0:d}", StringHelper.GetNomalTime(model.time1));
order.from = from;
Ext to = new Ext();
to.uid = model.uid.ToString();
to.city = model.address2;
to.date = string.Format("{0:d}", StringHelper.GetNomalTime(model.time2));
order.to = to;
orders.Add(order);
}
responseBody = new ResponseBody
{
page = 1,
pageTotal = (totalCount + orderModel.PageSize - 1) / orderModel.PageSize,
total = totalCount,
orders = orders
};
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.withId = Convert.ToInt32(context.Request["withId"]);
requestBody.page = Convert.ToInt32(context.Request["page"]);
requestBody.pageSize = Convert.ToInt32(context.Request["pageSize"]);
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.withId == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
//获取消息列表
ModelAdo <MsgModel> modelAdo = new ModelAdo <MsgModel>();
int pagenumber = requestBody.page == 0 ? 1 : requestBody.page;
int totalCount = 1;
modelAdo.PageSize = requestBody.pageSize == 0 ? modelAdo.PageSize : requestBody.pageSize;
List <MsgModel> models = models = modelAdo.GetList(pagenumber,
"(ufrom=?ufrom AND uto=?uto) or (uto=?ufrom AND ufrom=?uto)", "createTime DESC ", out totalCount, "",
new MySqlParameter("?ufrom", userTokenModel.uid),
new MySqlParameter("?uto", requestBody.withId)
);
if (models.Count >= 1)
{
//构建返回对象
List <Msg> msgs = new List <Msg>();
models.Sort(new idComparer());
foreach (MsgModel model in models)
{
Msg msg = new Msg();
msg.id = model.id;
msg.content = model.content;
msg.createTime = string.Format("{0:yyyy/MM/dd HH:mm:ss}", StringHelper.GetNomalTime(model.createTime));
msg.ufrom = model.ufrom;
msg.uto = model.uto;
msg.type = model.type;
msg.status = model.status;
msgs.Add(msg);
//处理数据为已读
if (msg.status == 0)
{
model.status = 1;
modelAdo.Update(model);
}
}
responseBody = new ResponseBody
{
page = 1,
pageTotal = (totalCount + modelAdo.PageSize - 1) / modelAdo.PageSize,
total = totalCount,
msgs = msgs
};
responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
}
public override BaseSearchModel Insert()
{
ModelAdo<WOModel> adoWO = new ModelAdo<WOModel>();
WOModel modelWO = adoWO.GetModel("MP64001=@wo", "", new SqlParameter("@wo", this.Workorder));
if (modelWO != null)
{
ModelAdo<ReportModel> adoReport = new ModelAdo<ReportModel>();
List<ReportModel> list = adoReport.GetList("WK02002=@wo", "WK02001", "", new SqlParameter("@wo", this.Workorder));
if (list.Count == 0)
{
ModelAdo<WOWK01Model> adoWK01 = new ModelAdo<WOWK01Model>();
WOWK01Model wk01 = new WOWK01Model()
{
WorkOrder=modelWO.WorkOrder,
StockCode=modelWO.StockCode,
StockName=modelWO.StockName,
QTY=modelWO.PlanQTY,
Status=1,
TotalHour=0
};
adoWK01.Insert(wk01);
ModelAdo<WOLineNoGroupModel> adoWOLine = new ModelAdo<WOLineNoGroupModel>();
List<WOLineNoGroupModel> wolineList = adoWOLine.GetList("MP65001=@wo", "MP65003", "", new SqlParameter("@wo", this.Workorder));
int i = 0;
string op = "";
foreach (WOLineNoGroupModel item in wolineList)
{
if (op != item.OperationNO)
i = 0;
i++;
ReportModel modelReport = new ReportModel()
{
BOMOP = item.OperationNO,
BOMOPINDEX = i + "",
DeQTY = item.PlanQTY,
HadDe = 0,
HadDeQTY = 0,
StockCode = item.StockCode,
StockName = item.StockName,
Workorder = item.WO,
LineNumber = item.Number,
ReportNumber = item.ReportNumber,
DeDate = System.DateTime.Now,
Warehouse=item.Warehouse
};
adoReport.Insert(modelReport);
}
}
// if (!string.IsNullOrEmpty(this.RWID))
// {
// ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
// RWBarcodeModel rwModel = adoRW.GetModelByID(this.RWID);
// if (rwModel != null)
// {
// if (this.DeQTY > (float)rwModel.StockUnitQty)
// throw new Exception("汇报数量超出条码数量");
// string sql = @"
//update RW01 set RW01006=RW01006-@deqty where RW01001=@bid
//
//insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
//select RW01001,getdate(),@userid,@username,@dj,N'扣料 工单号'+@wo+' 数量'+convert(varchar(10),@deqty) from RW01 where RW01001=@bid
//
//update WK02 set WK02002=
//";
// }
// else
// throw new Exception("无效原材料条码");
// }
list = adoReport.GetList("WK02002=@wo", "WK02001", "", new SqlParameter("@wo", this.Workorder));
this.ReturnReportList = list;
return this;
}
else
throw new Exception("无效工单,请重新确认工单");
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.oid = context.Request["oid"];
requestBody.action = Convert.ToInt32(context.Request["action"]);
requestBody.amount = Convert.ToDecimal(context.Request["money"]);
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid.Length == 0 || requestBody.action == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else if (requestBody.action == 2 && requestBody.amount == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
ModelAdo <OrderUserModel> modelAdo = new ModelAdo <OrderUserModel>();
//核对有没有供应商已抢单
OrderUserModel sendOrder = modelAdo.GetModel(" oid =?oid AND status=2", "",
new MySqlParameter("?oid", requestBody.oid));
//核对供应商与订单状态
OrderUserModel model = modelAdo.GetModel("oid=?oid AND uid=?uid", "",
new MySqlParameter("?oid", requestBody.oid),
new MySqlParameter("?uid", userTokenModel.uid));
//数据是否存在派单中间表
if (model != null)
{
#region 供应商确认抢单【派单中间表已存在，并且订单状态为2，派单中】
if (2 == requestBody.action && sendOrder == null)
{
model.status = 2;
model.amount = requestBody.amount;
model.createTime = StringHelper.ConvertDateTimeInt(DateTime.Now);
model.remark = "被供应商抢单的订单";
//修改订单状态为3，并录入相关抢单数据
ModelAdo <OrderModel> orderModelAdo = new ModelAdo <OrderModel>();
OrderModel orderModel = orderModelAdo.GetModel("id=?id", "",
new MySqlParameter("?id", requestBody.oid)
);
if (orderModel != null)
{
orderModel.ostatus = 3;
orderModel.sendUid = Convert.ToInt32(userTokenModel.uid);
orderModel.sendTime = model.createTime;
orderModel.sendRemark = "供应商抢单并输入价格 【待处理订单】";
orderModel.sendAmount = model.amount;
if (orderModelAdo.Update(orderModel) >= 1)
{
if (modelAdo.Update(model) >= 1)
{
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
}
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
}
}
#endregion
#region 用户退回订单 【派单中间表已存在，并且订单状态为3，待处理订单】
else if (3 == requestBody.action && sendOrder != null && sendOrder.uid == Convert.ToInt32(userTokenModel.uid))
{
//修改订单状态为2，并清除相关抢单数据
ModelAdo <OrderModel> orderModelAdo = new ModelAdo <OrderModel>();
OrderModel orderModel = orderModelAdo.GetModel("id=?id", "",
new MySqlParameter("?id", requestBody.oid)
);
if (orderModel != null)
{
orderModel.ostatus = 2;
orderModel.sendUid = 0;
orderModel.sendTime = 0;
orderModel.sendRemark = "供应商退回抢单【派单中】";
orderModel.sendAmount = 0;
if (orderModelAdo.Update(orderModel) >= 1)
{
model.status = 3;
model.remark = "被供应商退回的订单";
modelAdo.Update(model);
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NO_PERMISSON, out statusCode, out responseJson);
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
}
}
#endregion
#region 其他操作
else
{
SystemResponse.Output(SystemResponse.TYPE_NO_PERMISSON, out statusCode, out responseJson);
}
#endregion
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NO_PERMISSON, out statusCode, out responseJson);
}
}
}
}
public override BaseSearchModel Insert()
{
using (TransactionScope ts = new TransactionScope())
{
string sql = @"
declare @dj varchar(30)
exec PROC_GETID 'RW03',@dj output
--单据头
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@dj,getdate(),@userid,@username,'','','',N'US导入创建条码')
--装箱标签
insert into RW07(RW07001,RW07002,RW07003,RW07004,RW07005,RW07006,RW07007,RW07008)
select RW13017,getdate(),@userid,@username,0,'',0,2 from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13017,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01) group by RW13017
--单据明细
insert into RW04(RW04002,RW04003,RW04004,RW04005)
select getdate(),@dj,RW13010,N'US导入创建条码' from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01)
--历史记录
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
select RW13010,getdate(),@userid,@username,@dj,N'US导入创建条码' from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01)
--原材料
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01012,RW01013,RW01014,RW01015,RW01024,RW01025,RW01027,RW01031,RW01032,RW01034,RW01035,RW01037,RW01038,RW01041,RW01043,RW01044,RW01045)
select RW13010,RW13007,RW13008,RW13009,RW13015,RW13014,RW13018,RW13019,RW13005,RW13006,@userid,@username,@dj,RW13017,1,RW13016,RW13011,RW13012,RW13013,RW13022,'PO',RW13020,RW13021
from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01)
--删除成功的
delete from RW13 where RW13010 in (select RW01001 from RW01)
";
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID), new SqlParameter("@username", this.LoginUserName), new SqlParameter("@impno", IMPNO));
ModelAdo<USBarcodeModel> adoUB = new ModelAdo<USBarcodeModel>();
this.ReturnUSBarcodes = adoUB.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ModelAdo<USBarcodeGroup> adoUBG = new ModelAdo<USBarcodeGroup>();
this.ReturnUSBarcodeGroups = adoUBG.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ts.Complete();
return this;
}
}
/*
/// <summary>
/// 创建条码信息
/// 1：插入，父单据号表；
/// 2：插入，子单据号明细表；
/// 3：插入，原材料条码表；
/// 4：插入，条码历史记录表；
/// </summary>
/// <returns></returns>
public override BaseSearchModel Insert()
{
ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>();
ModelAdo<BillDetailModel> adoBillDetail = new ModelAdo<BillDetailModel>();
ModelAdo<RWHistoryModel> adoBarcodeHistroy = new ModelAdo<RWHistoryModel>();
List<RWBarcodeModel> listBarcode = new List<RWBarcodeModel>();
for (int i = 0; i < BarcodeQTY; i++)
{
RWBarcodeModel barcodeModel = new RWBarcodeModel()
{
Bill = billModel.ID,
CompanyCode = this.Company,
StockUnit = this.UNITPO,
StockCode = this.StockCode,
StockName = this.StockName,
StockSpec = this.StockSpec,
StockUnitQty = this.UNITQTY,
SupplierCode = this.SupplierCode,
SupplierName = this.SupplierName,
Warehouse = this.Warehouse,
SO = this.PO,
Status = 1,
POLine = this.LineNum,
WarehouseInTime = DateTime.Now,
WarehouseOutTime = DateTime.Now,
Remark1 = Remark
};
adoBarcode.Insert(barcodeModel);
listBarcode.Add(barcodeModel);
BillDetailModel billDetailModel = new BillDetailModel()
{
CreateTime = DateTime.Now,
BillID = billModel.ID,
BarcodeID = barcodeModel.ID,
Remark = billModel.Remark
};
adoBillDetail.Insert(billDetailModel);
RWHistoryModel historyModel = new RWHistoryModel()
{
CreateTime = DateTime.Now,
BillID = billModel.ID,
BarcodeID = barcodeModel.ID,
Remark = billModel.Remark
};
adoBarcodeHistroy.Insert(historyModel);
}
this.RWBarcodeModels = listBarcode.ToArray();
return this;
}
* */
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
string sql = @"
declare @bid varchar(30)
declare @hid int
declare @i int
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'RW01',@bid output
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01012,RW01013,RW01014,RW01015,RW01018,RW01024,RW01025,RW01027,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01043,RW01044,RW01045)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,@sup,@supname,@po,@poline,@remark,@userid,@username,@dj,1,@company,@SupplierBatch,@ProductionTime ,@ValidityTime,@tqty,@type,'PO',@unitpur,@unitsale)
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
";
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
StockModel sm = adoStock.GetModelByID(this.StockCode);
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", this.StockName),
new SqlParameter("@stockspec", this.StockSpec),
new SqlParameter("@unit", this.UNITWH),
new SqlParameter("@qty", this.UNITQTY),
new SqlParameter("@tqty", this.Type == "02" ? 1 : sm.UQTY),
new SqlParameter("@type", sm.StockType),
new SqlParameter("@po", this.PO),
new SqlParameter("@poline", this.LineNum),
new SqlParameter("@sup", this.SupplierCode),
new SqlParameter("@supname", this.SupplierName),
new SqlParameter("@remark", this.Remark),
new SqlParameter("@company", this.Company),
new SqlParameter("@SupplierBatch", this.SupplierBatch),
new SqlParameter("@printcount", this.BarcodeQTY),
new SqlParameter("@ProductionTime", this.ProductionTime),
new SqlParameter("@ValidityTime", this.ValidityTime),
new SqlParameter("@dj", this.Danju),
new SqlParameter("@unitpur", this.PODivisor),
new SqlParameter("@unitsale", this.SODivisor));
return this;
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
requestBody = new RequestBody();
requestBody.accessToken = context.Request["accessToken"];
requestBody.oid = context.Request["oid"];
requestBody.uid = context.Request["uid"];
if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid.Length == 0 || requestBody.uid.Length == 0)
{
SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
}
else
{
List <int> values = JsonConvert.DeserializeObject <List <int> >(requestBody.uid);
//验证用户
TokenHelper token = new TokenHelper();
UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
if (userTokenModel == null)
{
SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
}
else
{
//获取订单表数据
ModelAdo <OrderModel> modelAdoOrder = new ModelAdo <OrderModel>();
OrderModel orderModel = modelAdoOrder.GetModel("(id=?id AND ostatus=?ostatus) or (id=?id AND ostatus=?ostatus1) ", "",
new MySqlParameter("?id", requestBody.oid),
new MySqlParameter("?ostatus", 2),
new MySqlParameter("?ostatus1", 1));
if (orderModel != null)
{
ModelAdo <OrderUserModel> modelAdo = new ModelAdo <OrderUserModel>();
int existCount = modelAdo.GetRecordCount("oid=?oid",
new MySqlParameter("?oid", requestBody.oid));
if (existCount >= 1)
{
int delCount = modelAdo.ExecuteSql("DELETE FROM ct_order_user WHERE oid=?oid",
new MySqlParameter("?oid", requestBody.oid));
if (delCount >= 1)
{
StringBuilder sbValues = new StringBuilder();
sbValues.Append(" INSERT INTO ct_order_user(oid,uid,status,remark) VALUES ");
for (int i = 0; i < values.Count; i++)
{
sbValues.Append("(" + requestBody.oid + "," + values[i] + ",1,'派送中的订单'),");
}
sbValues.Remove(sbValues.Length - 1, 1).Append(";");
int inCount = modelAdo.ExecuteSql(sbValues.ToString());
if (inCount >= 1)
{
if (orderModel != null)
{
orderModel.ostatus = 2;
modelAdoOrder.Update(orderModel);
}
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
}
}
else
{
StringBuilder sbValues = new StringBuilder();
sbValues.Append(" INSERT INTO ct_order_user(oid,uid,status) VALUES ");
for (int i = 0; i < values.Count; i++)
{
sbValues.Append("(" + requestBody.oid + "," + values[i] + ",1),");
}
sbValues.Remove(sbValues.Length - 1, 1).Append(";");
int inCount = modelAdo.ExecuteSql(sbValues.ToString());
if (inCount >= 1)
{
SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
else
{
SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
}
}
}
}
public override BaseSearchModel Insert()
{
if (Count >= 1)
{
ModelAdo<PackingModel> modelAdo = new ModelAdo<PackingModel>();
string[] strs = new string[Count];
List<PackingModel> list = new List<PackingModel>();
for (int i = 0; i < Count; i++)
{
PackingModel pm = this.MemberwiseClone() as PackingModel;
pm.CreateTime = DateTime.Now;
pm.Status = 1;
strs[i] = pm.ID;
modelAdo.Insert(pm);
list.Add(pm);
}
this.PackingModels = list.ToArray() ;
this.ReturnID = strs;
}
return this;
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
using (TransactionScope ts = new TransactionScope())
{
ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
RWBarcodeModel barcode = adoRW.GetModelByID(this.RWID);
ModelAdo<ReportModel> adoRM = new ModelAdo<ReportModel>();
ReportModel rm = adoRM.GetModelByID(this.ReportLineID + "");
if (barcode.Warehouse != rm.Warehouse)
{
throw new Exception("此工单需汇报" + rm.Warehouse + "仓库的料");
}
string sql = @"
declare @lineno varchar(30)
declare @reportnumber varchar(30)
declare @stock varchar(40)
declare @stocktype varchar(40)
declare @barcodeQTY numeric(15,3)
select @wo=WK02002,@lineno=WK02012,@reportnumber=WK02013 from WK02 where WK02001=@rlid
select @stock=RW01002,@stocktype=RW01041,@barcodeQTY=RW01006 from RW01 where RW01001=@bid
if(@barcodeQTY=@deqty)
update RW01 set RW01032=3 where RW01001=@bid
else
update RW01 set RW01006=RW01006-@deqty where RW01001=@bid
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02011)
select RW01001,getdate(),@userid,@username,N'扣料 工单号'+@wo+' 数量'+convert(varchar(10),@deqty) from RW01 where RW01001=@bid
update WK02 set WK02008=case when WK02008 is null then getdate() else WK02008 end,WK02009=WK02009+@deqty,WK02010=@wc where WK02001=@rlid
update WK01 set WK01005=getdate() where WK01001=@wo and WK01005 is null and WK01006 is null
if not exists(select * from WK04 where WK04001=@wo and WK04002=@wc and WK04004 is null)
insert into WK04(WK04001,WK04002,WK04003)
values(@wo,@wc,getdate())
if not exists(select * from WK02 where WK02002=@wo and WK02009<WK02005)
update WK01 set WK01008=3 where WK01001=@wo
else
update WK01 set WK01008=2 where WK01001=@wo
insert into WK05(WK05002,WK05003,WK05004,WK05005,WK05006,WK05007,WK05008,WK05009,WK05010)
values(@wc,@wo,@bid,@stock,@deqty,@stocktype,getdate(),case @stocktype when '02' then 1 else 0 end,@rlid)
select @wo WO,@reportnumber RN,@lineno LN,RW01017,RW01008,RW01009,RW01002,RW01006/RW01040 RW01006,RW01007,RW01034,RW01035,RW01041 from RW01 where RW01001=@bid
";
BaseAdo ba = new BaseAdo();
DataSet ds = ba.GetDataSet(sql,
new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@wo", this.WorkOrder),
new SqlParameter("@bid", this.RWID),
new SqlParameter("@deqty", this.DeQTY),
new SqlParameter("@rlid", this.ReportLineID),
new SqlParameter("@wc", this.WorkCenter));
if (ds.Tables[0].Rows[0]["RW01041"] + "" != "04" && ds.Tables[0].Rows[0]["RW01041"] + "" != "00")
{
List<Hashtable> list = new List<Hashtable>();
Hashtable h = new Hashtable();
//h["Qty"] = ds.Tables[0].Rows[0]["RW01006"];
h["Qty"] = this.DeQTY;
h["StockCode"] = ds.Tables[0].Rows[0]["RW01002"];
h["ReportNumber"] = ds.Tables[0].Rows[0]["RN"];
h["LineNumber"] = ds.Tables[0].Rows[0]["LN"];
h["Bin"] = ds.Tables[0].Rows[0]["RW01009"];
h["Company"] = ds.Tables[0].Rows[0]["RW01034"];
h["SupplierBatch"] = ds.Tables[0].Rows[0]["RW01035"];
h["WorkOrder"] = ds.Tables[0].Rows[0]["WO"];
h["Warehouse"] = ds.Tables[0].Rows[0]["RW01008"];
list.Add(h);
StockTransactionXml.ExportWOReportXML(list);
}
ts.Complete();
return this;
}
}
public void ProcessRequest(HttpContext context)
{
if (context.Request["oid"] == null)
{
status = 0;
msg = "订单编号参数不能为空！";
goto returnJson;
}
if (context.Request["type"] == null)
{
status = 0;
msg = "派单类型参数不能为空！";
goto returnJson;
}
if (context.Request["stid"] == null)
{
status = 0;
msg = "供应商组编号参数不能为空！";
goto returnJson;
}
int oid = Int32.Parse(context.Request["oid"]);
int type = Int32.Parse(context.Request["type"]);
string stid = context.Request["stid"];
ModelAdo <OrderSTypeModel> orderSTypeModel = new ModelAdo <OrderSTypeModel>();
if (type == 1)
{
int RecordCount = orderSTypeModel.GetRecordCount(" oid = " + oid);
if (RecordCount >= 1)
{
//删除原有中间表数据
int tempSize = orderSTypeModel.ExecuteSql("DELETE FROM ct_order_stype WHERE oid = ?oid",
new MySqlParameter("?oid", oid));
if (tempSize == 0)
{
//删除成功，插入数据
}
else
{
//未能正确删除数据
status = 0;
msg = "数据处理失败集合！";
goto returnJson;
}
}
//直接插入数据
JArray jsonStid = JArray.Parse(stid);
if (jsonStid.Count == 0)
{
//供应商组不能为空
status = 0;
msg = "供应商组不能为空！";
goto returnJson;
}
string insertStr = "INSERT INTO ct_order_stype(oid,stid,status) VALUES";
foreach (int item in jsonStid)
{
insertStr += "(" + oid + "," + item + ",1),";
}
insertStr = insertStr.Substring(0, insertStr.Length - 1);
output = insertStr;
}
if (0 == 0)
{
status = 0;
msg = "未能找到数据集合！";
goto returnJson;
}
else
{
}
returnJson:
Dictionary <string, object> returnJson = new Dictionary <string, object>
{
{ "status", status },
{ "msg", msg },
{ "output", output }
};
string json = JsonConvert.SerializeObject(returnJson, Formatting.Indented);
context.Response.ContentType = "application/json";
context.Response.Write(json);
}
public override List<BaseSearchModel> GetALL(bool enableSearch = false)
{
ModelAdo<ReceiveDetailModel> adoRDetails = new ModelAdo<ReceiveDetailModel>();
List<SqlParameter> listParam = new List<SqlParameter>();
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" 1=1 ");
if (!string.IsNullOrEmpty(ReceiveID))
{
sbWhere.Append(" AND RW09003 = @ReceiveID ");
listParam.Add(new SqlParameter("@ReceiveID", this.ReceiveID));
}
List<BaseSearchModel> models = null;
if (this.doPager)
{
int count = 0;
adoRDetails.PageSize = this.PageSize;
models = adoRDetails.GetList(this.PageIndex, sbWhere.ToString(), " RW09001 DESC ", out count, "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
base.totalCount = count;
}
else
{
models = adoRDetails.GetList(sbWhere.ToString(), " RW09001 DESC ", "*", listParam.ToArray()).ConvertAll<BaseSearchModel>(m => m as BaseSearchModel);
}
return models;
}
public override BaseSearchModel Insert()
{
using (TransactionScope ts = new TransactionScope())
{
if (PrintCount == 0)
{
throw new Exception("打印数量不能为空！");
}
string sqlStr = @"
declare @bid varchar(30)
declare @hid int
declare @i int
declare @dj varchar(30)
exec PROC_GETID 'RW03',@dj output
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@dj,getdate(),@userid,@username,'','','',N'创建条码')
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'RW01',@bid output
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01012,RW01013,RW01014,RW01015,RW01018,RW01024,RW01025,RW01027,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01043)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,@sup,@supname,@po,@poline,@remark,@userid,@username,@dj,1,@company,@SupplierBatch,@ProductionTime ,@ValidityTime,@tqty,@type,'REC')
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
select top [COUNT] RW01001 from RW01 order by RW01001 desc
";
sqlStr = sqlStr.Replace("[COUNT]", this.PrintCount + "");
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
StockModel sm = adoStock.GetModelByID(this.StockCode);
BaseAdo ba = new BaseAdo();
DataSet ds = ba.GetDataSet(sqlStr, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", sm.StockName),
new SqlParameter("@stockspec", sm.StockSpec),
new SqlParameter("@unit", this.StockUnit),
new SqlParameter("@qty", this.StockUnitQty),
new SqlParameter("@tqty", sm.StockType == "02" ? 1 : sm.UQTY),
new SqlParameter("@po", this.PO),
new SqlParameter("@poline", this.POLine),
new SqlParameter("@sup", this.SupplierCode),
new SqlParameter("@supname", this.SupplierName),
new SqlParameter("@remark", this.Remark1),
new SqlParameter("@company", this.CompanyCode),
new SqlParameter("@SupplierBatch", this.SupplierBatch),
new SqlParameter("@printcount", this.PrintCount),
new SqlParameter("@type", sm.StockType),
new SqlParameter("@ProductionTime", this.ProductDate),
new SqlParameter("@ValidityTime", this.ExpirationDate)
);
//StringBuilder sb = new StringBuilder();
//foreach (DataRow item in ds.Tables[0].Rows)
//{
// sb.Append(",'" + item[0] + "'");
//}
//sb.Remove(0, 1);
//ExportXML(sb.ToString());
ts.Complete();
}
return this;
}
