//插入数据
public bool InsetMaterialDetail(List <TaskDetails_Model> tDtails, ref string msg)
{
//sql List
List <string> SQL_list = new List <string>();
if (tDtails.Count() > 0)
{
foreach (TaskDetails_Model tm in tDtails)
{
string sqlStr;
string materialNo = tm.MaterialNo;
string materialDESC = tm.MaterialDesc;
decimal materialNUM = tm.QuanlityQty;
sqlStr = "insert into T_TASKDETAILS(MATERIALNO,MATERIALDESC,TASKQTY,)" +
"values('" + materialNo + "','" + materialDESC + "'," + materialNUM + ")";
SQL_list.Add(sqlStr);
}
}
try
{
int result = OperationSql.ExecuteNonQueryList(SQL_list);
msg = "新增成功！";
return(true);
}
catch (Exception e)
{
msg = e.ToString();
return(false);
}
}
public static bool UpLoadSql(List <string> lstSql, UserInfo user, ref string strError)
{
if (lstSql == null || lstSql.Count <= 0)
{
strError = "上传数据不能为空";
return(false);
}
if (OperationSql.ExecuteNonQueryList(lstSql, ref strError) >= 1)
{
return(true);
}
else
{
if (string.IsNullOrEmpty(strError))
{
try
{
OperationSql.ExecuteNonQuery2(CommandType.Text, lstSql[0], null);
if (lstSql.Count >= 2)
{
OperationSql.ExecuteNonQuery2(CommandType.Text, lstSql[1], null);
}
}
catch (Exception ex)
{
strError = ex.Message;
}
}
return(false);
}
}
public bool UpdateFastIn(string ID, Task_Model head, string[] lst_delID, ref string strErrMsg)
{
//strErrMsg = string.Empty;
//sql List
string vouchertype = string.Empty;
if (head.IsShelvePost == 1)
{
vouchertype = "50";
}
else
{
vouchertype = "60";
}
List <string> SQL_list = new List <string>();
SQL_list.Add("update T_TASK set VOUCHERTYPE=" + vouchertype.ToString() + ",SUPCUSNAME=" + dbstr(head.SupCusName) + ",REMARK=" + dbstr(head.Remark) + ",REASON=" + dbstr(head.Reason) + ",SUPCUSNO=" + dbstr(head.SupCusNo) + ",ISSHELVEPOST=" + head.IsShelvePost
+ " where ID =" + ID + " ");
foreach (TaskDetails_Model tm in head.lstTaskDetails)
{
string sqlStr;
string materialNo = tm.MaterialNo;
string materialDESC = tm.MaterialDesc;
string tmaterialNo = tm.TMaterialNo;
string tmaterialDESC = tm.TMaterialDesc;
decimal materialNUM = tm.TaskQty;
if (tm.ID < 0)
{
sqlStr = "insert into T_TASKDETAILS(ID,TASK_ID,MATERIALNO,MATERIALDESC,TMATERIALNO,TMATERIALDESC,TASKQTY,REMAINQTY)" +
"values(seq_taskdetails.nextval," + ID + ",'" + materialNo + "','" + materialDESC + "','" + tmaterialNo + "','" + tmaterialDESC + "'," + materialNUM + "," + materialNUM + ")";
SQL_list.Add(sqlStr);
}
else
{
if (!strErrMsg.Equals("old"))
{
sqlStr = "update T_TASKDETAILS set MATERIALNO='" + materialNo + "',MATERIALDESC='" + materialDESC + "',TMATERIALNO='" + tmaterialNo + "',TMATERIALDESC='" + tmaterialDESC + "',TASKQTY=" + materialNUM + ",REMAINQTY=" + materialNUM
+ " where TASK_ID=" + ID + " and ID=" + tm.ID + " ";
SQL_list.Add(sqlStr);
}
}
}
foreach (string delID in lst_delID)
{
SQL_list.Add("delete T_TASKDETAILS where ID=" + delID + " ");
}
try
{
int result = OperationSql.ExecuteNonQueryList(SQL_list);
strErrMsg = "更新成功！";
return(true);
}
catch (Exception e)
{
strErrMsg = e.ToString();
return(false);
}
}
public bool SaveFastIn(Task_Model head, BLL.Basic.User.UserInfo userModel, ref string strErrMsg)
{
strErrMsg = string.Empty;
//获取TASK表ID
int NewTASKID = 0;
if (!GetNewTASKID(ref NewTASKID, ref strErrMsg))
{
strErrMsg = "获取TASK表ID失败:" + strErrMsg;
return(false);
}
//sql List
List <string> SQL_list = new List <string>();
if (head.IsShelvePost == 1)
{
SQL_list.Add("insert into T_TASK(ID,VOUCHERTYPE,TASKTYPE,TASKNO,SUPCUSNAME,SUPCUSNO,TASKSTATUS,CREATEDATETIME,REMARK,REASON,CREATEUSERNO,ISSHELVEPOST,ISQUALITY,RECEIVEUSERNO,taskissued,PostStatus)" +
"values(" + NewTASKID.ToString() + ",50,1,'" + head.TaskNo + "'," + dbstr(head.SupCusName) + "," + dbstr(head.SupCusNo) + ",2,sysdate," + dbstr(head.Remark) + "," + dbstr(head.Reason) + ",'" + head.CreateUserNo + "',1,1,'" + head.CreateUserNo + "',sysdate,4) ");
}
else
{
SQL_list.Add("insert into T_TASK(ID,VOUCHERTYPE,TASKTYPE,TASKNO,SUPCUSNAME,SUPCUSNO,TASKSTATUS,CREATEDATETIME,REMARK,REASON,CREATEUSERNO,ISSHELVEPOST,ISQUALITY,RECEIVEUSERNO,taskissued,PostStatus)" +
"values(" + NewTASKID.ToString() + ",60,1,'" + head.TaskNo + "'," + dbstr(head.SupCusName) + "," + dbstr(head.SupCusNo) + ",2,sysdate," + dbstr(head.Remark) + "," + dbstr(head.Reason) + ",'" + head.CreateUserNo + "',2,1,'" + head.CreateUserNo + "',sysdate,4) ");
}
foreach (TaskDetails_Model tm in head.lstTaskDetails)
{
string sqlStr;
string materialNo = tm.MaterialNo;
string materialDESC = tm.MaterialDesc;
string tmaterialNo = tm.TMaterialNo;
string tmaterialDESC = tm.TMaterialDesc;
decimal materialNUM = tm.TaskQty;
sqlStr = "insert into T_TASKDETAILS(ID,TASK_ID,VOUCHERNO,MATERIALNO,MATERIALDESC,TMATERIALNO,TMATERIALDESC,TASKQTY,REMAINQTY)" +
"values(seq_taskdetails.nextval," + NewTASKID.ToString() + ",'" + head.TaskNo + "','" + materialNo + "','" + materialDESC + "','" + tmaterialNo + "','" + tmaterialDESC + "'," + materialNUM + "," + materialNUM + ")";
SQL_list.Add(sqlStr);
}
foreach (BLL.Basic.Warehouse.WarehouseInfo wi in userModel.lstWarehouse)
{
SQL_list.Add("insert into T_TASKWAREHOUSE (ID,TASK_ID,WAREHOUSE_ID,USER_ID)values(seq_taskwarehouse.nextval," + NewTASKID.ToString() + "," + wi.ID + "," + userModel.ID + ") ");
}
try
{
int result = OperationSql.ExecuteNonQueryList(SQL_list);
strErrMsg = "新增成功！快速入库单号：" + head.TaskNo;
return(true);
}
catch (Exception e)
{
strErrMsg = e.ToString();
return(false);
}
}
public bool DeleteFastIn(string ID, BLL.Basic.User.UserInfo userModel, ref string strErrMsg)
{
strErrMsg = string.Empty;
//检查已上架数量是否大于零
try
{
string strSql = "select sum(SHELVEQTY) from T_TASKDETAILS where TASK_ID = " + ID + " group by TASK_ID having sum(SHELVEQTY) > 0 ";
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
if (dr[0] != null && dr[0] != DBNull.Value && Convert.ToDecimal(dr[0]) > 0)
{
strErrMsg = "已上架数量大于零";
return(false);
}
}
}
strSql = "select ISNULL(MATERIALDOC,'') from T_RECEIVEMATERIALDOC where TASK_ID = " + ID + " ";
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
if (dr[0] != null && dr[0] != DBNull.Value && dr[0].ToString() != "")
{
strErrMsg = "该单据已过账";
return(false);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
//检查是否有voucher表数据
string HEAD_ID = string.Empty;
try
{
string strSql = "select ID from T_TASKANDVOUCHERNO where TASK_ID = " + ID + " ";
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
HEAD_ID = dr[0].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
//sql List
List <string> SQL_list = new List <string>();
SQL_list.Add("delete T_TASK where ID = " + ID);
SQL_list.Add("delete T_TASKDETAILS where TASK_ID = " + ID);
if (!HEAD_ID.Equals(string.Empty))
{
SQL_list.Add("delete T_TASKANDVOUCHERNO where ID = " + HEAD_ID);
SQL_list.Add("delete T_TASKANDVOUCHERDETAILS where HEAD_ID = " + HEAD_ID);
}
foreach (BLL.Basic.Warehouse.WarehouseInfo wi in userModel.lstWarehouse)
{
SQL_list.Add("delete T_TASKWAREHOUSE where TASK_ID = " + ID + " ");
}
try
{
int result = OperationSql.ExecuteNonQueryList(SQL_list);
strErrMsg = "删除成功！";
return(true);
}
catch (Exception e)
{
strErrMsg = e.ToString();
return(false);
}
return(true);
}
public bool UpdatePostFastIn(string ID, Task_Model head, TaskVoucher tv, string[] lst_delID, ref string strErrMsg)
{
//strErrMsg = string.Empty;
int NewVouchID = 0;
if (!GetNewTASKVoucherID(ref NewVouchID, ref strErrMsg))
{
strErrMsg = "获取TASKANDVOUCHERNO表ID失败:" + strErrMsg;
return(false);
}
//sql List
string vouchertype = "60";
List <string> SQL_list = new List <string>();
SQL_list.Add("update T_TASK set DELIVERYNO=" + dbstr(tv.VoucherNo) + ", VOUCHERTYPE=" + vouchertype.ToString() + ",SUPCUSNAME=" + dbstr(head.SupCusName) + ",REMARK=" + dbstr(head.Remark) + ",REASON=" + dbstr(head.Reason) + ",SUPCUSNO=" + dbstr(head.SupCusNo) + ",ISSHELVEPOST=2,PostStatus=1"
+ " where ID =" + ID + " ");
if (IsInsertedTASKANDVOUCHERNO(ID))
{
}
else
{
SQL_list.Add("insert into T_TASKANDVOUCHERNO(ID,VOUCHERNO,TASK_ID,FACTORY,STORE)" +
"values(" + NewVouchID + "," + dbstr(tv.VoucherNo) + "," + ID + "," + dbstr(tv.Factory) + "," + dbstr(tv.Store) + ") ");
}
foreach (TaskDetails_Model tm in head.lstTaskDetails)
{
string sqlStr;
string materialNo = tm.MaterialNo;
string materialDESC = tm.MaterialDesc;
string tmaterialNo = tm.TMaterialNo;
string tmaterialDESC = tm.TMaterialDesc;
decimal materialNUM = tm.TaskQty;
if (tm.ID < 0)
{
sqlStr = "insert into T_TASKDETAILS(ID,TASK_ID,MATERIALNO,MATERIALDESC,TMATERIALNO,TMATERIALDESC,TASKQTY,REMAINQTY)" +
"values(seq_taskdetails.nextval," + ID + ",'" + materialNo + "','" + materialDESC + "','" + tmaterialNo + "','" + tmaterialDESC + "'," + materialNUM + "," + materialNUM + ")";
SQL_list.Add(sqlStr);
}
else
{
//sqlStr = "update T_TASKDETAILS set MATERIALNO='" + materialNo + "',MATERIALDESC='" + materialDESC + "',TMATERIALNO='" + tmaterialNo + "',TMATERIALDESC='" + tmaterialDESC + "',TASKQTY=" + materialNUM + ",REMAINQTY=" + materialNUM
// + " where TASK_ID=" + ID + " and ID=" + tm.ID + " ";
}
//SQL_list.Add(sqlStr);
}
foreach (string delID in lst_delID)
{
SQL_list.Add("delete T_TASKDETAILS where ID=" + delID + " ");
}
if (!strErrMsg.Equals("old"))
{
foreach (TaskVoucherDetails tm in tv.body)
{
string sqlStr;
string materialNo = tm.MaterialNo;
string materialDESC = tm.MaterialDesc;
decimal materialNUM = tm.Qty;
sqlStr = "insert into T_TASKANDVOUCHERDETAILS(ID,HEAD_ID,MATERIALNO,MATERIALDESC,QTY,ROWNO,FACTORY,FACTORYNAME,STORE)" +
"values(seq_taskandvoucherdetails.nextval," + NewVouchID.ToString() + ",'" + materialNo + "','" + materialDESC + "'," + materialNUM + ",'" + tm.RowNo + "','" + tm.Factory + "','" + tm.FactoryName + "','" + tm.Store + "' ) ";
SQL_list.Add(sqlStr);
}
}
try
{
int result = OperationSql.ExecuteNonQueryList(SQL_list);
strErrMsg = "更新成功！";
SQL_list.Clear();
SQL_list.Add("update t_tasktrans set DELIVERYNO=" + dbstr(tv.VoucherNo) + " where TaskNo = " + dbstr(head.TaskNo) + " ");
OperationSql.ExecuteNonQueryList(SQL_list);
return(true);
}
catch (Exception e)
{
strErrMsg = e.ToString();
return(false);
}
}