/// <summary> /// �������ȫ��ú�����������־ /// </summary> /// <param name="AllAmountCode"></param> /// <param name="UpdateHMoney"></param> /// <param name="UpdateQMoney"></param> public void AddBatch(string CoalKindCode, decimal UpdateHMoney,string Operator) { CoalTraffic.Model.TDY_LogBalanceRestrictRejigger LBRRModel = new CoalTraffic.Model.TDY_LogBalanceRestrictRejigger(); TDY_CoalAccountManage CoalAM = new TDY_CoalAccountManage(); DataSet ds = DbHelperSQL.Query("select AmountCode from TDY_CoalAccountManage where CoalKindCode='" + CoalKindCode + "'"); //string[] allamountcode = sdr[0].ToString().Split(new string[] { "," }, StringSplitOptions.None); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { LBRRModel.AmountCode = ds.Tables[0].Rows[i][0].ToString(); LBRRModel.UpdateQMoney = decimal.Parse(CoalAM.GetCurrentLowAmount(LBRRModel.AmountCode)); LBRRModel.UpdateHMoney = UpdateHMoney; LBRRModel.Operator = Operator; LBRRModel.WorkTime = DateTime.Now; int icode = Add(LBRRModel); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public CoalTraffic.Model.TDY_LogBalanceRestrictRejigger GetModel(int BalanceRestrictRejiggerCode) { StringBuilder strSql=new StringBuilder(); strSql.Append("select * from TDY_LogBalanceRestrictRejigger "); strSql.Append(" where BalanceRestrictRejiggerCode=@BalanceRestrictRejiggerCode"); SqlParameter[] parameters = { new SqlParameter("@BalanceRestrictRejiggerCode", SqlDbType.Int,4)}; parameters[0].Value = BalanceRestrictRejiggerCode; CoalTraffic.Model.TDY_LogBalanceRestrictRejigger model=new CoalTraffic.Model.TDY_LogBalanceRestrictRejigger(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); model.BalanceRestrictRejiggerCode=BalanceRestrictRejiggerCode; if(ds.Tables[0].Rows.Count>0) { model.AmountCode=ds.Tables[0].Rows[0]["AmountCode"].ToString(); if(ds.Tables[0].Rows[0]["UpdateQMoney"].ToString()!="") { model.UpdateQMoney=decimal.Parse(ds.Tables[0].Rows[0]["UpdateQMoney"].ToString()); } if(ds.Tables[0].Rows[0]["UpdateHMoney"].ToString()!="") { model.UpdateHMoney=decimal.Parse(ds.Tables[0].Rows[0]["UpdateHMoney"].ToString()); } model.Operator=ds.Tables[0].Rows[0]["Operator"].ToString(); if(ds.Tables[0].Rows[0]["WorkTime"].ToString()!="") { model.WorkTime=DateTime.Parse(ds.Tables[0].Rows[0]["WorkTime"].ToString()); } return model; } else { return null; } }
/// <summary> /// �����������---����ú�� /// </summary> /// <param name="CoalKindCode"></param> /// <param name="LowAmount"></param> /// <returns></returns> public bool UpdateLowAmountAll(string CoalKindCode, decimal UpdateHMoney, string Operator) { CoalTraffic.Model.TDY_LogBalanceRestrictRejigger LBRRModel = new CoalTraffic.Model.TDY_LogBalanceRestrictRejigger(); TDY_LogBalanceRestrictRejigger LBRR = new TDY_LogBalanceRestrictRejigger(); try { DataSet ds = DbHelperSQL.Query("select AmountCode,CollCode from TDY_CoalAccountManage where CoalKindCode='" + CoalKindCode + "'"); //string[] allamountcode = sdr[0].ToString().Split(new string[] { "," }, StringSplitOptions.None); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { LBRRModel.AmountCode = ds.Tables[0].Rows[i][0].ToString(); LBRRModel.UpdateQMoney = decimal.Parse(GetCurrentLowAmount(LBRRModel.AmountCode)); LBRRModel.UpdateHMoney = UpdateHMoney; LBRRModel.Operator = Operator; LBRRModel.WorkTime = DateTime.Now; bool ibool = UpdateLowAmount(CoalKindCode, UpdateHMoney, ds.Tables[0].Rows[i][1].ToString()); int icode = LBRR.Add(LBRRModel); } ds.Dispose(); return true; } catch (Exception ex) { throw ex; } }