/// <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;
}
}
