public int Add(FishEntity.EnterWarehouseReceipts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_enterwarehousereceipts("); strSql.Append("code,Requester,Shipname,tonnage,tName,Billnumber,NumberOfPieces,Unpackingdate,actualnumber,StorageLocation,position,Remarks,createtime,createman,modifytime,modifyman,TO1,TEL1,ANTI1,FAX1,ContractNo,Zhuangjiao)"); strSql.Append("values("); strSql.Append("@code,@Requester,@Shipname,@tonnage,@tName,@Billnumber,@NumberOfPieces,@Unpackingdate,@actualnumber,@StorageLocation,@position,@Remarks,@createtime,@createman,@modifytime,@modifyman,@TO1,@TEL1,@ANTI1,@FAX1,@ContractNo,@Zhuangjiao);"); strSql.Append("select last_insert_id();"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@Requester", MySqlDbType.VarChar, 45), new MySqlParameter("@Shipname", MySqlDbType.VarChar, 45), new MySqlParameter("@tonnage", MySqlDbType.Decimal, 45), new MySqlParameter("@tName", MySqlDbType.VarChar, 45), new MySqlParameter("@Billnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@NumberOfPieces", MySqlDbType.Decimal, 45), new MySqlParameter("@Unpackingdate", MySqlDbType.DateTime), new MySqlParameter("@actualnumber", MySqlDbType.Decimal, 45), new MySqlParameter("@StorageLocation", MySqlDbType.VarChar, 45), new MySqlParameter("@position", MySqlDbType.VarChar, 200), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 100), new MySqlParameter("@createtime", MySqlDbType.Timestamp), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@TO1", MySqlDbType.VarChar, 45), new MySqlParameter("@TEL1", MySqlDbType.VarChar, 45), new MySqlParameter("@ANTI1", MySqlDbType.VarChar, 45), new MySqlParameter("@FAX1", MySqlDbType.VarChar, 45), new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45), new MySqlParameter("@Zhuangjiao", MySqlDbType.VarChar, 45) }; parameters[0].Value = model.Code; parameters[1].Value = model.Requester; parameters[2].Value = model.Shipname; parameters[3].Value = model.Tonnage; parameters[4].Value = model.TName; parameters[5].Value = model.Billnumber; parameters[6].Value = model.NumberOfPieces; parameters[7].Value = model.Unpackingdate; parameters[8].Value = model.Actualnumber; parameters[9].Value = model.StorageLocation; parameters[10].Value = model.Position; parameters[11].Value = model.Remarks; parameters[12].Value = model.Createtime; parameters[13].Value = model.Createman; parameters[14].Value = model.Modifytime; parameters[15].Value = model.Modifyman; parameters[16].Value = model.TO; parameters[17].Value = model.TEL; parameters[18].Value = model.ANTI; parameters[19].Value = model.FAX; parameters[20].Value = model.ContractNo; parameters[21].Value = model.Zhuangjiao; int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters); //MySqlHelper.ExecuteSql(strSql.ToString(), parameters); return(id); }
public override int Query() { panel1.Enabled = true; if (_Form == null) { _Form = new UIForms.FormEnterWarehouseReceiptsCodition(); _Form.StartPosition = FormStartPosition.CenterParent; _Form.ShowInTaskbar = false; } if (_Form.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return(0); } _where = _Form.GetWhereCondition; List <FishEntity.EnterWarehouseReceipts> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy); if (list == null || list.Count < 1) { _fish = null; return(1); } else { _fish = list[0]; SetOnepound(); } return(1); }
public override void Save() { FishEntity.EnterWarehouseReceipts _fish = new FishEntity.EnterWarehouseReceipts(); _fish.Code = FishBll.Bll.SequenceUtil.GetEnterWarehouseReceipts(); decimal temp = 0; _fish.Requester = txtRequester.Text.Trim(); _fish.Shipname = txtShipname.Text.Trim(); decimal.TryParse(txttonnage.Text, out temp); _fish.Tonnage = temp; _fish.TName = cmbtName.SelectedValue == null ? string.Empty : cmbtName.SelectedValue.ToString().Trim(); _fish.Billnumber = txtBillnumber.Text; decimal.TryParse(txtNumberOfPieces.Text, out temp); _fish.NumberOfPieces = temp; _fish.Unpackingdate = dtpUnpackingdate.Value; decimal.TryParse(txtactualnumber.Text, out temp); _fish.Actualnumber = temp; _fish.StorageLocation = txtStorageLocation.Text.Trim(); _fish.Position = txtposition.Text.Trim(); _fish.Remarks = txtRemarks.Text.Trim(); _fish.Createtime = DateTime.Now; _fish.Createman = FishEntity.Variable.User.username; _fish.Modifytime = DateTime.Now; _fish.Modifyman = FishEntity.Variable.User.username; _fish.TO = txtTO.Text.Trim(); _fish.Zhuangjiao = txtZhuangjiao.Text; _fish.ContractNo = txtContractNo.Text; _fish.TEL = txtTEL.Text.Trim(); _fish.ANTI = txtANTI.Text.Trim(); _fish.FAX = txtFAX.Text.Trim(); FishBll.Bll.EnterWarehouseReceiptsBll bll = new FishBll.Bll.EnterWarehouseReceiptsBll(); bool isok = bll.Exists(_fish.Code); while (isok) { _fish.Code = FishBll.Bll.SequenceUtil.GetEnterWarehouseReceipts(); isok = bll.Exists(_fish.Code); } int id = bll.Add(_fish); if (id > 0) { _fish.Id = id; tmiQuery.Visible = false; tmiDelete.Visible = false; tmiModify.Visible = false; tmiAdd.Visible = false; tmiSave.Visible = true; tmiCancel.Visible = true; MessageBox.Show("添加成功。"); txtcode.Text = _fish.Code.ToString(); } else { // txtCode.Text = _fish.Code; MessageBox.Show("添加失败。"); } }
protected void QueryOne(string operate, string orderBy) { string whereEx = string.Empty; if (string.IsNullOrEmpty(_where)) { whereEx = " 1=1 "; } else { whereEx = _where; } if (_entity != null) { whereEx += " and code " + operate + _entity.code; } List <FishEntity.EnterWarehouseReceipts> list = _bll.GetModelListVo(whereEx + orderBy); if (list == null || list.Count < 1) { MessageBox.Show("已经没有记录了!"); return; } _entity = list [0]; SetOnepound( ); }
public int Add(FishEntity.EnterWarehouseReceipts model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into t_enterwarehousereceipts("); strSql.Append("code,fishId,codeNum,codeNumContract,deliverybills,proName,numOfPack,qualitySpe,TVN,sand,TEL,TO,enUntil,country,number,location,protein,fat,water,fax,anti,shipno,brand,downDate,locationDis,za,hf,shy,remark,createtime,createman,modifyman,modifytime,height))"); strSql.Append(" values ("); strSql.Append("@code,@fishId,@codeNum,@codeNumContract,@deliverybills,@proName,@numOfPack,@qualitySpe,@TVN,@sand,@TEL,@TO,@enUntil,@country,@number,@location,@protein,@fat,@water,@fax,@anti,@shipno,@brand,@downDate,@locationDis,@za,@hf,@shy,@remark,@createtime,@createman,@modifyman,@modifytime,@height);"); strSql.Append("select LAST_INSERT_ID();"); MySqlParameter [] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@fishId", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 50), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45), new MySqlParameter("@deliverybills", MySqlDbType.VarChar, 45), new MySqlParameter("@proName", MySqlDbType.VarChar, 100), new MySqlParameter("@numOfPack", MySqlDbType.Int32, 11), new MySqlParameter("@qualitySpe", MySqlDbType.VarChar, 45), new MySqlParameter("@TVN", MySqlDbType.VarChar, 50), new MySqlParameter("@sand", MySqlDbType.VarChar, 50), new MySqlParameter("@TEL", MySqlDbType.VarChar, 50), new MySqlParameter("@TO", MySqlDbType.VarChar, 50), new MySqlParameter("@enUntil", MySqlDbType.VarChar, 50), new MySqlParameter("@country", MySqlDbType.VarChar, 50), new MySqlParameter("@number", MySqlDbType.Int32, 11), new MySqlParameter("@location", MySqlDbType.VarChar, 200), new MySqlParameter("@protein", MySqlDbType.VarChar, 50), new MySqlParameter("@fat", MySqlDbType.VarChar, 50), new MySqlParameter("@water", MySqlDbType.VarChar, 50), new MySqlParameter("@fax", MySqlDbType.VarChar, 50), new MySqlParameter("@anti", MySqlDbType.VarChar, 50), new MySqlParameter("@shipno", MySqlDbType.VarChar, 45), new MySqlParameter("@brand", MySqlDbType.VarChar, 50), new MySqlParameter("@downDate", MySqlDbType.Date), new MySqlParameter("@locationDis", MySqlDbType.VarChar, 50), new MySqlParameter("@za", MySqlDbType.VarChar, 50), new MySqlParameter("@hf", MySqlDbType.VarChar, 50), new MySqlParameter("@shy", MySqlDbType.VarChar, 50), new MySqlParameter("@remark", MySqlDbType.VarChar, 50), new MySqlParameter("@createtime", MySqlDbType.Timestamp), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@height", MySqlDbType.Decimal) }; parameters [0].Value = model.code; parameters [1].Value = model.fishId; parameters [2].Value = model.codeNum; parameters [3].Value = model.codeNumContract; parameters [4].Value = model.deliverybills; parameters [5].Value = model.proName; parameters [6].Value = model.numOfPack; parameters [7].Value = model.qualitySpe; parameters [8].Value = model.TVN; parameters [9].Value = model.sand; parameters [10].Value = model.TEL; parameters [11].Value = model.TO; parameters [12].Value = model.enUntil; parameters [13].Value = model.country; parameters [14].Value = model.number; parameters [15].Value = model.location; parameters [16].Value = model.protein; parameters [17].Value = model.fat; parameters [18].Value = model.water; parameters [19].Value = model.fax; parameters [20].Value = model.anti; parameters [21].Value = model.shipno; parameters [22].Value = model.brand; parameters [23].Value = model.downDate; parameters [24].Value = model.locationDis; parameters [25].Value = model.za; parameters [26].Value = model.hf; parameters [27].Value = model.shy; parameters [28].Value = model.remark; parameters [29].Value = model.createtime; parameters [30].Value = model.createman; parameters [31].Value = model.modifyman; parameters [32].Value = model.modifytime; parameters [33].Value = model.height; int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters); return(id); }
public List <FishEntity.EnterWarehouseReceipts> GetModelListVo(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from t_enterwarehousereceipts "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = MySqlHelper.Query(strSql.ToString()); List <FishEntity.EnterWarehouseReceipts> modelList = new List <FishEntity.EnterWarehouseReceipts>(); int rowsCount = ds.Tables[0].Rows.Count; FishEntity.EnterWarehouseReceipts model; for (int n = 0; n < rowsCount; n++) { DataRow row = ds.Tables[0].Rows[n]; model = new FishEntity.EnterWarehouseReceipts(); if (row ["id"] != null && row ["id"].ToString( ) != "") { model.id = int.Parse(row ["id"].ToString( )); } if (row ["code"] != null) { model.code = row ["code"].ToString( ); } if (row ["fishId"] != null) { model.fishId = row ["fishId"].ToString( ); } if (row ["codeNum"] != null) { model.codeNum = row ["codeNum"].ToString( ); } if (row ["codeNumContract"] != null) { model.codeNumContract = row ["codeNumContract"].ToString( ); } if (row ["deliverybills"] != null) { model.deliverybills = row ["deliverybills"].ToString( ); } if (row ["proName"] != null) { model.proName = row ["proName"].ToString( ); } if (row ["numOfPack"] != null && row ["numOfPack"].ToString( ) != "") { model.numOfPack = int.Parse(row ["numOfPack"].ToString( )); } if (row ["qualitySpe"] != null) { model.qualitySpe = row ["qualitySpe"].ToString( ); } if (row ["TVN"] != null) { model.TVN = row ["TVN"].ToString( ); } if (row ["sand"] != null) { model.sand = row ["sand"].ToString( ); } if (row ["TEL"] != null) { model.TEL = row ["TEL"].ToString( ); } if (row ["TO"] != null) { model.TO = row ["TO"].ToString( ); } if (row ["enUntil"] != null) { model.enUntil = row ["enUntil"].ToString( ); } if (row ["country"] != null) { model.country = row ["country"].ToString( ); } if (row ["number"] != null && row ["number"].ToString( ) != "") { model.number = int.Parse(row ["number"].ToString( )); } if (row ["height"] != null && row ["height"].ToString( ) != "") { model.height = decimal.Parse(row ["height"].ToString( )); } if (row ["location"] != null) { model.location = row ["location"].ToString( ); } if (row ["protein"] != null) { model.protein = row ["protein"].ToString( ); } if (row ["fat"] != null) { model.fat = row ["fat"].ToString( ); } if (row ["water"] != null) { model.water = row ["water"].ToString( ); } if (row ["fax"] != null) { model.fax = row ["fax"].ToString( ); } if (row ["anti"] != null) { model.anti = row ["anti"].ToString( ); } if (row ["shipno"] != null) { model.shipno = row ["shipno"].ToString( ); } if (row ["brand"] != null) { model.brand = row ["brand"].ToString( ); } if (row ["downDate"] != null && row ["downDate"].ToString( ) != "") { model.downDate = DateTime.Parse(row ["downDate"].ToString( )); } if (row ["locationDis"] != null) { model.locationDis = row ["locationDis"].ToString( ); } if (row ["za"] != null) { model.za = row ["za"].ToString( ); } if (row ["hf"] != null) { model.hf = row ["hf"].ToString( ); } if (row ["shy"] != null) { model.shy = row ["shy"].ToString( ); } if (row ["remark"] != null) { model.remark = row ["remark"].ToString( ); } if (row ["createtime"] != null && row ["createtime"].ToString( ) != "") { model.createtime = DateTime.Parse(row ["createtime"].ToString( )); } if (row ["createman"] != null) { model.createman = row ["createman"].ToString( ); } if (row ["modifyman"] != null) { model.modifyman = row ["modifyman"].ToString( ); } if (row ["modifytime"] != null && row ["modifytime"].ToString( ) != "") { model.modifytime = DateTime.Parse(row ["modifytime"].ToString( )); } if (row ["isdelete"] != null && row ["isdelete"].ToString( ) != "") { model.isdelete = int.Parse(row ["isdelete"].ToString( )); } modelList.Add(model); } return(modelList); }
public bool Update(FishEntity.EnterWarehouseReceipts model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update t_enterwarehousereceipts set "); strSql.Append("code=@code,"); strSql.Append("fishId=@fishId,"); strSql.Append("codeNum=@codeNum,"); strSql.Append("codeNumContract=@codeNumContract,"); strSql.Append("deliverybills=@deliverybills,"); strSql.Append("proName=@proName,"); strSql.Append("numOfPack=@numOfPack,"); strSql.Append("qualitySpe=@qualitySpe,"); strSql.Append("TVN=@TVN,"); strSql.Append("sand=@sand,"); strSql.Append("TEL=@TEL,"); strSql.Append("TO=@TO,"); strSql.Append("enUntil=@enUntil,"); strSql.Append("country=@country,"); strSql.Append("number=@number,"); strSql.Append("location=@location,"); strSql.Append("protein=@protein,"); strSql.Append("fat=@fat,"); strSql.Append("water=@water,"); strSql.Append("fax=@fax,"); strSql.Append("anti=@anti,"); strSql.Append("shipno=@shipno,"); strSql.Append("brand=@brand,"); strSql.Append("downDate=@downDate,"); strSql.Append("locationDis=@locationDis,"); strSql.Append("za=@za,"); strSql.Append("hf=@hf,"); strSql.Append("shy=@shy,"); strSql.Append("remark=@remark,"); strSql.Append("height=@height,"); strSql.Append("createman=@createman,"); strSql.Append("modifyman=@modifyman "); strSql.Append(" where id=@id"); MySqlParameter [] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@fishId", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 50), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45), new MySqlParameter("@deliverybills", MySqlDbType.VarChar, 45), new MySqlParameter("@proName", MySqlDbType.VarChar, 100), new MySqlParameter("@numOfPack", MySqlDbType.Int32, 11), new MySqlParameter("@qualitySpe", MySqlDbType.VarChar, 45), new MySqlParameter("@TVN", MySqlDbType.VarChar, 50), new MySqlParameter("@sand", MySqlDbType.VarChar, 50), new MySqlParameter("@TEL", MySqlDbType.VarChar, 50), new MySqlParameter("@TO", MySqlDbType.VarChar, 50), new MySqlParameter("@enUntil", MySqlDbType.VarChar, 50), new MySqlParameter("@country", MySqlDbType.VarChar, 50), new MySqlParameter("@number", MySqlDbType.Int32, 11), new MySqlParameter("@location", MySqlDbType.VarChar, 200), new MySqlParameter("@protein", MySqlDbType.VarChar, 50), new MySqlParameter("@fat", MySqlDbType.VarChar, 50), new MySqlParameter("@water", MySqlDbType.VarChar, 50), new MySqlParameter("@fax", MySqlDbType.VarChar, 50), new MySqlParameter("@anti", MySqlDbType.VarChar, 50), new MySqlParameter("@shipno", MySqlDbType.VarChar, 45), new MySqlParameter("@brand", MySqlDbType.VarChar, 50), new MySqlParameter("@downDate", MySqlDbType.Date), new MySqlParameter("@locationDis", MySqlDbType.VarChar, 50), new MySqlParameter("@za", MySqlDbType.VarChar, 50), new MySqlParameter("@hf", MySqlDbType.VarChar, 50), new MySqlParameter("@shy", MySqlDbType.VarChar, 50), new MySqlParameter("@remark", MySqlDbType.VarChar, 50), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@height", MySqlDbType.Decimal, 45), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters [0].Value = model.code; parameters [1].Value = model.fishId; parameters [2].Value = model.codeNum; parameters [3].Value = model.codeNumContract; parameters [4].Value = model.deliverybills; parameters [5].Value = model.proName; parameters [6].Value = model.numOfPack; parameters [7].Value = model.qualitySpe; parameters [8].Value = model.TVN; parameters [9].Value = model.sand; parameters [10].Value = model.TEL; parameters [11].Value = model.TO; parameters [12].Value = model.enUntil; parameters [13].Value = model.country; parameters [14].Value = model.number; parameters [15].Value = model.location; parameters [16].Value = model.protein; parameters [17].Value = model.fat; parameters [18].Value = model.water; parameters [19].Value = model.fax; parameters [20].Value = model.anti; parameters [21].Value = model.shipno; parameters [22].Value = model.brand; parameters [23].Value = model.downDate; parameters [24].Value = model.locationDis; parameters [25].Value = model.za; parameters [26].Value = model.hf; parameters [27].Value = model.shy; parameters [28].Value = model.remark; parameters [29].Value = model.createman; parameters [30].Value = model.modifyman; parameters [31].Value = model.height; parameters [32].Value = model.id; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Update(FishEntity.EnterWarehouseReceipts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_enterwarehousereceipts set "); strSql.Append("code = @code,"); strSql.Append("Requester = @Requester,"); strSql.Append("Shipname = @Shipname,"); strSql.Append("tonnage = @tonnage,"); strSql.Append("tName = @tName,"); strSql.Append("Billnumber = @Billnumber,"); strSql.Append("NumberOfPieces = @NumberOfPieces,"); strSql.Append("Unpackingdate = @Unpackingdate,"); strSql.Append("actualnumber = @actualnumber,"); strSql.Append("StorageLocation = @StorageLocation,"); strSql.Append("position = @position,"); strSql.Append("Remarks = @Remarks,"); strSql.Append("modifytime = @modifytime,"); strSql.Append("modifyman = @modifyman,"); strSql.Append("TO1 = @TO1,"); strSql.Append("TEL1 = @TEL1,"); strSql.Append("ANTI1 = @ANTI1,"); strSql.Append("FAX1 = @FAX1, "); strSql.Append("ContractNo=@ContractNo, "); strSql.Append("Zhuangjiao=@Zhuangjiao "); strSql.Append("where id = @id"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@Requester", MySqlDbType.VarChar, 45), new MySqlParameter("@Shipname", MySqlDbType.VarChar, 45), new MySqlParameter("@tonnage", MySqlDbType.Decimal, 45), new MySqlParameter("@tName", MySqlDbType.VarChar, 45), new MySqlParameter("@Billnumber", MySqlDbType.VarChar, 45), new MySqlParameter("@NumberOfPieces", MySqlDbType.Decimal, 45), new MySqlParameter("@Unpackingdate", MySqlDbType.DateTime), new MySqlParameter("@actualnumber", MySqlDbType.Decimal, 45), new MySqlParameter("@StorageLocation", MySqlDbType.VarChar, 45), new MySqlParameter("@position", MySqlDbType.VarChar, 200), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 100), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@TO1", MySqlDbType.VarChar, 45), new MySqlParameter("@TEL1", MySqlDbType.VarChar, 45), new MySqlParameter("@ANTI1", MySqlDbType.VarChar, 45), new MySqlParameter("@FAX1", MySqlDbType.VarChar, 45), new MySqlParameter("@id", MySqlDbType.VarChar, 11), new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45), new MySqlParameter("@Zhuangjiao", MySqlDbType.VarChar, 45) }; parameters[0].Value = model.Code; parameters[1].Value = model.Requester; parameters[2].Value = model.Shipname; parameters[3].Value = model.Tonnage; parameters[4].Value = model.TName; parameters[5].Value = model.Billnumber; parameters[6].Value = model.NumberOfPieces; parameters[7].Value = model.Unpackingdate; parameters[8].Value = model.Actualnumber; parameters[9].Value = model.StorageLocation; parameters[10].Value = model.Position; parameters[11].Value = model.Remarks; parameters[12].Value = model.Modifytime; parameters[13].Value = model.Modifyman; parameters[14].Value = model.TO; parameters[15].Value = model.TEL; parameters[16].Value = model.ANTI; parameters[17].Value = model.FAX; parameters[18].Value = model.Id; parameters[19].Value = model.ContractNo; parameters[20].Value = model.Zhuangjiao; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public List <FishEntity.EnterWarehouseReceipts> GetModelListVo(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from t_enterwarehousereceipts "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = MySqlHelper.Query(strSql.ToString()); List <FishEntity.EnterWarehouseReceipts> modelList = new List <FishEntity.EnterWarehouseReceipts>(); int rowsCount = ds.Tables[0].Rows.Count; FishEntity.EnterWarehouseReceipts model; for (int n = 0; n < rowsCount; n++) { DataRow row = ds.Tables[0].Rows[n]; model = new FishEntity.EnterWarehouseReceipts(); if (row["id"].ToString() != "") { model.Id = int.Parse(row["id"].ToString()); } if (row["code"] != null && row["code"].ToString() != "") { model.Code = row["code"].ToString(); } if (row["Requester"].ToString() != "" && row["Requester"] != null) { model.Requester = row["Requester"].ToString(); } if (row["Shipname"] != null && row["Shipname"].ToString() != "") { model.Shipname = row["Shipname"].ToString(); } if (row["tonnage"] != null && row["tonnage"].ToString() != "") { model.Tonnage = decimal.Parse(row["tonnage"].ToString()); } if (row["tName"] != null && row["tName"].ToString() != "") { model.TName = row["tName"].ToString(); } if (row["Billnumber"] != null && row["Billnumber"].ToString() != "") { model.Billnumber = row["Billnumber"].ToString(); } if (row["NumberOfPieces"] != null && row["NumberOfPieces"].ToString() != "") { model.NumberOfPieces = decimal.Parse(row["NumberOfPieces"].ToString()); } if (row["Unpackingdate"] != null && row["Unpackingdate"].ToString() != "") { model.Unpackingdate = DateTime.Parse(row["Unpackingdate"].ToString()); } if (row["actualnumber"] != null && row["actualnumber"].ToString() != "") { model.Actualnumber = decimal.Parse(row["actualnumber"].ToString()); } if (row["StorageLocation"] != null && row["StorageLocation"].ToString() != "") { model.StorageLocation = row["StorageLocation"].ToString(); } if (row["position"] != null && row["position"].ToString() != "") { model.Position = row["position"].ToString(); } if (row["Remarks"] != null && row["Remarks"].ToString() != "") { model.Remarks = row["Remarks"].ToString(); } if (row["TO1"] != null && row["TO1"].ToString() != "") { model.TO = row["TO1"].ToString(); } if (row["TEL1"] != null && row["TEL1"].ToString() != "") { model.TEL = row["TEL1"].ToString(); } if (row["ANTI1"] != null && row["ANTI1"].ToString() != "") { model.ANTI = row["ANTI1"].ToString(); } if (row["FAX1"] != null && row["FAX1"].ToString() != "") { model.FAX = row["FAX1"].ToString(); } if (row["ContractNo"] != null) { model.ContractNo = row["ContractNo"].ToString(); } if (row["Zhuangjiao"] != null) { model.Zhuangjiao = row["Zhuangjiao"].ToString(); } modelList.Add(model); } return(modelList); }
public bool Update(FishEntity.EnterWarehouseReceipts model) { return(dal.Update(model)); }
public int Add(FishEntity.EnterWarehouseReceipts model) { return(dal.Add(model)); }
public override void Save() { if (Check( ) == false) { return; } FishEntity.EnterWarehouseReceipts _fish = new FishEntity.EnterWarehouseReceipts(); int temp = 0; _entity.anti = txtanti.Text; //_entity . code = txtCode . Text; _entity.codeNum = txtcodeNum.Text; _entity.codeNumContract = txtcodeNumContract.Text; _entity.deliverybills = txtdeliverybills.Text; _entity.enUntil = txtenUntil.Text; _entity.fat = txtfat.Text; _entity.fax = txtfax.Text; _entity.fishId = txtfishId.Text; _entity.hf = txthf.Text; _entity.location = txtlocation.Text; _entity.locationDis = txtlocationDis.Text; int.TryParse(txtnumber.Text, out temp); _entity.number = temp; temp = 0; int.TryParse(txtnumOfPack.Text, out temp); _entity.numOfPack = temp; _entity.protein = txtprotein.Text; _entity.remark = txtremark.Text; _entity.sand = txtsand.Text; _entity.shipno = txtshipno.Text; _entity.shy = txtshy.Text; _entity.TEL = txtTEL.Text; _entity.TO = txtTO.Text; _entity.TVN = txtTVN.Text; _entity.water = txtwater.Text; _entity.za = txtza.Text; _entity.brand = cmbbrand.Text; _entity.country = cmbcountry.Text; _entity.proName = cmbproName.Text; _entity.qualitySpe = cmbqualitySpe.Text; _entity.downDate = dtdownDate.Value; decimal te = 0; decimal.TryParse(txtHeight.Text, out te); _entity.height = te; FishBll.Bll.EnterWarehouseReceiptsBll bll = new FishBll.Bll.EnterWarehouseReceiptsBll(); bool isok = bll.Exists(_entity.code); while (isok) { _entity.code = FishBll.Bll.SequenceUtil.GetEnterWarehouseReceipts(); isok = bll.Exists(_entity.code); } int id = bll.Add(_fish); if (id > 0) { _entity.id = id; tmiQuery.Visible = false; tmiDelete.Visible = false; tmiModify.Visible = false; tmiAdd.Visible = false; tmiSave.Visible = true; tmiCancel.Visible = true; MessageBox.Show("添加成功。"); txtCode.Text = _entity.code.ToString(); } else { // txtCode.Text = _fish.Code; MessageBox.Show("添加失败。"); } }