C# CoalTraffic类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中CoalTraffic类的典型用法代码示例。如果您正苦于以下问题：C# CoalTraffic类的具体用法？C# CoalTraffic怎么用？C# CoalTraffic使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

CoalTraffic类属于命名空间，在下文中一共展示了CoalTraffic类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:28，代码来源:TDYN_NoteHistory.cs

示例2: Add

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

开发者ID:SaintLoong，项目名称:YaoXian_CoalTraffic-CS-，代码行数:28，代码来源:TT_LoadWeightByDay.cs

示例3: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:31，代码来源:TDY_ElecCoalYearSet.cs

示例4: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:29，代码来源:TDY_Parcel.cs

示例5: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:30，代码来源:T_UserInGroup.cs

示例6: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:36，代码来源:T_UserGroup.cs

示例7: Add

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

开发者ID:SaintLoong，项目名称:YaoXian_CoalTraffic-CS-，代码行数:36，代码来源:TT_WaterBook.cs

示例8: Add

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

开发者ID:SaintLoong，项目名称:YaoXian_CoalTraffic-CS-，代码行数:37，代码来源:TT_NavicertLog.cs

示例9: Add

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

开发者ID:SaintLoong，项目名称:YaoXian_CoalTraffic-CS-，代码行数:63，代码来源:TT_CheckBang.cs

示例10: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:32，代码来源:TDY_MarkedCardActive.cs

示例11: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:35，代码来源:TDY_Position.cs

示例12: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:31，代码来源:TDY_IdentifierClip.cs

示例13: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:34，代码来源:TDY_SendCard.cs

示例14: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:34，代码来源:TDY_GFItems.cs

示例15: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:34，代码来源:TDY_EmptyAgainBang.cs

示例16: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:33，代码来源:TDY_CoalManageStation.cs

示例17: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:31，代码来源:TDY_CollKicket.cs

示例18: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:32，代码来源:T_Navigation.cs

示例19: Add

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

开发者ID:SaintLoong，项目名称:XunYi_CoalTraffic_Ebiao，代码行数:37，代码来源:T_Department.cs

示例20: Add

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

开发者ID:SaintLoong，项目名称:YaoXian_CoalTraffic-CS-，代码行数:33，代码来源:TT_TaxAssignDetail.cs

注：本文中的CoalTraffic类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# Code类代码示例发布时间：2022-05-24

C# CmsWebServiceClient类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19192|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9988|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8327|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8696|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8639|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9657|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8624|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7998|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8656|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7535|2022-11-06

客服电话

电子邮件

C# CoalTraffic类代码示例

示例1: Add

示例2: Add

示例3: Add

示例4: Add

示例5: Add

示例6: Add

示例7: Add

示例8: Add

示例9: Add

示例10: Add

示例11: Add

示例12: Add

示例13: Add

示例14: Add

示例15: Add

示例16: Add

示例17: Add

示例18: Add

示例19: Add

示例20: Add

请发表评论

全部评论

上一篇：

下一篇：

CVE-2022-2115

dustinvtran/ml-videos: A collection of v

ravikumar001/maven

更的笔顺,体会更的笔画,理会更的部首

ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053