/// <summary> /// ����һ������ /// </summary> public int Add(CoalTraffic.Model.TDYN_NoteHistory model) { //model.NoteCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDYN_NoteHistory("); strSql.Append("NameplateCode,PhoneNumber,SMSText,HistoryTime,SendTime,SendState)"); strSql.Append(" values ("); strSql.Append("@NameplateCode,@PhoneNumber,@SMSText,@HistoryTime,@SendTime,@SendState)"); SqlParameter[] parameters = { new SqlParameter("@NameplateCode", SqlDbType.NVarChar), new SqlParameter("@PhoneNumber", SqlDbType.NVarChar), new SqlParameter("@SMSText", SqlDbType.NVarChar), new SqlParameter("@HistoryTime", SqlDbType.DateTime), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@SendState", SqlDbType.VarChar,1)}; parameters[0].Value = model.NameplateCode; parameters[1].Value = model.PhoneNumber; parameters[2].Value = model.SMSText; parameters[3].Value = model.HistoryTime; parameters[4].Value = model.SendTime; parameters[5].Value = model.SendState; int iResult = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return iResult; }
/// <summary> /// ����һ������ /// </summary> public void Add(CoalTraffic.Model.TT_LoadWeightByDay model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TT_LoadWeightByDay("); strSql.Append("RoomCode,CollCode,CoalKindCode,TaxGroup,WeightTime,NetWeight,TaxAmount)"); strSql.Append(" values ("); strSql.Append("@RoomCode,@CollCode,@CoalKindCode,@TaxGroup,@WeightTime,@NetWeight,@TaxAmount)"); SqlParameter[] parameters = { new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10), new SqlParameter("@TaxGroup", SqlDbType.Decimal,9), new SqlParameter("@WeightTime", SqlDbType.DateTime), new SqlParameter("@NetWeight", SqlDbType.Decimal,9), new SqlParameter("@TaxAmount", SqlDbType.Decimal,9)}; parameters[0].Value = model.RoomCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.CoalKindCode; parameters[3].Value = model.TaxGroup; parameters[4].Value = model.WeightTime; parameters[5].Value = model.NetWeight; parameters[6].Value = model.TaxAmount; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_ElecCoalYearSet model) { //model.YearCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TDY_ElecCoalYearSet("); strSql.Append("YearCode,YearName,CoalCode,Weight,IsForbid,Operator,OperateTime)"); strSql.Append(" values ("); strSql.Append("@YearCode,@YearName,@CoalCode,@Weight,@IsForbid,@Operator,@OperateTime)"); SqlParameter[] parameters = { new SqlParameter("@YearCode", SqlDbType.NVarChar), new SqlParameter("@YearName", SqlDbType.NVarChar), new SqlParameter("@CoalCode", SqlDbType.NVarChar), new SqlParameter("@Weight", SqlDbType.Decimal,5), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Operator", SqlDbType.NVarChar), new SqlParameter("@OperateTime", SqlDbType.DateTime)}; parameters[0].Value = model.YearCode; parameters[1].Value = model.YearName; parameters[2].Value = model.CoalCode; parameters[3].Value = model.Weight; parameters[4].Value = model.IsForbid; parameters[5].Value = model.Operator; parameters[6].Value = model.OperateTime; int i=DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return i.ToString(); }
/// <summary> /// ����һ������ /// </summary> public bool Add(CoalTraffic.Model.TDY_Parcel model) { //model.ParcelCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_Parcel("); strSql.Append("ParcelCode,CountryCode,ParcelName,Remark,IsForbid)"); strSql.Append(" values ("); strSql.Append("@ParcelCode,@CountryCode,@ParcelName,@Remark,@IsForbid)"); SqlParameter[] parameters = { new SqlParameter("@ParcelCode", SqlDbType.VarChar,10), new SqlParameter("@CountryCode", SqlDbType.VarChar,10), new SqlParameter("@ParcelName", SqlDbType.NVarChar), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; parameters[0].Value = model.ParcelCode; parameters[1].Value = model.CountryCode; parameters[2].Value = model.ParcelName; parameters[3].Value = model.Remark; parameters[4].Value = model.IsForbid; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) return true; else return false; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.T_UserInGroup model) { //model.UserCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_UserInGroup("); strSql.Append("UserCode,UGrpCode,SysCode)"); strSql.Append(" values ("); strSql.Append("@UserCode,@UGrpCode,@SysCode)"); SqlParameter[] parameters = { new SqlParameter("@UserCode", SqlDbType.VarChar,20), new SqlParameter("@UGrpCode", SqlDbType.VarChar,10), new SqlParameter("@SysCode", SqlDbType.VarChar,50)}; parameters[0].Value = model.UserCode; parameters[1].Value = model.UGrpCode; parameters[2].Value = model.SysCode; int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (iAffected > 0) { return model.UserCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.T_UserGroup model) { //model.UGrpCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_UserGroup("); strSql.Append("UGrpCode,UGrpName,UGrpType,IsForbid,Remark,SysCode)"); strSql.Append(" values ("); strSql.Append("@UGrpCode,@UGrpName,@UGrpType,@IsForbid,@Remark,@SysCode)"); SqlParameter[] parameters = { new SqlParameter("@UGrpCode", SqlDbType.VarChar,10), new SqlParameter("@UGrpName", SqlDbType.NVarChar), new SqlParameter("@UGrpType", SqlDbType.VarChar,1), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@SysCode", SqlDbType.VarChar,10)}; parameters[0].Value = model.UGrpCode; parameters[1].Value = model.UGrpName; parameters[2].Value = model.UGrpType; parameters[3].Value = model.IsForbid; parameters[4].Value = model.Remark; parameters[5].Value = model.SysCode; int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (iAffected > 0) { return model.UGrpCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public void Add(CoalTraffic.Model.TT_WaterBook model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TT_WaterBook("); strSql.Append("TradeCode,CollCode,JournalCode,StartMoney,TradeMoney,EndMoney,Operator,TradeDate,TradeKind,Remark,WeightCode)"); strSql.Append(" values ("); strSql.Append("@TradeCode,@CollCode,@JournalCode,@StartMoney,@TradeMoney,@EndMoney,@Operator,@TradeDate,@TradeKind,@Remark,@WeightCode)"); SqlParameter[] parameters = { new SqlParameter("@TradeCode", SqlDbType.VarChar,20), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@JournalCode", SqlDbType.Int,4), new SqlParameter("@StartMoney", SqlDbType.Decimal,9), new SqlParameter("@TradeMoney", SqlDbType.Decimal,9), new SqlParameter("@EndMoney", SqlDbType.Decimal,9), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@TradeDate", SqlDbType.DateTime), new SqlParameter("@TradeKind", SqlDbType.VarChar,10), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@WeightCode", SqlDbType.VarChar,20)}; parameters[0].Value = model.TradeCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.JournalCode; parameters[3].Value = model.StartMoney; parameters[4].Value = model.TradeMoney; parameters[5].Value = model.EndMoney; parameters[6].Value = model.Operator; parameters[7].Value = model.TradeDate; parameters[8].Value = model.TradeKind; parameters[9].Value = model.Remark; parameters[10].Value = model.WeightCode; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public int Add(CoalTraffic.Model.TT_NavicertLog model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TT_NavicertLog("); strSql.Append("NavicertCode,BeforeState,AfterState,Event,Remark,Operator,OperateDate)"); strSql.Append(" values ("); strSql.Append("@NavicertCode,@BeforeState,@AfterState,@Event,@Remark,@Operator,@OperateDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NavicertCode", SqlDbType.VarChar,20), new SqlParameter("@BeforeState", SqlDbType.VarChar,1), new SqlParameter("@AfterState", SqlDbType.VarChar,1), new SqlParameter("@Event", SqlDbType.NVarChar,50), new SqlParameter("@Remark", SqlDbType.NVarChar,200), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@OperateDate", SqlDbType.DateTime)}; parameters[0].Value = model.NavicertCode; parameters[1].Value = model.BeforeState; parameters[2].Value = model.AfterState; parameters[3].Value = model.Event; parameters[4].Value = model.Remark; parameters[5].Value = model.Operator; parameters[6].Value = model.OperateDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TT_CheckBang model) { #region �س���Ʊ SqlParameter[] parameters = { new SqlParameter("@CheckCode", SqlDbType.VarChar,20), new SqlParameter("@WeightCode", SqlDbType.VarChar,20), new SqlParameter("@NavicertCode", SqlDbType.VarChar,20), new SqlParameter("@MarkedCardCode", SqlDbType.VarChar,20), new SqlParameter("@NetWeight", SqlDbType.Decimal,9), new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@IsPassed", SqlDbType.VarChar,1), new SqlParameter("@CheckResult", SqlDbType.NVarChar,200), new SqlParameter("@CheckTime", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@FrontImage", SqlDbType.VarChar,32), new SqlParameter("@FrontImageContent",SqlDbType.Image), new SqlParameter("@BackImage", SqlDbType.VarChar,32), new SqlParameter("@BackImageContent", SqlDbType.Image), new SqlParameter("@UpImage", SqlDbType.VarChar,32), new SqlParameter("@UpImageContent", SqlDbType.Image), new SqlParameter("@RoomImage", SqlDbType.VarChar,32), new SqlParameter("@RoomImageContent", SqlDbType.Image) }; parameters[0].Value = model.CheckCode; parameters[1].Value = model.WeightCode; parameters[2].Value = model.NavicertCode; parameters[3].Value = model.MarkedCardCode; parameters[4].Value = model.NetWeight; parameters[5].Value = model.RoomCode; parameters[6].Value = model.IsPassed; parameters[7].Value = model.CheckResult; parameters[8].Value = model.CheckTime; parameters[9].Value = model.Operator; parameters[10].Value = model.FrontImage; parameters[11].Value = model.FrontImageContent; parameters[12].Value = model.BackImage; parameters[13].Value = model.BackImageContent; parameters[14].Value = model.UpImage; parameters[15].Value = model.UpImageContent; parameters[16].Value = model.RoomImage; parameters[17].Value = model.RoomImageContent; #endregion try { DataSet ds = DbHelperSQL.RunProcedure("PT_CheckBang", parameters, "TT_CheckBang"); if (ds != null) return ds.Tables[0].Rows[0][0].ToString(); else return ""; } catch { return ""; } }
/// <summary> /// 增加一条数据 /// </summary> public string Add(CoalTraffic.Model.TDY_MarkedCardActive model) { //model.ActivationCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TDY_MarkedCardActive("); strSql.Append("ActivationCode,MarkedCardCode,CardKind,CardCode,CardState,ActivationAmount,ActivationTime,Operation)"); strSql.Append(" values ("); strSql.Append("@ActivationCode,@MarkedCardCode,@CardKind,@CardCode,@CardState,@ActivationAmount,@ActivationTime,@Operation)"); SqlParameter[] parameters = { new SqlParameter("@ActivationCode", SqlDbType.VarChar,10), new SqlParameter("@MarkedCardCode", SqlDbType.VarChar,20), new SqlParameter("@CardKind", SqlDbType.VarChar,1), new SqlParameter("@CardCode", SqlDbType.NVarChar), new SqlParameter("@CardState", SqlDbType.VarChar,1), new SqlParameter("@ActivationAmount", SqlDbType.Int,4), new SqlParameter("@ActivationTime", SqlDbType.DateTime), new SqlParameter("@Operation", SqlDbType.NVarChar)}; parameters[0].Value = model.ActivationCode; parameters[1].Value = model.MarkedCardCode; parameters[2].Value = model.CardKind; parameters[3].Value = model.CardCode; parameters[4].Value = model.CardState; parameters[5].Value = model.ActivationAmount; parameters[6].Value = model.ActivationTime; parameters[7].Value = model.Operation; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return model.ActivationCode; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_Position model) { try { //model.PositionCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TDY_Position("); strSql.Append("PositionCode,PositionName,DepartCode,Remark,Rights,IsForbid)"); strSql.Append(" values ("); strSql.Append("@PositionCode,@PositionName,@DepartCode,@Remark,@Rights,@IsForbid)"); SqlParameter[] parameters = { new SqlParameter("@PositionCode", SqlDbType.NVarChar), new SqlParameter("@PositionName", SqlDbType.NVarChar), new SqlParameter("@DepartCode", SqlDbType.NVarChar), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@Rights", SqlDbType.NVarChar), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; parameters[0].Value = model.PositionCode; parameters[1].Value = model.PositionName; parameters[2].Value = model.DepartCode; parameters[3].Value = model.Remark; parameters[4].Value = model.Rights; parameters[5].Value = model.IsForbid; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return model.PositionCode; } catch { return ""; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_IdentifierClip model) { //model.MarkedCardCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TDY_IdentifierClip("); strSql.Append("CoalKindCode,CollCode,DispathCardCode,MarkedCard,MarkedCardState,IsForbid,CardType)"); strSql.Append(" values ("); strSql.Append("@CoalKindCode,@CollCode,@DispathCardCode,@MarkedCard,@MarkedCardState,@IsForbid,@CardType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@DispathCardCode", SqlDbType.VarChar,10), new SqlParameter("@MarkedCard", SqlDbType.NVarChar,20), new SqlParameter("@MarkedCardState", SqlDbType.VarChar,1), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@CardType", SqlDbType.VarChar,1)}; parameters[0].Value = model.CoalKindCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.DispathCardCode; parameters[3].Value = model.MarkedCard; parameters[4].Value = model.MarkedCardState; parameters[5].Value = model.IsForbid; parameters[6].Value = model.CardType; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return model.MarkedCardCode.ToString(); }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_SendCard model) { //model.DispathCardCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_SendCard("); strSql.Append("DispathCardCode,Amount,Buyer,Operator,BuyTime,DepartCode,IsForbid,CoalCode,CoalKindCode)"); strSql.Append(" values ("); strSql.Append("@DispathCardCode,@Amount,@Buyer,@Operator,@BuyTime,@DepartCode,@IsForbid,@CoalCode,@CoalKindCode)"); SqlParameter[] parameters = { new SqlParameter("@DispathCardCode", SqlDbType.VarChar,20), new SqlParameter("@Amount", SqlDbType.Decimal,9), new SqlParameter("@Buyer", SqlDbType.NVarChar), new SqlParameter("@Operator", SqlDbType.NVarChar), new SqlParameter("@BuyTime", SqlDbType.DateTime), new SqlParameter("@DepartCode", SqlDbType.VarChar,10), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@CoalCode", SqlDbType.VarChar,10), new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10)}; parameters[0].Value = model.DispathCardCode; parameters[1].Value = model.Amount; parameters[2].Value = model.Buyer; parameters[3].Value = model.Operator; parameters[4].Value = model.BuyTime; parameters[5].Value = model.DepartCode; parameters[6].Value = model.IsForbid; parameters[7].Value = model.CoalCode; parameters[8].Value = model.CoalKindCode; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); return model.DispathCardCode; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_GFItems model) { //model.ItemCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_GFItems("); strSql.Append("ItemCode,ItemName,IsStat,IsForbid,Remark)"); strSql.Append(" values ("); strSql.Append("@ItemCode,@ItemName,@IsStat,@IsForbid,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@ItemCode", SqlDbType.VarChar,10), new SqlParameter("@ItemName", SqlDbType.NVarChar), new SqlParameter("@IsStat", SqlDbType.VarChar,1), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Remark", SqlDbType.NVarChar)}; parameters[0].Value = model.ItemCode; parameters[1].Value = model.ItemName; parameters[2].Value = model.IsStat; parameters[3].Value = model.IsForbid; parameters[4].Value = model.Remark; int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (iAffected > 0) { return model.ItemCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_EmptyAgainBang model) { //model.AgainCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_EmptyAgainBang("); strSql.Append("AgainCode,EmptyCode,Proceduce,AgainReason,AgainType,FormerlyWeight,RoomCode,Operator,AgainTime)"); strSql.Append(" values ("); strSql.Append("@AgainCode,@EmptyCode,@Proceduce,@AgainReason,@AgainType,@FormerlyWeight,@RoomCode,@Operator,@AgainTime)"); SqlParameter[] parameters = { new SqlParameter("@AgainCode", SqlDbType.VarChar,20), new SqlParameter("@EmptyCode", SqlDbType.VarChar,20), new SqlParameter("@Proceduce", SqlDbType.Decimal,9), new SqlParameter("@AgainReason", SqlDbType.NVarChar), new SqlParameter("@AgainType", SqlDbType.VarChar,1), new SqlParameter("@FormerlyWeight", SqlDbType.Decimal,5), new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@Operator", SqlDbType.NVarChar), new SqlParameter("@AgainTime", SqlDbType.DateTime)}; parameters[0].Value = model.AgainCode; parameters[1].Value = model.EmptyCode; parameters[2].Value = model.Proceduce; parameters[3].Value = model.AgainReason; parameters[4].Value = model.AgainType; parameters[5].Value = model.FormerlyWeight; parameters[6].Value = model.RoomCode; parameters[7].Value = model.Operator; parameters[8].Value = model.AgainTime; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); return model.AgainCode; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_CoalManageStation model) { //model.SiteCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_CoalManageStation("); strSql.Append("SiteCode,SiteName,IsForbid,VillageCode,Remark)"); strSql.Append(" values ("); strSql.Append("@SiteCode,@SiteName,@IsForbid,@VillageCode,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@SiteCode", SqlDbType.VarChar,10), new SqlParameter("@SiteName", SqlDbType.NVarChar), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@VillageCode", SqlDbType.VarChar,10), new SqlParameter("@Remark", SqlDbType.NVarChar)}; parameters[0].Value = model.SiteCode; parameters[1].Value = model.SiteName; parameters[2].Value = model.IsForbid; parameters[3].Value = model.VillageCode; parameters[4].Value = model.Remark; string code=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters).ToString(); if (code != "") { return model.SiteCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_CollKicket model) { //model.BuyCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TDY_CollKicket("); strSql.Append("BuyCode,CollCode,CoalTicketAmount,Buyer,Operator,SaleTime)"); strSql.Append(" values ("); strSql.Append("@BuyCode,@CollCode,@CoalTicketAmount,@Buyer,@Operator,@SaleTime)"); SqlParameter[] parameters = { new SqlParameter("@BuyCode", SqlDbType.VarChar,20), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@CoalTicketAmount", SqlDbType.Decimal,9), new SqlParameter("@Buyer", SqlDbType.NVarChar,20), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@SaleTime", SqlDbType.DateTime)}; parameters[0].Value = model.BuyCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.CoalTicketAmount; parameters[3].Value = model.Buyer; parameters[4].Value = model.Operator; parameters[5].Value = model.SaleTime; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) return model.BuyCode; else return string.Empty; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.T_Navigation model) { //model.SysCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into T_Navigation("); strSql.Append("SysCode,FunCode,IsShow,UserCode)"); strSql.Append(" values ("); strSql.Append("@SysCode,@FunCode,@IsShow,@UserCode)"); SqlParameter[] parameters = { new SqlParameter("@SysCode", SqlDbType.VarChar,10), new SqlParameter("@FunCode", SqlDbType.VarChar,10), new SqlParameter("@IsShow", SqlDbType.VarChar,1), new SqlParameter("@UserCode", SqlDbType.VarChar,10)}; parameters[0].Value = model.SysCode; parameters[1].Value = model.FunCode; parameters[2].Value = model.IsShow; parameters[3].Value = model.UserCode; int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (iAffected > 0) { return model.SysCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public bool Add(CoalTraffic.Model.T_Department model) { //model.DepartCode=GetMaxId(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Department("); strSql.Append("DepartCode,DepartName,Telephone,Fathercode,SysCode,Remark,IsForbid)"); strSql.Append(" values ("); strSql.Append("@DepartCode,@DepartName,@Telephone,@Fathercode,@SysCode,@Remark,@IsForbid)"); SqlParameter[] parameters = { new SqlParameter("@DepartCode", SqlDbType.VarChar,10), new SqlParameter("@DepartName", SqlDbType.NVarChar), new SqlParameter("@Telephone", SqlDbType.NVarChar), new SqlParameter("@Fathercode", SqlDbType.VarChar,10), new SqlParameter("@SysCode", SqlDbType.VarChar,10), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; parameters[0].Value = model.DepartCode; parameters[1].Value = model.DepartName; parameters[2].Value = model.Telephone; parameters[3].Value = model.Fathercode; parameters[4].Value = model.SysCode; parameters[5].Value = model.Remark; parameters[6].Value = model.IsForbid; int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (iAffected > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public int Add(CoalTraffic.Model.TT_TaxAssignDetail model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TT_TaxAssignDetail("); strSql.Append("ItemDetailID,UnitCode,AssignAmount,OperateTime,Operator)"); strSql.Append(" values ("); strSql.Append("@ItemDetailID,@UnitCode,@AssignAmount,@OperateTime,@Operator)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ItemDetailID", SqlDbType.BigInt,8), new SqlParameter("@UnitCode", SqlDbType.VarChar,10), new SqlParameter("@AssignAmount", SqlDbType.Decimal,9), new SqlParameter("@OperateTime", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.NVarChar,20)}; parameters[0].Value = model.ItemDetailID; parameters[1].Value = model.UnitCode; parameters[2].Value = model.AssignAmount; parameters[3].Value = model.OperateTime; parameters[4].Value = model.Operator; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(string CardID, string CardNO, CoalTraffic.Model.TT_InitialCard model) { //对数据库中已有的记录,更新记录 string[] cardno = null; string[] cardcode = null; List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); StringBuilder strSql = new StringBuilder(""); StringBuilder strAll = new StringBuilder(""); int i = 0; if (CardID != "") { //对数据库中没有的卡号,添加记录 cardno = CardID.Split('|'); cardcode = CardNO.Split('|'); for (i = 0; i < cardno.Length; i++) { strAll.Append("insert into TT_InitialCard("); strAll.Append("CardID,CardNO,CardType,InitialTime,IntialPerson)"); strAll.Append(" values ("); strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CardType + "','" + model.InitialTime + "','" + model.IntialPerson + "');"); } } int iFlag = DbHelperSQL.ExecuteSql(strAll.ToString()); return iFlag > 0 ? true : false; }
/// <summary> /// ����һ������ /// </summary> public int Add(CoalTraffic.Model.TDY_ShadinessInfo model) { //model.ShadinessCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_ShadinessInfo("); strSql.Append("ShadinessType,Description,DataName,DataNumber,ShadinessUser,ShadinessDate,DisposalIdea,DisposalUser,DisposalDate,WeightBangCode)"); strSql.Append(" values ("); strSql.Append("@ShadinessType,@Description,@DataName,@DataNumber,@ShadinessUser,@ShadinessDate,@DisposalIdea,@DisposalUser,@DisposalDate,@WeightBangCode)"); SqlParameter[] parameters = { new SqlParameter("@ShadinessType", SqlDbType.VarChar,20), new SqlParameter("@Description", SqlDbType.VarChar,200), new SqlParameter("@DataName", SqlDbType.VarChar,20), new SqlParameter("@DataNumber", SqlDbType.VarChar,20), new SqlParameter("@ShadinessUser", SqlDbType.VarChar,8), new SqlParameter("@ShadinessDate", SqlDbType.DateTime), new SqlParameter("@DisposalIdea", SqlDbType.VarChar,200), new SqlParameter("@DisposalUser", SqlDbType.VarChar,8), new SqlParameter("@DisposalDate", SqlDbType.DateTime), new SqlParameter("@WeightBangCode", SqlDbType.VarChar,20)}; parameters[0].Value = model.ShadinessType; parameters[1].Value = model.Description; parameters[2].Value = model.DataName; parameters[3].Value = model.DataNumber; parameters[4].Value = model.ShadinessUser; parameters[5].Value = model.ShadinessDate; parameters[6].Value = model.DisposalIdea; parameters[7].Value = model.DisposalUser; parameters[8].Value = model.DisposalDate; parameters[9].Value = model.WeightBangCode; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); return model.ShadinessCode; }
/// <summary> /// ����һ������ /// </summary> public int Add(CoalTraffic.Model.TDYN_PhoneDictionary model) { //model.PCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDYN_PhoneDictionary("); strSql.Append("TypeCode,PName,PhoneNumber,NameplateName,NameplateCode,IsForbid)"); strSql.Append(" values ("); strSql.Append("@TypeCode,@PName,@PhoneNumber,@NameplateName,@NameplateCode,@IsForbid)"); SqlParameter[] parameters = { new SqlParameter("@TypeCode", SqlDbType.Int,4), new SqlParameter("@PName", SqlDbType.VarChar,50), new SqlParameter("@PhoneNumber", SqlDbType.VarChar,20), new SqlParameter("@NameplateName", SqlDbType.VarChar,100), new SqlParameter("@NameplateCode", SqlDbType.VarChar,20), new SqlParameter("@IsForbid", SqlDbType.VarChar,1)}; parameters[0].Value = model.TypeCode; parameters[1].Value = model.PName; parameters[2].Value = model.PhoneNumber; parameters[3].Value = model.NameplateName; parameters[4].Value = model.NameplateCode; parameters[5].Value = model.IsForbid; int iResult=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); return iResult; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_CoalAccountManage model) { //model.AmountCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_CoalAccountManage("); strSql.Append("AmountCode,CollCode,LastAmount,LowAmount,AccountState,AmountCodeID)"); strSql.Append(" values ("); strSql.Append("@AmountCode,@CollCode,@LastAmount,@LowAmount,@AccountState,@AmountCodeID)"); SqlParameter[] parameters = { new SqlParameter("@AmountCode", SqlDbType.VarChar,10), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@LastAmount", SqlDbType.Decimal,9), new SqlParameter("@LowAmount", SqlDbType.Decimal,9), new SqlParameter("@AccountState", SqlDbType.VarChar,1), new SqlParameter("@AmountCodeID", SqlDbType.VarChar,20), }; parameters[0].Value = model.AmountCode; parameters[1].Value = model.CollCode; parameters[2].Value = model.LastAmount; parameters[3].Value = model.LowAmount; parameters[4].Value = model.AccountState; parameters[5].Value = model.AmountCodeID; string icode=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters).ToString(); if (icode != "") { return model.AmountCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public bool Add(CoalTraffic.Model.TDY_CollKind model) { //model.CoalKindCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_CollKind("); strSql.Append("CoalKindCode,CoalKind,IsForbid,Remark)"); strSql.Append(" values ("); strSql.Append("@CoalKindCode,@CoalKind,@IsForbid,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10), new SqlParameter("@CoalKind", SqlDbType.NVarChar), new SqlParameter("@IsForbid", SqlDbType.VarChar,1), new SqlParameter("@Remark", SqlDbType.NVarChar)}; parameters[0].Value = model.CoalKindCode; parameters[1].Value = model.CoalKind; parameters[2].Value = model.IsForbid; parameters[3].Value = model.Remark; int iAffected = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (iAffected > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_GFDetail model) { //model.DetailCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_GFDetail("); strSql.Append("DetailCode,CoalKindCode,ItemCode,RoomCode,Amount,EffectTime,Operator,OperateTime)"); strSql.Append(" values ("); strSql.Append("@DetailCode,@CoalKindCode,@ItemCode,@RoomCode,@Amount,@EffectTime,@Operator,@OperateTime)"); SqlParameter[] parameters = { new SqlParameter("@DetailCode", SqlDbType.VarChar,10), new SqlParameter("@CoalKindCode", SqlDbType.VarChar,10), new SqlParameter("@ItemCode", SqlDbType.VarChar,10), new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@Amount", SqlDbType.Decimal,9), new SqlParameter("@EffectTime", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.NVarChar), new SqlParameter("@OperateTime", SqlDbType.DateTime)}; parameters[0].Value = model.DetailCode; parameters[1].Value = model.CoalKindCode; parameters[2].Value = model.ItemCode; parameters[3].Value = model.RoomCode; parameters[4].Value = model.Amount; parameters[5].Value = model.EffectTime; parameters[6].Value = model.Operator; parameters[7].Value = model.OperateTime; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); return model.DetailCode; }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TDY_Colliery model) { //model.CollCode=GetMaxId(); StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TDY_Colliery("); strSql.Append("CollCode,SiteCode,CollName,AmountCode,MineOwner,OwnerPhone,CollCorporation,CorporationPhone,IdentifierManage,IMPhone,YearOutput,CollPhone,State,KeyWord,PassWord,Remark,imgYYZZ,imgZGZ,imgDJZ)"); strSql.Append(" values ("); strSql.Append("@CollCode,@SiteCode,@CollName,@AmountCode,@MineOwner,@OwnerPhone,@CollCorporation,@CorporationPhone,@IdentifierManage,@IMPhone,@YearOutput,@CollPhone,@State,@KeyWord,@PassWord,@Remark,@imgYYZZ,@imgZGZ,@imgDJZ)"); SqlParameter[] parameters = { new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@SiteCode", SqlDbType.VarChar,10), new SqlParameter("@CollName", SqlDbType.NVarChar), new SqlParameter("@AmountCode", SqlDbType.VarChar,10), new SqlParameter("@MineOwner", SqlDbType.NVarChar), new SqlParameter("@OwnerPhone", SqlDbType.NVarChar), new SqlParameter("@CollCorporation", SqlDbType.NVarChar), new SqlParameter("@CorporationPhone", SqlDbType.NVarChar), new SqlParameter("@IdentifierManage", SqlDbType.NVarChar), new SqlParameter("@IMPhone", SqlDbType.NVarChar), new SqlParameter("@YearOutput", SqlDbType.Decimal,9), new SqlParameter("@CollPhone", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.NVarChar), new SqlParameter("@KeyWord", SqlDbType.NVarChar), new SqlParameter("@PassWord", SqlDbType.NVarChar), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@imgYYZZ", SqlDbType.NVarChar), new SqlParameter("@imgZGZ", SqlDbType.NVarChar), new SqlParameter("@imgDJZ",SqlDbType.NVarChar) }; parameters[0].Value = model.CollCode; parameters[1].Value = model.SiteCode; parameters[2].Value = model.CollName; parameters[3].Value = model.AmountCode; parameters[4].Value = model.MineOwner; parameters[5].Value = model.OwnerPhone; parameters[6].Value = model.CollCorporation; parameters[7].Value = model.CorporationPhone; parameters[8].Value = model.IdentifierManage; parameters[9].Value = model.IMPhone; parameters[10].Value = model.YearOutput; parameters[11].Value = model.CollPhone; parameters[12].Value = model.State; parameters[13].Value = model.KeyWord; parameters[14].Value = model.PassWord; parameters[15].Value=model.Remark; parameters[16].Value = model.imgYYZZ; parameters[17].Value = model.imgZGZ; parameters[18].Value = model.imgDJZ; string icode = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters).ToString(); if (icode != "") { return model.CollCode; } else { return string.Empty; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TT_CarInfo model) { try { SqlParameter[] parameters = { new SqlParameter("@RoomCode", SqlDbType.VarChar,4), new SqlParameter("@EmptyWeight", SqlDbType.Decimal), new SqlParameter("@MostWeight", SqlDbType.Decimal), new SqlParameter("@CarNo", SqlDbType.NVarChar,20), new SqlParameter("@CarType", SqlDbType.NVarChar,20), new SqlParameter("@CarOwnerName", SqlDbType.NVarChar,20), new SqlParameter("@CarOwnerIDCard", SqlDbType.NVarChar,20), new SqlParameter("@CarOwnerPhone", SqlDbType.NVarChar,20), new SqlParameter("@RandomCode", SqlDbType.VarChar,4), new SqlParameter("@Operator", SqlDbType.NVarChar,20), new SqlParameter("@BangType", SqlDbType.NVarChar,10), new SqlParameter("@FirstImage", SqlDbType.VarChar), new SqlParameter("@FileContent", SqlDbType.Image), new SqlParameter("@CarCode", SqlDbType.VarChar,20), new SqlParameter("@EmptyBangTime", SqlDbType.DateTime), new SqlParameter("@DriveLicense",SqlDbType.VarChar,40), new SqlParameter("@DriverName", SqlDbType.NVarChar,20), new SqlParameter("@DriverIDCard", SqlDbType.NVarChar,20), new SqlParameter("@DriverPhone", SqlDbType.NVarChar,20) }; parameters[0].Value = model.RoomCode; parameters[1].Value = model.EmptyWeight; parameters[2].Value = model.MostWeight; parameters[3].Value = model.CarNo; parameters[4].Value = model.CarType; parameters[5].Value = model.CarOwnerName; parameters[6].Value = model.CarOwnerIDCard; parameters[7].Value = model.CarOwnerPhone; parameters[8].Value = model.RandomCode; parameters[9].Value = model.Operator; parameters[10].Value = model.BangType; parameters[11].Value = model.FirstImage; parameters[12].Value = model.FirstImageContent; parameters[13].Value = model.CarCode; parameters[14].Value = model.EmptyBangTime; parameters[15].Value = model.DriveLicense; parameters[16].Value = model.DriverName; parameters[17].Value = model.DriverIDCard; parameters[18].Value = model.DriverPhone; DataSet ds = DbHelperSQL.RunProcedure("PT_CarInfo", parameters, "CarInfo"); if (ds != null) return ds.Tables[0].Rows[0][0].ToString(); else return ""; } catch { return ""; } }
/// <summary> /// ����һ������ /// </summary> public string Add(CoalTraffic.Model.TT_BadRecord model) { #region ������¼ SqlParameter[] parameters = { new SqlParameter("@RecordID", SqlDbType.VarChar,32), new SqlParameter("@NavicertCode", SqlDbType.VarChar,20), new SqlParameter("@RoomCode", SqlDbType.VarChar,10), new SqlParameter("@CarNo", SqlDbType.NVarChar,20), new SqlParameter("@Decript", SqlDbType.NVarChar,200), new SqlParameter("@BreakDate", SqlDbType.DateTime), new SqlParameter("@AlarmType", SqlDbType.VarChar,50), new SqlParameter("@AlarmStatus", SqlDbType.VarChar,1), new SqlParameter("@CollCode", SqlDbType.VarChar,10), new SqlParameter("@FrontImage", SqlDbType.VarChar,32), new SqlParameter("@FrontImageContent",SqlDbType.Image), new SqlParameter("@BackImage", SqlDbType.VarChar,32), new SqlParameter("@BackImageContent", SqlDbType.Image), new SqlParameter("@UpImage", SqlDbType.VarChar,32), new SqlParameter("@UpImageContent", SqlDbType.Image), new SqlParameter("@RoomImage", SqlDbType.VarChar,32), new SqlParameter("@RoomImageContent", SqlDbType.Image) }; parameters[0].Value = model.RecordID; parameters[1].Value = model.NavicertCode; parameters[2].Value = model.RoomCode; parameters[3].Value = model.CarNo; parameters[4].Value = model.Decript; parameters[5].Value = model.BreakDate; parameters[6].Value = model.AlarmType; parameters[7].Value = model.AlarmStatus; parameters[8].Value = model.CollCode; parameters[9].Value = model.FrontImage; parameters[10].Value = model.FrontImageContent; parameters[11].Value = model.BackImage; parameters[12].Value = model.BackImageContent; parameters[13].Value = model.UpImage; parameters[14].Value = model.UpImageContent; parameters[15].Value = model.RoomImage; parameters[16].Value = model.RoomImageContent; #endregion try { DataSet ds = DbHelperSQL.RunProcedure("PT_BadRecord", parameters, "TT_BadRecord"); if (ds != null) return ds.Tables[0].Rows[0][0].ToString(); else return ""; } catch { return ""; } }
/// <summary> /// 购买标识卡 /// </summary> public bool Add(string strNewMarkedCardNo, string strNewMarkedCardCode, CoalTraffic.Model.TT_MarkedCard model) { //对数据库中已有的记录,更新记录 string[] cardno = null; string[] cardcode = null; List<string> listSql = new List<string>(); List<SqlParameter[]> listParm = new List<SqlParameter[]>(); StringBuilder strSql = new StringBuilder(""); StringBuilder strAll = new StringBuilder(""); int i = 0; if (model.MarkedCardNo != "") { cardno = model.MarkedCardNo.Split('|'); cardcode = model.MarkedCardCode.Split('|'); for (i = 0; i < cardno.Length; i++) { strAll.Append("update TT_MarkedCard set "); strAll.Append("CollCode='" + model.CollCode + "',"); strAll.Append("CoalKindCode='" + model.CoalKindCode + "',"); strAll.Append("MarkedCardState='1',"); strAll.Append("SendCardDate='" + model.SendCardDate + "',"); strAll.Append("Operator='" + model.Operator + "',"); strAll.Append("DepartName='" + model.DepartName + "'"); strAll.Append(" where MarkedCardCode='" + cardcode[i] + "';"); //往标识卡记录表里添加记录 strAll.Append("insert into TT_MarkedCardSendRecord("); strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,SendCardDate,Operator,DepartName,SendType)"); strAll.Append(" values ("); strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "','购买');"); } } if (strNewMarkedCardNo != "") { //对数据库中没有的卡号,添加记录 cardno = strNewMarkedCardNo.Split('|'); cardcode = strNewMarkedCardCode.Split('|'); for (i = 0; i < cardno.Length; i++) { strAll.Append("insert into TT_MarkedCard("); strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,MarkedCardState,SendCardDate,Operator,DepartName)"); strAll.Append(" values ("); strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','1','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "');"); strAll.Append("insert into TT_MarkedCardSendRecord("); strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,SendCardDate,Operator,DepartName,SendType)"); strAll.Append(" values ("); strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "','购买');"); } } int iFlag = DbHelperSQL.ExecuteSql(strAll.ToString()); return iFlag > 0 ? true : false; }