public void GetTodayTotalWeight(FactoryArgs args, out t_Decimal SalesTotalWeight, out t_ID TotalCar) { DateTime dtFrom = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); DateTime dtTo = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1); SalesTotalWeight = new t_Decimal(0); TotalCar = new t_ID(0); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SalesTotalWeight", SalesTotalWeight, true)); parms.Add(new LBDbParameter("TotalCar", TotalCar, true)); parms.Add(new LBDbParameter("DTFrom", new t_DTSmall(dtFrom))); parms.Add(new LBDbParameter("DTTo", new t_DTSmall(dtTo))); string strSQL = @" select @SalesTotalWeight = sum(SuttleWeight/1000.0), @TotalCar = count(1) from dbo.SaleCarOutBill o inner join SaleCarInBill i on i.SaleCarInBillID = o.SaleCarInBillID where i.BillStatus = 2 and o.BillDate>=@DTFrom and o.BillDate<@DTTo "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); SalesTotalWeight.SetValueWithObject(parms["SalesTotalWeight"].Value); TotalCar.SetValueWithObject(parms["TotalCar"].Value); }
public void GetInsideCarCount(FactoryArgs args, out t_ID CarCount) { CarCount = new t_ID(0); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CarCount", CarCount, true)); string strSQL = @" select @CarCount = sum(1) from dbo.View_SaleCarInOutBill where SaleCarOutBillID is null and isnull(IsCancel,0) = 0 "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); CarCount.SetValueWithObject(parms["CarCount"].Value); }
public void Update(FactoryArgs args, t_String SysConfigFieldName, t_String SysConfigValue) { t_ID SysConfigDataType = new t_ID(0);//0字符串 1小数 2整数 3布尔值 t_String SysConfigFieldText = new t_String(""); using (DataTable dtConfig = _DALDbSysConfig.GetDbSysConfigField(args, SysConfigFieldName)) { if (dtConfig.Rows.Count == 0) { throw new Exception("该系统设置无效!"); } else { DataRow drConfig = dtConfig.Rows[0]; SysConfigDataType.SetValueWithObject(drConfig["SysConfigDataType"]); SysConfigFieldText.SetValueWithObject(drConfig["SysConfigFieldText"]); } } if (SysConfigDataType.Value == 1) { decimal decValue; if (!decimal.TryParse(SysConfigValue.Value, out decValue)) { throw new Exception("【" + SysConfigFieldText.Value + "】为小数类型,当前传入的值为【" + SysConfigValue.Value + "】,无法保存!"); } } if (SysConfigDataType.Value == 2) { int iValue; if (!int.TryParse(SysConfigValue.Value, out iValue)) { throw new Exception("【" + SysConfigFieldText.Value + "】为整数类型,当前传入的值为【" + SysConfigValue.Value + "】,无法保存!"); } } if (SysConfigDataType.Value == 3) { int iValue; if (!int.TryParse(SysConfigValue.Value, out iValue)) { throw new Exception("【" + SysConfigFieldText.Value + "】为布尔值类型,当前传入的值为【" + SysConfigValue.Value + "】,无法保存!"); } } _DALDbSysConfig.Update(args, SysConfigFieldName, SysConfigValue); }
public void ReadReceiveType(FactoryArgs args, t_BigID CustomerID, out t_ID ReceiveType) { ReceiveType = new t_ID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CustomerID", CustomerID)); parms.Add(new LBDbParameter("ReceiveType", ReceiveType, true)); string strSQL = @" select ReceiveType from dbo.DbCustomer where CustomerID = @CustomerID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); ReceiveType.SetValueWithObject(parms["ReceiveType"].Value); }
public void GetTodayTotalWeight(FactoryArgs args, out t_Decimal SalesTotalWeight, out t_ID TotalCar) { DateTime dtFrom = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); DateTime dtTo = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1); SalesTotalWeight = new t_Decimal(0); TotalCar = new t_ID(0); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SalesTotalWeight", SalesTotalWeight, true)); parms.Add(new LBDbParameter("TotalCar", TotalCar, true)); parms.Add(new LBDbParameter("DTFrom", new t_String(dtFrom.ToString("yyyy-MM-dd HH:mm:ss")))); parms.Add(new LBDbParameter("DTTo", new t_String(dtTo.ToString("yyyy-MM-dd HH:mm:ss")))); string strSQL = @" select sum(SuttleWeight/1000.0) as SalesTotalWeight,count(1) as TotalCar from SaleCarInBill i where i.IsCancel = 0 and i.BillDate>=@DTFrom and i.BillDate<@DTTo "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); SalesTotalWeight.SetValueWithObject(parms["SalesTotalWeight"].Value); TotalCar.SetValueWithObject(parms["TotalCar"].Value); }