public bool UpdateTaskByPost(string strDeliveryXml, BLL.Basic.User.UserInfo userModel, ref string strErrMsg)
{
try
{
int iResult = 0;
SqlParameter[] cmdParms = new SqlParameter[]
{
new SqlParameter("deliveryinfo_xml", SqlDbType.Image),
new SqlParameter("strUserNo", SqlDbType.NVarChar),
//new SqlParameter("bResult", SqlDbType.Int,ParameterDirection.Output),
new SqlParameter("bResult", SqlDbType.Int),
new SqlParameter("strErrMsg", SqlDbType.NVarChar, 200, strErrMsg)
};
cmdParms[0].Value = strDeliveryXml;
cmdParms[1].Value = userModel.UserNo;
TOOL.WriteLogMethod.WriteLog("方法：UpdateTaskByPost---操作人：" + userModel.UserName + strDeliveryXml);
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "p_updatetaskbypost", cmdParms);
iResult = Convert.ToInt32(cmdParms[2].Value.ToString());
strErrMsg = cmdParms[3].Value.ToString();
return(iResult == 1 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public bool CreateQuanlityReturnVoucher(string strQuanlityXml, ref string strReturnNo, BLL.Basic.User.UserInfo userModel, ref string strErrMsg)
{
try
{
int iResult = 0;
SqlParameter[] cmdParms = new SqlParameter[]
{
new SqlParameter("strQuanlityXml", SqlDbType.Image),
new SqlParameter("struserno", SqlDbType.NVarChar),
new SqlParameter("strreturnno", SqlDbType.NVarChar, 50, strReturnNo),
//new SqlParameter("bresult", SqlDbType.Int,ParameterDirection.Output),
new SqlParameter("bresult", SqlDbType.Int),
new SqlParameter("strerrmsg", SqlDbType.NVarChar, 100, strErrMsg)
};
cmdParms[0].Value = strQuanlityXml;
cmdParms[1].Value = userModel.UserNo;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "p_createquanlityreturnvoucher", cmdParms);
iResult = Convert.ToInt32(cmdParms[3].Value.ToString());
strReturnNo = cmdParms[2].Value.ToString();
strErrMsg = cmdParms[4].Value.ToString();
return(iResult == 1 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UnLockTaskOperUser(string strTaskXml, BLL.Basic.User.UserInfo userModel, ref string strErrMsg)
{
try
{
int iResult = 0;
SqlParameter[] cmdParms = new SqlParameter[]
{
new SqlParameter("Task_xml", SqlDbType.Image),
new SqlParameter("strUserNo", SqlDbType.NVarChar),
//new SqlParameter("bResult", SqlDbType.Int,ParameterDirection.Output),
new SqlParameter("bResult", SqlDbType.Int),
//new SqlParameter("strErrMsg", SqlDbType.NVarChar,1000,strErrMsg,ParameterDirection.Output)
new SqlParameter("strErrMsg", SqlDbType.NVarChar, 1000, strErrMsg)
};
cmdParms[0].Value = strTaskXml;
cmdParms[1].Value = userModel.UserNo;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "p_unlockoperuser", cmdParms);
iResult = Convert.ToInt32(cmdParms[2].Value.ToString());
strErrMsg = cmdParms[3].Value.ToString();
return(iResult == 1 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public bool QueryStockSumByWHcode(string WHcode, out List <Stock_Model> list, out string strErrMsg)
{
try
{
string sql = @"select materialno, materialdesc,materialstd,SUM(qty) as sumqty from T_STOCK where warehouseno = '" + WHcode + "' group by materialno,materialdesc,materialstd,warehouseno";
list = new List <Stock_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, sql))
{
while (dr.Read())
{
Stock_Model model = new Stock_Model();
model.MaterialNo = dr["materialno"].ToDBString();
model.MaterialENDesc = dr["materialdesc"].ToDBString();
model.MaterialStd = dr["materialstd"].ToDBString();
model.Qty = dr["sumqty"].ToDecimal();
list.Add(model);
}
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
list = null;
strErrMsg = ex.Message;
return(false);
}
}
public SqlDataReader GetLastProdDetails()
{
string strSql = string.Empty;
strSql = string.Format("select 1 from T_TransferMain where ISNULL(OrderState,0)<2");
object oRes = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
if (oRes == null || Convert.ToInt32(oRes) > 1)
{
return(null);
}
strSql = string.Format(@"SELECT [id]
,[mID]
,[RowNo]
,[cInvCode]
,[BuildingNo]
,[QtyReq]
,[QtyTransfer]
,[iOperate]
,[sOperate]
,[sInvType]
,[WorkShopStock]
FROM [Barcode].[dbo].[T_TRANSFERDETAIL]
where mID=(SELECT [id] FROM [Barcode].[dbo].[T_TransferMain] where ISNULL(OrderState,0)<2)");
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public bool GiveUpTempTrans(SaleBillDetails_Model detail, out string strErrMsg)
{
try
{
string sql = @"update salebillvouchs_extradefine set cbdefine5 = null,cbdefine6 = null where autoid = " + detail.autoid;
int i = OperationSql.ExecuteNonQueryForERP(CommandType.Text, sql, null);
if (i <= 0)
{
strErrMsg = "数据库操作失败,未能弃审记录";
return(false);
}
sql = @"update T_temptrans set verifydate = null where cinvcode = '" + detail.cinvcode + "' and ssbvcode = '" + detail.ssbvcode + "'";
i = OperationSql.ExecuteNonQuery(CommandType.Text, sql, null);
if (i <= 0)
{
strErrMsg = "数据库操作失败,未能弃审记录";
return(false);
}
strErrMsg = "";
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
public List <Stock_Model> GetStockByAreaNo(string strAreaNo)
{
try
{
string strSql = "select (case when materialno is null then tmaterialno else materialno end) as materialno,(case when materialdesc is null then tmaterialdesc else materialdesc end) as materialdesc,sum(QTY) as qty from t_stock where areano ='{0}' " +
"group by materialno,materialdesc,tmaterialno,tmaterialdesc";
strSql = string.Format(strSql, strAreaNo);
List <Stock_Model> lstStock = new List <Stock_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
Stock_Model SM = new Stock_Model();
SM.MaterialNo = dr["materialno"].ToDBString();
SM.MaterialENDesc = dr["materialdesc"].ToDBString();
SM.Qty = dr["qty"].ToDecimal();
lstStock.Add(SM);
}
}
return(lstStock);
}
catch (Exception ex)
{
throw ex;
}
}
public List <Stock_Model> GetStockByMaterialNo(string strMaterialNo)
{
try
{
List <Stock_Model> lstStock = new List <Stock_Model>();
string strSql = string.Format("select * from v_getstockbymaterialno where materialno = '{0}'", strMaterialNo);
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
Stock_Model stockModel = new Stock_Model();
stockModel.MaterialNo = dr["materialno"].ToDBString();
stockModel.AreaNo = dr["areano"].ToDBString();
stockModel.MaterialENDesc = dr["materialdesc"].ToDBString();
stockModel.Qty = dr["qty"].ToDecimal();
lstStock.Add(stockModel);
}
}
return(lstStock);
}
catch (Exception ex)
{
throw ex;
}
}
public TempMaterial GetTempMaterialByTempNo(string TempMaterialNo)
{
try
{
TempMaterial TM = new TempMaterial();
string strSql = string.Format("select * from T_TEMPMATERIAL where TEMPMATERIALNO = '{0}'", TempMaterialNo);
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
TM.TempMaterialNo = dr["TEMPMATERIALNO"].ToString();
TM.TempMaterialDesc = dr["TEMPMATERIALDESC"].ToString();
TM.MaterialNo = dr["MATERIALNO"].ToString();
TM.MaterialDesc = dr["MATERIALDESC"].ToString();
return(TM);
}
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
internal SqlDataReader GetMenuListByUserID(UserInfo User, bool IncludNoCheck)
{
string strSql = string.Empty;
if (User.ID >= 1)
{
strSql = string.Format("SELECT DISTINCT 2 AS IsChecked,T_Menu.* from T_Menu WHERE ISDEL <> 2 AND MenuStatus <> 2 AND ID IN (SELECT MenuID FROM T_GroupWithMenu WHERE GroupID IN (SELECT T_USERGROUP.ID FROM T_UserWithGroup JOIN T_USERGROUP ON T_UserWithGroup.Groupid = T_USERGROUP.ID WHERE T_USERGROUP.ISDEL <> 2 AND T_USERGROUP.USERGROUPSTATUS <> 2 AND T_UserWithGroup.UserID = {0})) ", User.ID);
if (IncludNoCheck)
{
strSql += string.Format("UNION SELECT DISTINCT 1 AS IsChecked,T_Menu.* from T_Menu WHERE ISDEL <> 2 AND MenuStatus <> 2 AND ID NOT IN (SELECT MenuID FROM T_GroupWithMenu WHERE GroupID IN (SELECT T_USERGROUP.ID FROM T_UserWithGroup JOIN T_USERGROUP ON T_UserWithGroup.Groupid = T_USERGROUP.ID WHERE T_USERGROUP.ISDEL <> 2 AND T_USERGROUP.USERGROUPSTATUS <> 2 AND T_UserWithGroup.UserID = {0})) ", User.ID);
}
if (User.UserType == 1)
{
strSql += "UNION SELECT DISTINCT 2 AS IsChecked,T_Menu.* from T_Menu WHERE ISDEL <> 2 AND MenuStatus <> 2 AND SafeLevel <> 0 ";
}
strSql = string.Format("SELECT * FROM ({0}) T ORDER BY NodeLevel, NodeSort, ID ", strSql);
}
else
{
if (IncludNoCheck)
{
strSql = "SELECT DISTINCT 1 AS IsChecked,T_Menu.* FROM T_Menu WHERE ISDEL <> 2 AND MenuStatus <> 2 ORDER BY NodeLevel, NodeSort, ID ";
}
else
{
strSql = "SELECT DISTINCT 2 AS IsChecked,T_Menu.* FROM T_Menu WHERE 1 = 2";
}
}
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
//插入数据
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 List <DeliveryReceiveDetail_Model> GetQualityDetailInfo(DeliveryReceive_Model DeliveryInfo)
{
try
{
string strSql = string.Format("select * from V_GETQUALITYDETAILINFO where receive_id = {0} and voucherno = '{1}' order by rowno asc ", DeliveryInfo.ID, DeliveryInfo.VoucherNo);
List <DeliveryReceiveDetail_Model> lstDeliveryDetailInfo = new List <DeliveryReceiveDetail_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
DeliveryReceiveDetail_Model DRM = new DeliveryReceiveDetail_Model();
DRM.ID = dr["ID"].ToInt32();
DRM.RowNo = dr["RowNo"].ToDBString();
DRM.MaterialNo = dr["MaterialNo"].ToDBString();
DRM.MaterialDesc = dr["MaterialDesc"].ToDBString();
DRM.ReceiveQty = (decimal)dr["ReceiveQty"];
DRM.Unit = dr["Unit"].ToDBString();
DRM.PrdVersion = dr["PrdVersion"].ToDBString();
DRM.QualityQty = (decimal)dr["QualityQty"];
DRM.UnQualityQty = (decimal)dr["UnQualityQty"];
DRM.VoucherNo = dr["VoucherNo"].ToDBString();
DRM.QualityType = dr["qualitytype"].ToDBString();//string.Empty;//Common_Func.GetComboBoxItem(Common_Func.GetParentMenuByMenu);
lstDeliveryDetailInfo.Add(DRM);
}
}
return(lstDeliveryDetailInfo);
}
catch (Exception ex)
{
throw ex;
}
}
public bool ExistsAreaNo(AreaInfo model, bool bIncludeDel)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000),
new SqlParameter("@v_AreaNo", model.AreaNo.ToSqlValue()),
new SqlParameter("@IncludeDel", bIncludeDel.ToSqlValue()),
};
param[0].Direction = ParameterDirection.Output;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_ExistsAreaNo", param);
string ErrorMsg = param[0].Value.ToDBString();
if (!string.IsNullOrEmpty(ErrorMsg))
{
throw new Exception(ErrorMsg);
}
return(true);
//if (ErrorMsg.StartsWith("执行错误"))
//{
// throw new Exception(ErrorMsg);
//}
//else
//{
// return string.IsNullOrEmpty(ErrorMsg);
//}
}
public bool PrintQuality(DeliveryReceive_Model deliveryMdl, UserInfo userModel, ref string strErrMsg)
{
try
{
string strSql = "";
strSql = string.Format("update t_receive set printqty = ISNULL(printqty,0) + {0} where ID = {1} ", 1, deliveryMdl.ID);
int i = OperationSql.ExecuteNonQuery2(CommandType.Text, strSql);
if (i <= 0)
{
strErrMsg = string.Format("未更新质检主表任何行:{0}", strSql);
return(false);
}
strSql = string.Format("update t_receivedetails set printqty = ISNULL(printqty,0) + {0}, printtime = sysdate where receive_id = {1} and voucherno = '{2}' ", 1, deliveryMdl.ID, deliveryMdl.VoucherNo);
i = OperationSql.ExecuteNonQuery2(CommandType.Text, strSql);
if (i <= 0)
{
strErrMsg = string.Format("未更新质检子表任何行:{0}", strSql);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCheckStatusByID(CheckInfo model)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000),
new SqlParameter("@v_ID", SqlDbType.Int),
new SqlParameter("@v_CheckStatus", SqlDbType.Int),
};
param[1].Value = model.ID;
param[2].Value = model.CheckStatus;
param[0].Direction = ParameterDirection.Output;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_UpdateCheckStatusByID", param);
string ErrorMsg = param[0].Value.ToDBString();
if (ErrorMsg.StartsWith("执行错误"))
{
throw new Exception(ErrorMsg);
}
else
{
return(true);
}
}
internal SqlDataReader GetWarehouseListByUserID(UserInfo User, bool IncludNoCheck)
{
string strSql = string.Empty;
if (User.ID >= 1)
{
strSql = string.Format("SELECT DISTINCT 2 AS IsChecked,T_Warehouse.* FROM T_Warehouse WHERE ISDEL <> 2 AND WarehouseStatus <> 2 AND ID IN (SELECT WarehouseID FROM T_UserWithWarehouse WHERE UserID = {0}) ", User.ID);
if (IncludNoCheck)
{
strSql += string.Format("UNION SELECT DISTINCT 1 AS IsChecked,T_Warehouse.* FROM T_Warehouse WHERE ISDEL <> 2 AND WarehouseStatus <> 2 AND ID NOT IN (SELECT WarehouseID FROM T_UserWithWarehouse WHERE UserID = {0}) ", User.ID);
}
strSql = string.Format("SELECT * FROM ({0}) T ORDER BY ID ", strSql);
}
else
{
if (IncludNoCheck)
{
strSql = "SELECT DISTINCT 1 AS IsChecked,T_Warehouse.* FROM T_Warehouse WHERE ISDEL <> 2 AND WarehouseStatus <> 2";
}
else
{
strSql = "SELECT DISTINCT 2 AS IsChecked,T_Warehouse.* FROM T_Warehouse WHERE 1 = 2";
}
}
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
//根据物料号获取物料描述
public bool GetTempMaterialName(string materialNo, ref string materialDESC)
{
try
{
if (string.IsNullOrEmpty(materialNo))
{
string sqlTemp = "select TEMPMATERIALDESC from T_TEMPMATERIAL where TEMPMATERIALNO='" + materialNo + "'";
using (SqlDataReader dr = OperationSql.ExecuteReader(CommandType.Text, sqlTemp))
{
if (dr.Read())
{
materialDESC = dr["TEMPMATERIALDESC"].ToString();
return(true);
}
else
{
return(false);
}
}
}
}
catch (Exception)
{
return(false);
}
return(false);
}
internal bool ReCheckByCheck(CheckInfo model, ref CheckInfo reCheck, Basic.User.UserInfo user, ref string strError)
{
SqlParameter[] param = new SqlParameter[] {
//new OracleParameter("@ErrorMsg",OracleDbType.NVarchar2,1000),
//new OracleParameter("@v_UserID", user.ID.ToOracleValue()),
//new OracleParameter("@xmlCheck", XMLUtil.XmlUtil.Serializer(typeof(CheckInfo),model)),
//new OracleParameter("@v_ReCheckID",OracleDbType.Int32,18),
};
param[0].Direction = ParameterDirection.Output;
param[1].Direction = ParameterDirection.Input;
param[2].Direction = ParameterDirection.Input;
param[3].Direction = ParameterDirection.Output;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_ReCheck", param);
strError = param[0].Value.ToDBString();
if (strError.StartsWith("执行错误"))
{
//throw new Exception(strError);
return(false);
}
else
{
reCheck.ID = param[3].Value.ToInt32();
return(true);
}
}
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);
}
}
internal SqlDataReader GetMenuListByUserGroupID(UserGroupInfo UserGroup, bool IncludNoCheck)
{
string strSql = string.Empty;
if (UserGroup.ID >= 1)
{
strSql = string.Format("SELECT DISTINCT 2 AS IsChecked,T_Menu.* FROM T_Menu WHERE ISDEL <> 2 AND ID IN (SELECT MenuID FROM T_GroupWithMenu WHERE GroupID = {0}) ", UserGroup.ID);
if (IncludNoCheck)
{
strSql += string.Format("UNION SELECT DISTINCT 1 AS IsChecked,T_Menu.* FROM T_Menu WHERE ISDEL <> 2 AND ID NOT IN (SELECT MenuID FROM T_GroupWithMenu WHERE GroupID = {0}) ", UserGroup.ID);
}
strSql = string.Format("SELECT * FROM ({0}) T ORDER BY NodeLevel, NodeSort, ID ", strSql);
}
else
{
if (IncludNoCheck)
{
strSql = "SELECT DISTINCT 1 AS IsChecked,T_Menu.* FROM T_Menu WHERE ISDEL <> 2 ORDER BY NodeUrl, NodeSort, ID ";
}
else
{
strSql = "SELECT DISTINCT 2 AS IsChecked,T_Menu.* FROM T_Menu WHERE 1 = 2";
}
}
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public bool SaveQualityDetailInfo(string strDeliveryXml, UserInfo userModel, ref string strErrMsg)
{
try
{
int iResult = 0;
SqlParameter[] cmdParms = new SqlParameter[]
{
new SqlParameter("deliverydetailinfo_xml", SqlDbType.Image),
new SqlParameter("struserno", SqlDbType.NVarChar),
//new SqlParameter("bresult", SqlDbType.Int,ParameterDirection.Output),
new SqlParameter("bresult", SqlDbType.Int),
//new SqlParameter("strerrmsg", SqlDbType.NVarChar,100,strErrMsg,ParameterDirection.Output)
new SqlParameter("strerrmsg", SqlDbType.NVarChar, 100, strErrMsg)
};
cmdParms[0].Value = strDeliveryXml;
cmdParms[1].Value = userModel.UserNo;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "p_updatequalityqty", cmdParms);
iResult = Convert.ToInt32(cmdParms[2].Value.ToString());
strErrMsg = cmdParms[3].Value.ToString();
return(iResult == 1 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
internal bool UpdateCheckAnalyse(CheckDetailsInfo model, ref string strError)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000),
new SqlParameter("@v_ID", SqlDbType.Int),
new SqlParameter("@v_CheckType", SqlDbType.Int),
};
param[0].Direction = ParameterDirection.Output;
param[1].Value = model.CheckID;
param[2].Value = model.CheckType;
OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_GetCheckAnalyse", param);
strError = param[0].Value.ToDBString();
if (strError.StartsWith("执行错误"))
{
//throw new Exception(strError);
return(false);
}
else
{
return(true);
}
}
internal bool AreaOfCheck(int checkID, AreaInfo area)
{
string strSql = string.Empty;
strSql = string.Format("select count(1) from t_check where id = {0} and checktype in (1,2,3,5)", checkID);
object obj = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
if (obj.ToInt32() <= 0)
{
return(true);
}
int checktype = 0;
strSql = string.Format("select CheckType from t_check where id = {0}", checkID);
checktype = OperationSql.ExecuteScalar(CommandType.Text, strSql, null).ToInt32();
switch (checktype)
{
case 1:
strSql = string.Format("select count(1) from v_CheckDetails where checkid = {0} and warehouseno = '{1}' ", checkID, area.WarehouseNo);
obj = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
if (obj.ToInt32() <= 0)
{
return(false);
}
break;
case 2:
strSql = string.Format("select count(1) from v_CheckDetails where checkid = {0} and warehouseno = '{1}' and houseno = '{2}' ", checkID, area.WarehouseNo, area.HouseNo);
obj = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
if (obj.ToInt32() <= 0)
{
return(false);
}
break;
case 3:
strSql = string.Format("select count(1) from v_CheckDetails where checkid = {0} and areano = '{1}' ", checkID, area.AreaNo);
obj = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
if (obj.ToInt32() <= 0)
{
return(false);
}
break;
case 5:
//strSql = string.Format("select count(1) from v_CheckDetails A join v_area B on A.WAREHOUSENO = B.warehouseno where A.checkid = {0} and A.warehouseno = '{1}' and B.areano = '{2}' ", checkID, area.WarehouseNo, area.AreaNo);
strSql = string.Format("select count(1) from v_CheckDetails where checkid = {0} and nvl(warehouseno,'{1}') = '{1}' ", checkID, area.WarehouseNo);
obj = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
if (obj.ToInt32() <= 0)
{
return(false);
}
break;
}
return(true);
}
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 SqlDataReader GetSpecialReturnMaterialByID(SpecialReturnMaterial model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM T_SpecialReturnMaterial WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
internal SqlDataReader GetAllMenuList(bool IsChecked)
{
string strSql = string.Empty;
strSql = string.Format("SELECT {0} AS IsChecked,T_Menu.* FROM T_Menu WHERE ISDEL <> 2 ", IsChecked.ToInt32());
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetTaskTransByID(TaskTransInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM TTaskTrans WHERE ID = {0}", model.ID);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetWarehouseBycWhCode(WarehouseInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT cwhcode,cwhname FROM Warehouse WHERE cwhcode = '{0}'", model.WarehouseNo);
return(OperationSql.ExecuteReaderForERP(CommandType.Text, strSql, null));
}
public SqlDataReader GetWarehouseByID(WarehouseInfo model)
{
string strSql = string.Empty;
strSql = string.Format("SELECT * FROM V_Warehouse WHERE ID = {0} or WarehouseNo='{1}'", model.ID, model.WarehouseNo);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
public SqlDataReader GetSpecialList(string fieldName)
{
string strSql = string.Empty;
strSql = string.Format("SELECT {0} FROM T_SpecialReturnMaterial WHERE IsDel = 1", fieldName);
return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
}
