/// <summary> /// 设备配件添加操作 /// </summary> /// <param name="model">设备配件信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddEquipmentFitInfo(EquipmentFitModel EquipFitModel) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.EquipmentFittings"); sql.AppendLine(" (FitXH "); sql.AppendLine(" ,FittingNO "); sql.AppendLine(" ,CompanyCD "); sql.AppendLine(" ,EquipmentID "); sql.AppendLine(" ,FittingName "); sql.AppendLine(" ,FittingDescription "); sql.AppendLine(" ,EquiName "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine("VALUES "); sql.AppendLine(" (@FitXH "); sql.AppendLine(" ,@FittingNO "); sql.AppendLine(" ,@CompanyCD "); sql.AppendLine(" ,@EquipmentID "); sql.AppendLine(" ,@FittingName "); sql.AppendLine(" ,@FittingDescription "); sql.AppendLine(" ,@EquiName "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID) "); //设置参数 SqlParameter[] param; param = new SqlParameter[9]; param[0] = SqlHelper.GetParameter("@FitXH", EquipFitModel.FitXH); param[1] = SqlHelper.GetParameter("@FittingNO", EquipFitModel.FittingNO); param[2] = SqlHelper.GetParameter("@CompanyCD", EquipFitModel.CompanyCD); param[3] = SqlHelper.GetParameter("@EquipmentID", EquipFitModel.EquipmentID); param[4] = SqlHelper.GetParameter("@FittingName", EquipFitModel.FittingName); param[5] = SqlHelper.GetParameter("@FittingDescription", EquipFitModel.FittingDescription); param[6] = SqlHelper.GetParameter("@EquiName", EquipFitModel.EquiName); param[7] = SqlHelper.GetParameter("@ModifiedDate", EquipFitModel.ModifiedDate); param[8] = SqlHelper.GetParameter("@ModifiedUserID", EquipFitModel.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { return false; } }
/// <summary> /// 添加设备 /// </summary> /// <param name="EquipModel">设备信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddEquipInfo(EquipmentFitModel EquipFitModel) { return EquipmentFitDBHelper.AddEquipmentFitInfo(EquipFitModel); }
/// <summary> /// 设备和配件添加操作 /// </summary> /// <param name="model">设备信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool UpdateAll(string UpdateEquipInfoSql, string FitInfo, string EquipmentNo, string CompanyCD) { EquipmentFitModel EquipFitM = new EquipmentFitModel(); string[] strarray = null; string recorditems = ""; string[] inseritems = null; try { strarray = FitInfo.Split('|'); string[] sqlarray = new string[strarray.Length+1]; sqlarray[0] = UpdateEquipInfoSql; sqlarray[1] = "DELETE officedba.EquipmentFittings WHERE EquipmentNo = '" + EquipmentNo + "'"; for (int i = 1; i < strarray.Length; i++) { StringBuilder fitsql = new StringBuilder(); recorditems = strarray[i]; inseritems = recorditems.Split(','); if (recorditems.Length != 0) { string fitname = inseritems[0].ToString();//配件名称 string fitdesc = inseritems[1].ToString();//描述 fitsql.AppendLine("INSERT INTO officedba.EquipmentFittings"); fitsql.AppendLine(" (CompanyCD "); fitsql.AppendLine(" ,EquipmentNo "); fitsql.AppendLine(" ,FittingName "); fitsql.AppendLine(" ,FittingDescription) "); fitsql.AppendLine("VALUES "); fitsql.AppendLine(" ('" + CompanyCD + "' "); fitsql.AppendLine(" ,'" + EquipmentNo + "' "); fitsql.AppendLine(" ,'" + fitname + "' "); fitsql.AppendLine(" ,'" + fitdesc + "') "); sqlarray[i+1] = fitsql.ToString(); } } SqlHelper.ExecuteTransForListWithSQL(sqlarray); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { return false; } }