/// <summary> /// 删除 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Delete(BaseEntity p_Entity) { try { ItemPic MasterEntity = (ItemPic)p_Entity; if (MasterEntity.MainID == 0) { return(0); } //删除主表数据 string Sql = ""; Sql = "DELETE FROM Data_ItemPic WHERE " + "MainID=" + SysString.ToDBString(MasterEntity.MainID) + " AND Seq=" + SysString.ToDBString(MasterEntity.Seq); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(Sql); } else { AffectedRows = sqlTrans.ExecuteNonQuery(Sql); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E); } }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, BaseEntity[] p_BE3, BaseEntity[] p_BE4, BaseEntity[] p_BE5, int Flag, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); Item entity = (Item)p_BE; string sql = "SELECT ItemCode FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entity.ItemCode); DataTable dt = sqlTrans.Fill(sql); if (dt.Rows.Count > 0) { throw new BaseException("编码已存在,请重新生成"); } ItemCtl control = new ItemCtl(sqlTrans); entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_Item, sqlTrans); control.AddNew(entity); ItemColorDtsRule rule2 = new ItemColorDtsRule(); rule2.RSave(entity, p_BE2, sqlTrans); ItemAddRule ruleItemAdd = new ItemAddRule(); for (int i = 0; i < p_BE3.Length; i++) { ItemAdd entityDts = (ItemAdd)p_BE3[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemAdd.RAdd(entityDts, sqlTrans); ruleItemAdd.UpdateFiledSet(entity.ID, entityDts.FiledSetID, entityDts.Value, sqlTrans); } ItemPicRule ruleItemPic = new ItemPicRule(); for (int i = 0; i < p_BE4.Length; i++) { ItemPic entityDts = (ItemPic)p_BE4[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemPic.RAdd(entityDts, sqlTrans); } ItemCodeFacDtsRule ruleItemCodeFac = new ItemCodeFacDtsRule(); for (int i = 0; i < p_BE5.Length; i++) { ItemCodeFacDts entityDts = (ItemCodeFacDts)p_BE5[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemCodeFac.RAdd(entityDts, sqlTrans); } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 新增 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int AddNew(BaseEntity p_Entity) { try { ItemPic MasterEntity = (ItemPic)p_Entity; if (MasterEntity.MainID == 0) { return(0); } //新增主表数据 StringBuilder MasterField = new StringBuilder(); StringBuilder MasterValue = new StringBuilder(); MasterField.Append("INSERT INTO Data_ItemPic("); MasterValue.Append(" VALUES("); MasterField.Append("MainID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ","); MasterField.Append("Seq" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ","); MasterField.Append("PicImage" + ","); MasterValue.Append(@"@PicImage" + ","); MasterField.Append("Remark" + ")"); MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ")"); object[,] obja = new object[2, 1]; obja[0, 0] = "@PicImage"; obja[1, 0] = MasterEntity.PicImage; //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString(), obja); } else { AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString(), obja); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E); } }
/// <summary> /// 检验字段值是否已存在 /// </summary> /// <param name="p_TableName">表名</param> /// <param name="p_FieldName">字段名</param> /// <param name="p_FieldValue">字段值</param> /// <param name="p_KeyField">主键(只考虑主键为ID的情况)</param> /// <param name="p_KeyValue">主键值</param> /// <param name="p_sqlTrans"></param> /// <returns></returns> private bool CheckFieldValueIsExist(BaseEntity p_BE, string p_FieldName, string p_FieldValue, IDBTransAccess p_sqlTrans) { ItemPic entity = (ItemPic)p_BE; bool ret = false; string sql = string.Format(" SELECT {0} FROM {1} WHERE 1=1 AND {0}={2} AND {3}<>{4}", p_FieldName, ItemPic.TableName, SysString.ToDBString(p_FieldValue), "ID", entity.MainID); DataTable dt = p_sqlTrans.Fill(sql); if (dt.Rows.Count != 0) { ret = true; } return(ret); }
public async Task <UploadPictureOutputDto> UploadPicture() { var files = _httpContextAccessor.HttpContext.Request.Form.Files; if (files.Count != 1) { throw new UserFriendlyException("未上传图片"); } try { var now = DateTime.Now; var relativePath = Path.Combine(now.Year.ToString(), now.Month.ToString(), now.Day.ToString(), now.Hour.ToString()); var filePath = Path.Combine(_appConfiguration["App:ImagePhysicalPath"], relativePath); var fileName = now.ToString("yyyyMMddhhmmssffff") + "_" + AbpSession.UserId; var ext = ".jpg"; if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } var file = files[0]; using (var stream = new FileStream(Path.Combine(filePath, fileName + ext), FileMode.CreateNew)) { await file.CopyToAsync(stream); } var pic = new ItemPic { Path = relativePath, FileName = fileName, Size = file.Length, Extension = ext }; var id = await _itemPicRepository.InsertAndGetIdAsync(pic); //var url = new Uri(new Uri(_appConfiguration["App:ImageUrlPrefix"]), Path.Combine(pic.Path, pic.FileName + pic.Extension)).ToString(); var url = _appConfiguration["App:ImageUrlPrefix"] + "/" + pic.Path + "/" + pic.FileName + pic.Extension; return(new UploadPictureOutputDto { Id = id, Url = url }); } catch { throw new UserFriendlyException("图片上传失败"); } }
private void BindPic() { ItemPic entity = new ItemPic(); entity.MainID = HTDataID; entity.Seq = 1; entity.SelectByID(); if (entity.PicImage != null) { pictureBox1.Image = TemplatePic.ByteToImage(entity.PicImage); } else { pictureBox1.Image = null; } }
/// <summary> /// 修改 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Update(BaseEntity p_Entity) { try { ItemPic MasterEntity = (ItemPic)p_Entity; if (MasterEntity.MainID == 0) { return(0); } //更新主表数据 StringBuilder UpdateBuilder = new StringBuilder(); UpdateBuilder.Append("UPDATE Data_ItemPic SET "); UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ","); UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ","); UpdateBuilder.Append(" PicImage=@PicImage" + ","); UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark)); UpdateBuilder.Append(" WHERE " + "MainID=" + SysString.ToDBString(MasterEntity.MainID) + " AND Seq=" + SysString.ToDBString(MasterEntity.Seq)); object[,] obja = new object[2, 1]; obja[0, 0] = "@PicImage"; obja[1, 0] = MasterEntity.PicImage; //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString(), obja); } else { AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString(), obja); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E); } }
/// <summary> /// 删除 /// </summary> /// <param name="p_BE">要删除的实体</param> /// <param name="sqlTrans">事务类</param> public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); ItemPic entity = (ItemPic)p_BE; ItemPicCtl control = new ItemPicCtl(sqlTrans); control.Delete(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
private ItemPic[] GetItemPic() { ItemPic[] entity = new ItemPic[1]; for (int i = 0; i < 1; i++) { entity[i] = new ItemPic(); entity[i].MainID = HTDataID; entity[i].Seq = i + 1; entity[i].SelectByID(); if (i == 0) { entity[i].PicImage = TemplatePic.ImageToByte(pictureBox1.Image); } } return(entity); }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); ItemPic entity = (ItemPic)p_BE; ItemPicCtl control = new ItemPicCtl(sqlTrans); //entity.ID=(int)EntityIDTable.GetID((long)SysEntity.Data_ItemPic,sqlTrans); control.AddNew(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 检查将要操作的数据是否符合业务规则 /// </summary> /// <param name="p_BE"></param> private void CheckCorrect(BaseEntity p_BE) { ItemPic entity = (ItemPic)p_BE; }
/// <summary> /// 修改 /// </summary> /// <param name="p_BE">要修改的实体</param> /// <param name="sqlTrans">事务类</param> public void RUpdate(BaseEntity p_BE, BaseEntity[] p_BE2, BaseEntity[] p_BE3, BaseEntity[] p_BE4, BaseEntity[] p_BE5, int Flag, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); Item entity = (Item)p_BE; string sql = "SELECT ItemCode FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entity.ItemCode) + " AND ID<>" + entity.ID; DataTable dt = sqlTrans.Fill(sql); if (dt.Rows.Count > 0) { throw new BaseException("编码已存在,请重新生成"); } ItemCtl control = new ItemCtl(sqlTrans); control.Update(entity); ItemColorDtsRule rule2 = new ItemColorDtsRule(); rule2.RSave(entity, p_BE2, sqlTrans); if (p_BE3.Length > 0) { sql = "DELETE Data_ItemAdd WHERE MainID=" + SysString.ToDBString(entity.ID); sql += " AND ISNULL(FormID,0)=" + SysString.ToDBString(((ItemAdd)p_BE3[0]).FormID); sql += " AND ISNULL(FormAID,0)=" + SysString.ToDBString(((ItemAdd)p_BE3[0]).FormAID); sql += " AND ISNULL(FormBID,0)=" + SysString.ToDBString(((ItemAdd)p_BE3[0]).FormBID); sqlTrans.ExecuteNonQuery(sql); } ItemAddRule ruleItemAdd = new ItemAddRule(); for (int i = 0; i < p_BE3.Length; i++) { ItemAdd entityDts = (ItemAdd)p_BE3[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemAdd.RAdd(entityDts, sqlTrans); ruleItemAdd.UpdateFiledSet(entity.ID, entityDts.FiledSetID, entityDts.Value, sqlTrans); } sql = "DELETE Data_ItemPic WHERE MainID=" + SysString.ToDBString(entity.ID); sqlTrans.ExecuteNonQuery(sql); ItemPicRule ruleItemPic = new ItemPicRule(); for (int i = 0; i < p_BE4.Length; i++) { ItemPic entityDts = (ItemPic)p_BE4[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemPic.RAdd(entityDts, sqlTrans); } sql = "DELETE Data_ItemCodeFacDts WHERE MainID=" + SysString.ToDBString(entity.ID); sqlTrans.ExecuteNonQuery(sql); ItemCodeFacDtsRule ruleItemCodeFac = new ItemCodeFacDtsRule(); for (int i = 0; i < p_BE5.Length; i++) { ItemCodeFacDts entityDts = (ItemCodeFacDts)p_BE5[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemCodeFac.RAdd(entityDts, sqlTrans); } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 修改 /// </summary> /// <param name="p_BE">要修改的实体</param> /// <param name="sqlTrans">事务类</param> public void RUpdate(BaseEntity p_BE, BaseEntity[] p_BE2, BaseEntity[] p_BE3, BaseEntity[] p_BE4, int p_Flag, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); Item entity = (Item)p_BE; string sql = "SELECT ItemCode FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entity.ItemCode) + " AND ID<>" + entity.ID; DataTable dt = sqlTrans.Fill(sql); if (dt.Rows.Count > 0) { throw new BaseException("编码已存在,请重新生成"); } ItemCtl control = new ItemCtl(sqlTrans); control.Update(entity); ItemColorDtsRule rule2 = new ItemColorDtsRule(); rule2.RSave(entity, p_BE2, sqlTrans); if (p_BE3.Length > 0) { sql = "DELETE Data_ItemAdd WHERE MainID=" + SysString.ToDBString(entity.ID); sql += " AND ISNULL(FormID,0)=" + SysString.ToDBString(((ItemAdd)p_BE3[0]).FormID); sql += " AND ISNULL(FormAID,0)=" + SysString.ToDBString(((ItemAdd)p_BE3[0]).FormAID); sql += " AND ISNULL(FormBID,0)=" + SysString.ToDBString(((ItemAdd)p_BE3[0]).FormBID); sqlTrans.ExecuteNonQuery(sql); } ItemAddRule ruleItemAdd = new ItemAddRule(); for (int i = 0; i < p_BE3.Length; i++) { ItemAdd entityDts = (ItemAdd)p_BE3[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemAdd.RAdd(entityDts, sqlTrans); ruleItemAdd.UpdateFiledSet(entity.ID, entityDts.FiledSetID, entityDts.Value, sqlTrans); } sql = "DELETE Data_ItemPic WHERE MainID=" + SysString.ToDBString(entity.ID); sqlTrans.ExecuteNonQuery(sql); ItemPicRule ruleItemPic = new ItemPicRule(); for (int i = 0; i < p_BE4.Length; i++) { ItemPic entityDts = (ItemPic)p_BE4[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; ruleItemPic.RAdd(entityDts, sqlTrans); } #region cost自动计算 entity = new Item(sqlTrans); entity.ID = ((Item)p_BE).ID; entity.SelectByID(); decimal Cost = 0; decimal PBPrice = entity.PBPrice;//坯价格 decimal RShrinkage = GetDecimalByString(entity.RShrinkage, '%'); decimal RSAmount = entity.RSAmount; decimal RSSH = GetDecimalByString(entity.RSSH, '%'); decimal JGAmount = entity.JGAmount; decimal JGSH = GetDecimalByString(entity.JGSH, '%'); decimal HZAmount = entity.HZAmount; decimal ProfitMargin = GetDecimalByString(entity.ProfitMargin, '%'); decimal Quot = GetDecimalByString(entity.COST, '/') * (1m + (ProfitMargin / 100m)); Cost = (((PBPrice * (1m + (RShrinkage / 100m)) + RSAmount) * (1m + (RSSH / 100m)) + JGAmount) * (1m + (JGSH / 100m)) + HZAmount) * 1.06m + 0.2m; Cost = SysConvert.ToDecimal(Cost, 2); //Quot = SysConvert.ToDecimal(Quot, 2); sql = "UPDATE Data_Item SET COSTA=" + SysString.ToDBString(Cost.ToString() + "/M"); //sql += ",QUOT="+SysString.ToDBString(Quot.ToString()+"/M"); sql += " WHERE ID=" + SysString.ToDBString(entity.ID); sqlTrans.ExecuteNonQuery(sql); sql = "UPDATE Data_ItemAdd SET Value=" + SysString.ToDBString(Cost.ToString() + "/M"); sql += " WHERE FiledName='COSTA'";// +SysString.ToDBString(entity.ID); sql += " AND MainID=" + SysString.ToDBString(entity.ID); sqlTrans.ExecuteNonQuery(sql); //sql = "UPDATE Data_ItemAdd SET Value=" + SysString.ToDBString(Quot.ToString() + "/M"); //sql += " WHERE FiledName='QUOT'";// +SysString.ToDBString(entity.ID); //sql += " AND MainID=" + SysString.ToDBString(entity.ID); //sqlTrans.ExecuteNonQuery(sql); #endregion } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }