public bool GetTaskTransByID(ref TaskTransInfo model, UserInfo user, ref string strError) { try { using (SqlDataReader dr = _db.GetTaskTransByID(model)) { if (dr.Read()) { model = (GetModelFromDataReader(dr)); return(true); } else { strError = "找不到任何数据"; return(false); } } } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
public bool GetTaskTransListByPage(ref List <TaskTransInfo> modelList, TaskTransInfo model, ref DividPage page, UserInfo user, ref string strError) { if (page == null) { page = new DividPage(); } List <TaskTransInfo> lstModel = new List <TaskTransInfo>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_TaskTrans", GetFilterSql(model, user), "*", "Order By CreateDate desc,TaskNo,FromAreaNo,ToAreaNo,SerialNo")) { while (dr.Read()) { lstModel.Add(GetModelFromDataReader(dr)); } } modelList = lstModel; return(true); } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
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 bool DeleteTaskTransByID(TaskTransInfo model, UserInfo user, ref string strError) { try { return(_db.DeleteTaskTransByID(model)); } catch (Exception ex) { strError = ex.Message; return(false); } }
public bool SaveTaskTrans(ref TaskTransInfo model, UserInfo user, ref string strError) { try { return(_db.SaveTaskTrans(ref model)); } catch (Exception ex) { strError = ex.Message; return(false); } }
public bool ExistsTaskTransNo(TaskTransInfo model, bool bIncludeDel, UserInfo user, ref string strError) { try { return(_db.ExistsTaskTransNo(model, bIncludeDel)); } catch (Exception ex) { strError = ex.Message; return(false); } }
private SqlParameter[] GetParameterFromModel(TaskTransInfo model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000), new SqlParameter("@v_ID", model.ID.ToSqlValue()), new SqlParameter("@v_Creater", model.Creater.ToSqlValue()), new SqlParameter("@v_CreateTime", model.CreateTime.ToSqlValue()), new SqlParameter("@v_Modifyer", model.Modifyer.ToSqlValue()), new SqlParameter("@v_ModifyTime", model.ModifyTime.ToSqlValue()), new SqlParameter("@v_IsDel", model.IsDel.ToSqlValue()), }; param[0].Direction = ParameterDirection.Output; param[1].Direction = ParameterDirection.InputOutput; return(param); }
public bool SaveTaskTrans(ref TaskTransInfo model) { SqlParameter[] param = GetParameterFromModel(model); OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_SaveTaskTrans", param); string ErrorMsg = param[0].Value.ToDBString(); if (ErrorMsg.StartsWith("执行错误")) { throw new Exception(ErrorMsg); } else { model.ID = param[1].ToInt32(); return(true); } }
public bool DeleteTaskTransByID(TaskTransInfo model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000), new SqlParameter("@v_ID", model.ID.ToSqlValue()), }; param[0].Direction = ParameterDirection.Output; OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_DeleteTaskTransByID", param); string ErrorMsg = param[0].Value.ToDBString(); if (ErrorMsg.StartsWith("执行错误")) { throw new Exception(ErrorMsg); } else { return(true); } }
public bool ExistsTaskTransNo(TaskTransInfo model, bool bIncludeDel) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000), //new SqlParameter("@v_TaskTransNo", model.TaskTransNo.ToDBValue()), new SqlParameter("@IncludeDel", bIncludeDel.ToSqlValue()), }; param[0].Direction = ParameterDirection.Output; OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_ExistsTaskTransNo", param); string ErrorMsg = param[0].Value.ToDBString(); if (ErrorMsg.StartsWith("执行错误")) { throw new Exception(ErrorMsg); } else { return(string.IsNullOrEmpty(ErrorMsg)); } }
private TaskTransInfo GetModelFromDataReader(SqlDataReader dr) { TaskTransInfo model = new TaskTransInfo(); model.ID = dr["ID"].ToInt32(); model.TaskType = dr["TaskType"].ToInt32(); model.FromWarehouseNo = dr["FromWarehouseNo"].ToDBString(); model.ToWarehouseNo = dr["ToWarehouseNo"].ToDBString(); model.FromHouseNo = dr["FromHouseNo"].ToDBString(); model.ToHouseNo = dr["ToHouseNo"].ToDBString(); model.FromAreaNo = dr["FromAreaNo"].ToDBString(); model.ToAreaNo = dr["ToAreaNo"].ToDBString(); model.TaskNo = dr["TaskNo"].ToDBString(); model.Barcode = dr["Barcode"].ToDBString(); model.SerialNo = dr["SerialNo"].ToDBString(); model.VoucherType = dr["VoucherType"].ToInt32(); model.DeliveryNo = dr["DeliveryNo"].ToDBString(); model.SupCusCode = dr["SupCusCode"].ToDBString(); model.SupCusName = dr["SupCusName"].ToDBString(); model.MaterialNo = dr["MaterialNo"].ToDBString(); model.MaterialDesc = dr["MaterialDesc"].ToDBString(); model.Qty = dr["Qty"].ToDecimal(); model.CreateTime = dr["CreateDate"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "TaskDetail_ID")) { model.TaskDetail_ID = dr["TaskDetail_ID"].ToInt32(); } if (Common_Func.readerExists(dr, "SN")) { model.SN = dr["SN"].ToDBString(); } if (Common_Func.readerExists(dr, "AndalaNo")) { model.AndalaNo = dr["AndalaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "FromWarehouseName")) { model.FromWarehouseName = dr["FromWarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "ToWarehouseName")) { model.ToWarehouseName = dr["ToWarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "FromHouseName")) { model.FromHouseName = dr["FromHouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "ToHouseName")) { model.ToHouseName = dr["ToHouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "FromAreaName")) { model.FromAreaName = dr["FromAreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "ToAreaName")) { model.ToAreaName = dr["ToAreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "StrTaskType")) { model.StrTaskType = dr["StrTaskType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrVoucherType")) { model.StrVoucherType = dr["StrVoucherType"].ToDBString(); } return(model); }
private string GetFilterSql(TaskTransInfo model, UserInfo user) { try { string strSql = " Where SerialNo is not null "; bool hadWhere = true; if (model.TaskType >= 1) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " TaskType = " + model.TaskType + " "; hadWhere = true; } if (model.VoucherType >= 1) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " VoucherType = " + model.VoucherType + " "; hadWhere = true; } if (!string.IsNullOrEmpty(model.FromWarehouseNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (FromWarehouseNo LIKE '%" + model.FromWarehouseNo + "%' OR FromWarehouseName LIKE '%" + model.FromWarehouseNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.ToWarehouseNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (ToWarehouseNo LIKE '%" + model.ToWarehouseNo + "%' OR ToWarehouseName LIKE '%" + model.ToWarehouseNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.FromHouseNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (FromHouseNo LIKE '%" + model.FromHouseNo + "%' OR FromHouseName LIKE '%" + model.FromHouseNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.ToHouseNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (ToHouseNo LIKE '%" + model.ToHouseNo + "%' OR ToHouseName LIKE '%" + model.ToHouseNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.FromAreaNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (FromHouseNo LIKE '%" + model.FromAreaNo + "%' OR FromHouseName LIKE '%" + model.FromAreaNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.ToAreaNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (ToAreaNo LIKE '%" + model.ToAreaNo + "%' OR ToAreaName LIKE '%" + model.ToAreaNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.MaterialNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (MaterialNo LIKE '%" + model.MaterialNo + "%' OR MaterialDesc LIKE '%" + model.MaterialNo + "%') "; hadWhere = true; } if (!string.IsNullOrEmpty(model.SerialNo)) { string[] arr = model.SerialNo.Split('@'); if (arr.Length == 4) { model.SerialNo = arr[2]; } strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " SerialNo LIKE '%" + model.SerialNo + "%' "; hadWhere = true; } if (!string.IsNullOrEmpty(model.SN)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " SN LIKE '%" + model.SN + "%' "; hadWhere = true; } if (!string.IsNullOrEmpty(model.AndalaNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " AndalaNo LIKE '%" + model.AndalaNo + "%' "; hadWhere = true; } if (!string.IsNullOrEmpty(model.DeliveryNo)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " DeliveryNo LIKE '%" + model.DeliveryNo + "%' "; hadWhere = true; } if (!string.IsNullOrEmpty(model.Creater)) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " (Creater LIKE '%" + model.Creater + "%' OR CreaterNo LIKE '%" + model.Creater + "%') "; hadWhere = true; } if (model.StartTime != null) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " CreateDate >= '" + model.StartTime.ToDateTime().Date.ToString("yyyy-MM-dd 00:00:00") + "' "; hadWhere = true; } if (model.EndTime != null) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " CreateDate <= '" + model.EndTime.ToDateTime().AddDays(1).Date.ToString("yyyy-MM-dd 00:00:00") + "' "; hadWhere = true; } return(strSql); } catch { return(string.Empty); } }