/// <summary>
/// 获取指定产品的总成名称
/// </summary>
/// <param name="productCode">产品编码</param>
/// <param name="names">获取到的总成名称</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作是否成功的标志</returns>
public bool GetAssemblyName(string productCode, List <string> names, out string error)
{
error = null;
Hashtable paramTable = new Hashtable();
paramTable.Add("@ProductCode", productCode);
DataSet ds = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("SelP_AssemblyName", ds, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
if (ds.Tables == null || ds.Tables[0].Rows.Count == 0)
{
error = "没有找到总成信息";
return(false);
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
names.Add(ds.Tables[0].Rows[i][0].ToString());
}
return(true);
}
/// <summary>
/// 获取某一版本的Bom信息
/// </summary>
/// <param name="edition">总成型号</param>
/// <param name="sysVersion">版本号</param>
/// <param name="dataTable">Bom 数据表</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回true</returns>
public bool GetBom(string edition, string sysVersion, out DataTable dataTable, out string error)
{
dataTable = null;
error = null;
Hashtable paramTable = new Hashtable();
DataSet ds = new DataSet();
paramTable.Add("@Edition", edition);
paramTable.Add("@SysVersion", sysVersion);
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("SelAllP_ProductBom", ds, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
if (error != "没有找到任何数据")
{
return(false);
}
}
dataTable = ds.Tables[0];
return(true);
}
/// <summary>
/// 添加初始化收发存汇总表初始的上月结存记录
/// </summary>
/// <param name="goodsCode">图号型号</param>
/// <param name="goodsName">物品名称</param>
/// <param name="spec">规格</param>
/// <param name="counts">数量</param>
/// <param name="materialType">领料类型</param>
/// <param name="dateTimes">日期</param>
/// <param name="returnBill">返回table 数据集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool AddReceiveSendSaveBalanceTable(string goodsCode, string goodsName, string spec,
int counts, string dateTimes, string materialType, out DataTable returnBill, out string error)
{
returnBill = null;
error = null;
Hashtable paramTable = new Hashtable();
paramTable.Add("@GoodsCode", goodsCode);
paramTable.Add("@Spec", spec);
paramTable.Add("@GoodsName", goodsName);
paramTable.Add("@Counts", counts);
paramTable.Add("@DateTimes", dateTimes);
paramTable.Add("@MaterialType", materialType);
DataSet ReceiveSendSaveGatherBillDetailBillDataSet = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD =
m_dbOperate.RunProc_CMD("AddS_ReceiveSendSaveBalanceTable",
ReceiveSendSaveGatherBillDetailBillDataSet, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
returnBill = ReceiveSendSaveGatherBillDetailBillDataSet.Tables[0];
return(true);
}
/// <summary>
/// 执行带参数的查询存储过程
/// </summary>
/// <param name="procedureName">存储过程名称</param>
/// <param name="paramTable">参数表</param>
/// <param name="ds">返回的数据集</param>
/// <param name="err">错误信息, 没有错误该值为null</param>
/// <returns>成功返回true</returns>
public static bool ExecuteDbProcedure(string procedureName, Hashtable paramTable, DataSet ds, out string err)
{
err = null;
if (m_dboperate == null)
{
GetIDBOperate();
}
Dictionary <OperateCMD, object> dicOperateCMD = m_dboperate.RunProc_CMD(procedureName, ds, paramTable);
return(GetResult(dicOperateCMD, out err));
}
/// <summary>
/// 检测是否能进行试验
/// </summary>
/// <param name="productCode">箱号</param>
/// <param name="error">出错时返回错误信息</param>
/// <returns>允许试验返回true</returns>
public bool CanOffLineTest(string productCode, out string error)
{
error = null;
Hashtable paramTable = new Hashtable();
DataSet ds = new DataSet();
paramTable.Add("@ProductNumber", productCode);
IDBOperate dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
Dictionary <OperateCMD, object> dicOperateCMD = dbOperate.RunProc_CMD("ZPX_AllowOffLineTest", ds, paramTable);
DataTable dataTable = ds.Tables[0];
if (dataTable.Rows[0][0].ToString() == "允许")
{
return(true);
}
error = dataTable.Rows[0][0].ToString();
if (dataTable.Columns.Count == 1)
{
return(false);
}
return(false);
}
/// <summary>
/// 检测是否能进行试验
/// </summary>
/// <param name="productCode">箱号</param>
/// <param name="error">出错时返回错误信息</param>
/// <returns>允许试验返回true</returns>
public bool CanOffLineTest(string productCode, out string error)
{
error = null;
Hashtable paramTable = new Hashtable();
DataSet ds = new DataSet();
paramTable.Add("@ProductNumber", productCode);
IDBOperate dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
Dictionary <OperateCMD, object> dicOperateCMD = dbOperate.RunProc_CMD("ZPX_AllowOffLineTest", ds, paramTable);
DataTable dataTable = ds.Tables[0];
if (dataTable.Rows[0][0].ToString() == "允许")
{
return(true);
}
error = dataTable.Rows[0][0].ToString();
if (dataTable.Columns.Count == 1)
{
return(false);
}
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.ZPX_CVTOffLineTestResultLog
where a.ProdutCode == productCode
select a;
if (varData.Count() == 0)
{
ZPX_CVTOffLineTestResultLog lnqLog = new ZPX_CVTOffLineTestResultLog();
lnqLog.ProdutCode = productCode;
lnqLog.Z08FinishTime = Convert.ToDateTime(dataTable.Rows[0][1]);
ctx.ZPX_CVTOffLineTestResultLog.InsertOnSubmit(lnqLog);
}
else if (varData.Count() == 1)
{
ZPX_CVTOffLineTestResultLog lnqLog = varData.Single();
lnqLog.Z08FinishTime = Convert.ToDateTime(dataTable.Rows[0][1]);
}
ctx.SubmitChanges();
return(false);
}
/// <summary>
/// 获取与营销有关的所有产品信息
/// </summary>
/// <param name="error">出错时输出的错误信息</param>
/// <returns>成功返回获取到的产品信息，失败返回null</returns>
public DataTable GetAllProductList(out string error)
{
error = null;
DataSet ds = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("", ds);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(null);
}
return(ds.Tables[0]);
}
/// <summary>
/// 判断某零件是否属于AB类零件
/// </summary>
/// <param name="goodsCode">图号型号</param>
/// <param name="spec">规格</param>
/// <param name="returnTable">返回的AB类零件数据集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool JudgeGoodsGrade(string goodsCode, string spec, out DataTable returnTable, out string error)
{
returnTable = null;
error = null;
Hashtable paramTable = new Hashtable();
paramTable.Add("@GoodsCode", goodsCode);
paramTable.Add("@Spec", spec);
DataSet goodsGradeDataSet = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD =
m_dbOperate.RunProc_CMD("JudgeGoodsGradeFromQ_GoodsGradeTable", goodsGradeDataSet, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
returnTable = goodsGradeDataSet.Tables[0];
return(true);
}
/// <summary>
/// 获得所有三包外返修零件单价信息
/// </summary>
/// <returns>返回获得的三包外返修零件单价信息</returns>
public DataTable GetGoodsUnitPriceInfo()
{
Hashtable paramTable = new Hashtable();
DataSet ds = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = m_dbDate.RunProc_CMD("YX_Select_ThreePacketsOfTheRepairGoodsUnitPrice",
ds, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
return(null);
}
return(ds.Tables[0]);
}
/// <summary>
/// 获取供应商信息表
/// </summary>
/// <param name="table">供应商信息表</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>返回是否成功获取供应商信息表</returns>
public bool GetAllProvider(out DataTable table, out string error)
{
table = null;
error = null;
DataSet dsProviderInfo = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("SelAllProvider", dsProviderInfo);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
table = dsProviderInfo.Tables[0];
return(true);
}
public void Check_LeaveType(string typeCode, decimal hours, int?billID)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
IDBOperate m_dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
HR_LeaveType leaveType = GetLeaveType(ctx, typeCode);
Hashtable paramTable = new Hashtable();
paramTable.Add("@TypeCode", leaveType.TypeCode);
paramTable.Add("@Hours", hours);
paramTable.Add("@WorkID", BasicInfo.LoginID);
paramTable.Add("@BillID", billID == null ? 0 : billID);
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("HR_LeaveBill_Type_Check", paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
throw new Exception(Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]));
}
}
/// <summary>
/// 获取选配表表头所有信息
/// </summary>
/// <param name="table">返回查询的数据信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>获取成功返回True，获取失败返回False</returns>
public bool GetAllChoseConfectTableHead(out DataTable table, out string error)
{
table = null;
error = null;
DataSet tempDataSet = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("SelAllP_ChoseConfectTableHead", tempDataSet);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
table = tempDataSet.Tables[0];
return(true);
}
/// <summary>
/// 台帐
/// </summary>
/// <param name="productName">查询方式</param>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="storageID">库房ID</param>
/// <param name="showTable">返回table数据集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool GetAllGather(string productName, DateTime startDate, DateTime endDate, string storageID,
out DataTable showTable, out string error)
{
IDBOperate dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
error = null;
showTable = null;
try
{
Hashtable paramTable = new Hashtable();
if (productName == "pro_B_GoodsListGather")
{
paramTable.Add("@StartDate", startDate);
paramTable.Add("@EndDate", endDate);
}
DataSet ds = new DataSet();
Dictionary <OperateCMD, object> dicOperateCMD = dbOperate.RunProc_CMD(productName, ds, paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
error = Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]);
return(false);
}
showTable = ds.Tables[0];
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}