/// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(IndustryPlatform.Model.SYS_DictionaryEntity model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Sys_Dictionary(");
            strSql.Append("BusinID,BusinName,BusinTypeID,DisplayOrder,IsForbid)");
            strSql.Append(" values (");
            strSql.Append("@BusinID,@BusinName,@BusinTypeID,@DisplayOrder,@IsForbid)");
            SqlParameter[] parameters = {
                    new SqlParameter("@BusinID", SqlDbType.VarChar,10),
                    new SqlParameter("@BusinName", SqlDbType.NVarChar,50),
                    new SqlParameter("@BusinTypeID", SqlDbType.VarChar,10),
                    new SqlParameter("@DisplayOrder", SqlDbType.Decimal,5),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1)};

            try
            {
                parameters[0].Value = model.BusinID;
                parameters[1].Value = model.BusinName;
                parameters[2].Value = model.BusinTypeID;
                parameters[3].Value = model.DisplayOrder;
                parameters[4].Value = model.IsForbid;

                if (DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch { return false; }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(IndustryPlatform.Model.SYS_Organization model)
        {
            try
            {
                lock (this)
                {
                    StringBuilder strSql = new StringBuilder();
                    strSql.Append("insert into Sys_Organization(");
                    strSql.Append("OrgCode,OrgName,OrgLevel,ParentOrgCode,OrgSeq,OrgType,LinkMan,LinkManTel,Email,IsForbid,Remark,SysCode)");
                    strSql.Append(" values (");
                    strSql.Append("@OrgCode,@OrgName,@OrgLevel,@ParentOrgCode,@OrgSeq,@OrgType,@LinkMan,@LinkManTel,@Email,@IsForbid,@Remark,@SysCode)");
                    SqlParameter[] parameters = {
                    new SqlParameter("@OrgCode", SqlDbType.VarChar,10),
                    new SqlParameter("@OrgName", SqlDbType.NVarChar,50),
                    new SqlParameter("@OrgLevel", SqlDbType.VarChar,1),
                    new SqlParameter("@ParentOrgCode", SqlDbType.VarChar,10),
                    new SqlParameter("@OrgSeq", SqlDbType.NVarChar,300),
                    new SqlParameter("@OrgType", SqlDbType.VarChar,1),
                    new SqlParameter("@LinkMan", SqlDbType.NVarChar,20),
                    new SqlParameter("@LinkManTel", SqlDbType.NVarChar,20),
                    new SqlParameter("@Email", SqlDbType.NVarChar,100),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
                    new SqlParameter("@Remark", SqlDbType.NVarChar,200),
                    new SqlParameter("@SysCode", SqlDbType.VarChar,4)};
                    int iKey = DbHelperSQL.GetMaxID("OrgCode", "SYS_Organization");
                    string strSEQ = "";
                    if (model.ParentOrgCode == "0")
                        strSEQ = iKey + ".";
                    else
                        strSEQ = GetModel(model.ParentOrgCode).OrgSeq + iKey + ".";

                    model.OrgSeq = strSEQ;
                    parameters[0].Value = model.OrgCode;
                    parameters[1].Value = model.OrgName;
                    parameters[2].Value = model.OrgLevel;
                    parameters[3].Value = model.ParentOrgCode;
                    parameters[4].Value = model.OrgSeq;
                    parameters[5].Value = model.OrgType;
                    parameters[6].Value = model.LinkMan;
                    parameters[7].Value = model.LinkManTel;
                    parameters[8].Value = model.Email;
                    parameters[9].Value = model.IsForbid;
                    parameters[10].Value = model.Remark;
                    parameters[11].Value = model.SysCode;

                    DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
                    return 1;
                }
            }
            catch
            {
                return 0;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public int Update(IndustryPlatform.Model.SYS_Organization model)
        {
            try
            {
                List<string> listSql = new List<string>();
                List<SqlParameter[]> listParm = new List<SqlParameter[]>();
                string strOldSEQ = GetModel(model.OrgCode).OrgSeq;
                string strNewSEQ = model.OrgCode + ".";
                if (model.ParentOrgCode != "0")
                {
                    IndustryPlatform.Model.SYS_Organization p=GetModel(model.ParentOrgCode);
                    strNewSEQ = p.OrgSeq + model.OrgCode+".";
                }

                //更新序列
                string strSqlSeq = "update SYS_Organization set OrgSeq='" + strNewSEQ + "'+ replace(OrgSeq,'" + strOldSEQ + "','') where OrgSeq like '" + strOldSEQ + "%'";
                //DbHelperSQL.ExecuteSql(strSqlSeq);
                listSql.Add(strSqlSeq);
                listParm.Add(null);

                //更新Level
                string strSqlLevel = "Update SYS_Organization set orgLevel=len(orgSEQ)-len(replace(orgSEQ,'.' , ''))  where orgSEQ like '" + strNewSEQ + "%'";
                listSql.Add(strSqlLevel);
                listParm.Add(null);
                //DbHelperSQL.ExecuteSql(strSqlLevel);

                StringBuilder strSql = new StringBuilder();
                strSql.Append("update Sys_Organization set ");
                strSql.Append("OrgName=@OrgName,");
                strSql.Append("OrgLevel=@OrgLevel,");
                strSql.Append("ParentOrgCode=@ParentOrgCode,");
                strSql.Append("OrgSeq=@OrgSeq,");
                strSql.Append("OrgType=@OrgType,");
                strSql.Append("LinkMan=@LinkMan,");
                strSql.Append("LinkManTel=@LinkManTel,");
                strSql.Append("Email=@Email,");
                strSql.Append("IsForbid=@IsForbid,");
                strSql.Append("Remark=@Remark,");
                strSql.Append("SysCode=@SysCode");
                strSql.Append(" where OrgCode=@OrgCode ");
                SqlParameter[] parameters = {
                    new SqlParameter("@OrgCode", SqlDbType.VarChar,10),
                    new SqlParameter("@OrgName", SqlDbType.NVarChar,50),
                    new SqlParameter("@OrgLevel", SqlDbType.VarChar,1),
                    new SqlParameter("@ParentOrgCode", SqlDbType.VarChar,10),
                    new SqlParameter("@OrgSeq", SqlDbType.NVarChar,300),
                    new SqlParameter("@OrgType", SqlDbType.VarChar,1),
                    new SqlParameter("@LinkMan", SqlDbType.NVarChar,20),
                    new SqlParameter("@LinkManTel", SqlDbType.NVarChar,20),
                    new SqlParameter("@Email", SqlDbType.NVarChar,100),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
                    new SqlParameter("@Remark", SqlDbType.NVarChar,200),
                    new SqlParameter("@SysCode", SqlDbType.VarChar,4)};
                parameters[0].Value = model.OrgCode;
                parameters[1].Value = model.OrgName;
                parameters[2].Value = model.OrgLevel;
                parameters[3].Value = model.ParentOrgCode;
                parameters[4].Value = strNewSEQ;
                parameters[5].Value = model.OrgType;
                parameters[6].Value = model.LinkMan;
                parameters[7].Value = model.LinkManTel;
                parameters[8].Value = model.Email;
                parameters[9].Value = model.IsForbid;
                parameters[10].Value = model.Remark;
                parameters[11].Value = model.SysCode;
                listSql.Add(strSql.ToString());
                listParm.Add(parameters);
                //DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
                DbHelperSQL.ExecuteSqlCake(listSql, listParm);
                return 1;
            }
            catch
            {
                return 0;
            }
        }
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(IndustryPlatform.Model.SYS_Organization model)
 {
     return dal.Add(model);
 }
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public int Update(IndustryPlatform.Model.SYS_Organization model)
 {
     return dal.Update(model);
 }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public int Update(IndustryPlatform.Model.Sys_Colliery model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Sys_Colliery set ");

            strSql.Append("CollName=@CollName,");
            strSql.Append("OrgCode=@OrgCode,");
            strSql.Append("VillageCode=@VillageCode,");
            strSql.Append("MineOwner=@MineOwner,");
            strSql.Append("MinePhone=@MinePhone,");
            strSql.Append("YearOutput=@YearOutput,");
            strSql.Append("CollState=@CollState,");
            strSql.Append("ImageLicence=@ImageLicence,");
            strSql.Append("ImageRevenue=@ImageRevenue,");
            strSql.Append("ImageCompetency=@ImageCompetency,");
            strSql.Append("Remark=@Remark,");
            strSql.Append("IsForbid=@IsForbid,");
            strSql.Append("CollProperty=@CollProperty");//煤矿属性
            strSql.Append(" where CollCode=@CollCode ");
            SqlParameter[] parameters = {

                    new SqlParameter("@CollCode", SqlDbType.VarChar,20),
                    new SqlParameter("@CollName", SqlDbType.VarChar,50),
                    new SqlParameter("@OrgCode", SqlDbType.Decimal,9),
                    new SqlParameter("@VillageCode", SqlDbType.VarChar,4),
                    new SqlParameter("@MineOwner", SqlDbType.VarChar,20),
                    new SqlParameter("@MinePhone", SqlDbType.VarChar,30),
                    new SqlParameter("@YearOutput", SqlDbType.Decimal,9),
                    new SqlParameter("@CollState", SqlDbType.VarChar,10),
                    new SqlParameter("@ImageLicence", SqlDbType.VarChar,32),
                    new SqlParameter("@LicenceImageType", SqlDbType.VarChar,10),
                    new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32),
                    new SqlParameter("@RevenueImageType", SqlDbType.VarChar,10),
                    new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32),
                    new SqlParameter("@CompetencyImageType", SqlDbType.VarChar,10),
                    new SqlParameter("@Remark", SqlDbType.VarChar,200),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
                    new SqlParameter("@CollProperty",SqlDbType.VarChar,1)};

            parameters[0].Value = model.CollCode;
            parameters[1].Value = model.CollName;
            parameters[2].Value = model.OrgCode;
            parameters[3].Value = model.VillageCode;
            parameters[4].Value = model.MineOwner;
            parameters[5].Value = model.MinePhone;
            parameters[6].Value = model.YearOutput;
            parameters[7].Value = model.CollState;
            parameters[8].Value = model.ImageLicence;
            parameters[9].Value = model.ImageRevenue;
            parameters[10].Value = model.ImageCompetency;
            parameters[11].Value = model.Remark;
            parameters[12].Value = model.IsForbid;
            parameters[13].Value = model.CollProperty;//煤矿属性

            return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        public bool update(IndustryPlatform.Model.Sys_Colliery coll, List<IndustryPlatform.Model.Sys_FileSave> listModel)
        {
            try
            {
                lock (this)
                {
                    StringBuilder strSql = new StringBuilder();
                    List<string> listSql = new List<string>();
                    List<SqlParameter[]> listParm = new List<SqlParameter[]>();
                    strSql = new StringBuilder();
                    strSql.Append("update Sys_Colliery set ");
                    strSql.Append("CollName=@CollName,");
                    strSql.Append("OrgCode=@OrgCode,");
                    strSql.Append("VillageCode=@VillageCode,");
                    strSql.Append("MineOwner=@MineOwner,");
                    strSql.Append("MinePhone=@MinePhone,");
                    strSql.Append("YearOutput=@YearOutput,");
                    strSql.Append("CollState=@CollState,");
                    strSql.Append("ImageLicence=@ImageLicence,");
                    strSql.Append("ImageRevenue=@ImageRevenue,");
                    strSql.Append("ImageCompetency=@ImageCompetency,");
                    strSql.Append("Remark=@Remark,");
                    strSql.Append("IsForbid=@IsForbid,");
                    strSql.Append("CollProperty=@CollProperty,");
                    strSql.Append("ParcelCode=@ParcelCode");
                    strSql.Append(" where CollCode=@CollCode ");
                    SqlParameter[] parameters = {
                    new SqlParameter("@CollCode", SqlDbType.VarChar,20),
                    new SqlParameter("@CollName", SqlDbType.VarChar,50),
                    new SqlParameter("@OrgCode", SqlDbType.VarChar,10),
                    new SqlParameter("@VillageCode", SqlDbType.VarChar,4),
                    new SqlParameter("@MineOwner", SqlDbType.VarChar,20),
                    new SqlParameter("@MinePhone", SqlDbType.VarChar,30),
                    new SqlParameter("@YearOutput", SqlDbType.Decimal,9),
                    new SqlParameter("@CollState", SqlDbType.VarChar,10),
                    new SqlParameter("@ImageLicence", SqlDbType.VarChar,32),
                    new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32),
                    new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32),
                    new SqlParameter("@Remark", SqlDbType.VarChar,200),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
                    new SqlParameter("@CollProperty",SqlDbType.VarChar,1),
                    new SqlParameter("@ParcelCode",SqlDbType.VarChar,10)};

                    parameters[0].Value = coll.CollCode;
                    parameters[1].Value = coll.CollName;
                    parameters[2].Value = coll.OrgCode;
                    parameters[3].Value = coll.VillageCode;
                    parameters[4].Value = coll.MineOwner;
                    parameters[5].Value = coll.MinePhone;
                    parameters[6].Value = coll.YearOutput;
                    parameters[7].Value = coll.CollState;
                    parameters[8].Value = coll.ImageLicence;
                    parameters[9].Value = coll.ImageRevenue;
                    parameters[10].Value = coll.ImageCompetency;
                    parameters[11].Value = coll.Remark;
                    parameters[12].Value = coll.IsForbid;
                    parameters[13].Value = coll.CollProperty;//煤矿属性
                    parameters[14].Value = coll.ParcelCode;

                    listSql.Add(strSql.ToString());
                    listParm.Add(parameters);

                    foreach (IndustryPlatform.Model.Sys_FileSave model in listModel)
                    {
                        strSql = new StringBuilder();

                        if ("0" != Getresult("count(*)", "Sys_FileSave", "FileCode='" + model.FileCode + "'"))
                        {
                            strSql.Append("update Sys_FileSave set ");
                            strSql.Append("FileName=@FileName,");
                            strSql.Append("FilePath=@FilePath,");
                            strSql.Append("FileSize=@FileSize,");
                            strSql.Append("FileType=@FileType,");
                            strSql.Append("FileContent=@FileContent");
                            strSql.Append(" where FileCode=@FileCode ");
                            SqlParameter[] parameters2 = {
                                new SqlParameter("@FileCode", SqlDbType.VarChar,32),
                                new SqlParameter("@FileName", SqlDbType.VarChar,50),
                                new SqlParameter("@FilePath", SqlDbType.VarChar,200),
                                new SqlParameter("@FileSize", SqlDbType.Decimal,9),
                                new SqlParameter("@FileType", SqlDbType.VarChar,32),
                                new SqlParameter("@FileContent", SqlDbType.VarBinary)
                                };
                            parameters2[0].Value = model.FileCode;
                            parameters2[1].Value = model.FileName;
                            parameters2[2].Value = model.FilePath;
                            parameters2[3].Value = model.FileSize;
                            parameters2[4].Value = model.FileType;
                            parameters2[5].Value = model.FileContent;
                            listSql.Add(strSql.ToString());
                            listParm.Add(parameters2);

                        }
                        else
                        {
                            strSql.Append("insert into Sys_FileSave(");
                            strSql.Append("FileCode,FileName,FilePath,FileSize,FileType,FileContent)");
                            strSql.Append(" values (");
                            strSql.Append("@FileCode,@FileName,@FilePath,@FileSize,@FileType,@FileContent)");
                            SqlParameter[] parameters2 = {
                            new SqlParameter("@FileCode", SqlDbType.VarChar,32),
                            new SqlParameter("@FileName", SqlDbType.VarChar,50),
                            new SqlParameter("@FilePath", SqlDbType.VarChar,200),
                            new SqlParameter("@FileSize", SqlDbType.Decimal,9),
                            new SqlParameter("@FileType", SqlDbType.VarChar,32),
                            new SqlParameter("@FileContent", SqlDbType.VarBinary)
                                                         };

                            parameters2[0].Value = model.FileCode;
                            parameters2[1].Value = model.FileName;
                            parameters2[2].Value = model.FilePath;
                            parameters2[3].Value = model.FileSize;
                            parameters2[4].Value = model.FileType;
                            parameters2[5].Value = model.FileContent;
                            listSql.Add(strSql.ToString());
                            listParm.Add(parameters2);

                        }
                    }

                    return DbHelperSQL.ExecuteSqlCake(listSql, listParm);
                }
            }
            catch
            {
                return false;
            }
        }
        public bool Add(IndustryPlatform.Model.Sys_Colliery coll, List<IndustryPlatform.Model.Sys_FileSave> listModel)
        {
            try
            {
                lock (this)
                {
                    StringBuilder strSql = new StringBuilder();
                    List<string> listSql = new List<string>();
                    List<SqlParameter[]> listParm = new List<SqlParameter[]>();

                    strSql.Append("insert into Sys_Colliery(");
                    strSql.Append("CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,ImageRevenue,ImageCompetency,Remark,IsForbid,CollProperty,ParcelCode)");
                    strSql.Append(" values (");
                    strSql.Append("@CollCode,@CollName,@OrgCode,@VillageCode,@MineOwner,@MinePhone,@YearOutput,@CollState,@ImageLicence,@ImageRevenue,@ImageCompetency,@Remark,@IsForbid,@CollProperty,@ParcelCode)");
                    SqlParameter[] parameters = {

                    new SqlParameter("@CollCode", SqlDbType.VarChar,20),
                    new SqlParameter("@CollName", SqlDbType.VarChar,50),
                    new SqlParameter("@OrgCode", SqlDbType.VarChar,10),
                    new SqlParameter("@VillageCode", SqlDbType.VarChar,4),
                    new SqlParameter("@MineOwner", SqlDbType.VarChar,20),
                    new SqlParameter("@MinePhone", SqlDbType.VarChar,30),
                    new SqlParameter("@YearOutput", SqlDbType.Decimal,9),
                    new SqlParameter("@CollState", SqlDbType.VarChar,10),
                    new SqlParameter("@ImageLicence", SqlDbType.VarChar,32),
                    new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32),
                    new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32),
                    new SqlParameter("@Remark", SqlDbType.VarChar,200),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
                    new SqlParameter("@CollProperty",SqlDbType.VarChar,1),
                    new SqlParameter("@ParcelCode",SqlDbType.VarChar,10)};

                    parameters[0].Value = coll.CollCode;
                    parameters[1].Value = coll.CollName;
                    parameters[2].Value = coll.OrgCode;
                    parameters[3].Value = coll.VillageCode;
                    parameters[4].Value = coll.MineOwner;
                    parameters[5].Value = coll.MinePhone;
                    parameters[6].Value = coll.YearOutput;
                    parameters[7].Value = coll.CollState;
                    parameters[8].Value = coll.ImageLicence;
                    parameters[9].Value = coll.ImageRevenue;
                    parameters[10].Value = coll.ImageCompetency;
                    parameters[11].Value = coll.Remark;
                    parameters[12].Value = coll.IsForbid;
                    parameters[13].Value = coll.CollProperty;//煤矿属性
                    parameters[14].Value = coll.ParcelCode;
                    listSql.Add(strSql.ToString());
                    listParm.Add(parameters);

                    //保存煤矿最低余额
                    strSql = new StringBuilder();
                    strSql.Append("insert into TT_ColieryAccount(CollCode) values (@CollCode)");
                    SqlParameter[] parameters3 = {
                    new SqlParameter("@CollCode", SqlDbType.VarChar,10)};
                    parameters3[0].Value = coll.CollCode;
                    listSql.Add(strSql.ToString());
                    listParm.Add(parameters3);

                    foreach (IndustryPlatform.Model.Sys_FileSave model in listModel)
                    {
                        strSql = new StringBuilder();
                        strSql.Append("insert into Sys_FileSave(");
                        strSql.Append("FileCode,FileName,FilePath,FileSize,FileType,FileContent)");
                        strSql.Append(" values (");
                        strSql.Append("@FileCode,@FileName,@FilePath,@FileSize,@FileType,@FileContent)");
                        SqlParameter[] parameters2 = {
                        new SqlParameter("@FileCode", SqlDbType.VarChar,32),
                        new SqlParameter("@FileName", SqlDbType.VarChar,50),
                        new SqlParameter("@FilePath", SqlDbType.VarChar,200),
                        new SqlParameter("@FileSize", SqlDbType.Decimal,9),
                        new SqlParameter("@FileType", SqlDbType.VarChar,50),
                        new SqlParameter("@FileContent", SqlDbType.VarBinary)
                       };
                        parameters2[0].Value = model.FileCode;
                        parameters2[1].Value = model.FileName;
                        parameters2[2].Value = model.FilePath;
                        parameters2[3].Value = model.FileSize;
                        parameters2[4].Value = model.FileType;
                        parameters2[5].Value = model.FileContent;

                        listSql.Add(strSql.ToString());
                        listParm.Add(parameters2);

                    }
                    return DbHelperSQL.ExecuteSqlCake(listSql, listParm);
                }
            }
            catch
            {
                return false;
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(IndustryPlatform.Model.Sys_Colliery model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Sys_Colliery(");
            strSql.Append("CollieryID,CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,LicenceImageType,ImageRevenue,RevenueImageType,ImageCompetency,CompetencyImageType,Remark,IsForbid,CollProperty)");
            strSql.Append(" values (");
            strSql.Append("@CollCode,@CollName,@OrgCode,@VillageCode,@MineOwner,@MinePhone,@YearOutput,@CollState,@ImageLicence,@ImageRevenue,@ImageCompetency,@Remark,@IsForbid,@CollProperty)");
            SqlParameter[] parameters = {

                    new SqlParameter("@CollCode", SqlDbType.VarChar,20),
                    new SqlParameter("@CollName", SqlDbType.VarChar,50),
                    new SqlParameter("@OrgCode", SqlDbType.Decimal,9),
                    new SqlParameter("@VillageCode", SqlDbType.VarChar,4),
                    new SqlParameter("@MineOwner", SqlDbType.VarChar,20),
                    new SqlParameter("@MinePhone", SqlDbType.VarChar,30),
                    new SqlParameter("@YearOutput", SqlDbType.Decimal,9),
                    new SqlParameter("@CollState", SqlDbType.VarChar,10),
                    new SqlParameter("@ImageLicence", SqlDbType.VarChar,32),
                    new SqlParameter("@ImageRevenue", SqlDbType.VarChar,32),
                    new SqlParameter("@ImageCompetency", SqlDbType.VarChar,32),
                    new SqlParameter("@Remark", SqlDbType.VarChar,200),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1),
                    new SqlParameter("@CollProperty",SqlDbType.VarChar,1)};

            parameters[0].Value = model.CollCode;
            parameters[1].Value = model.CollName;
            parameters[2].Value = model.OrgCode;
            parameters[3].Value = model.VillageCode;
            parameters[4].Value = model.MineOwner;
            parameters[5].Value = model.MinePhone;
            parameters[6].Value = model.YearOutput;
            parameters[7].Value = model.CollState;
            parameters[8].Value = model.ImageLicence;

            parameters[9].Value = model.ImageRevenue;

            parameters[10].Value = model.ImageCompetency;

            parameters[11].Value = model.Remark;
            parameters[12].Value = model.IsForbid;
            parameters[13].Value = model.CollProperty;//煤矿属性
            return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
 public bool Add(IndustryPlatform.Model.Sys_Colliery coll, List<IndustryPlatform.Model.Sys_FileSave> listModel)
 {
     return dal.Add(coll, listModel);
 }
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(IndustryPlatform.Model.Sys_Colliery model)
 {
     return dal.Add(model);
 }
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public int Update(IndustryPlatform.Model.Sys_Colliery model)
 {
     return dal.Update(model);
 }
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(IndustryPlatform.Model.SYS_DictionaryEntity model)
 {
     return dal.Add(model);
 }
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(IndustryPlatform.Model.SYS_DictionaryEntity model)
 {
     return dal.Update(model);
 }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(IndustryPlatform.Model.SYS_DictionaryEntity model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Sys_Dictionary set ");
            strSql.Append("BusinName=@BusinName,");
            strSql.Append("DisplayOrder=@DisplayOrder,");
            strSql.Append("IsForbid=@IsForbid");
            strSql.Append(" where BusinID=@BusinID and BusinTypeID=@BusinTypeID ");
            SqlParameter[] parameters = {
                    new SqlParameter("@BusinID", SqlDbType.VarChar,10),
                    new SqlParameter("@BusinName", SqlDbType.NVarChar,50),
                    new SqlParameter("@BusinTypeID", SqlDbType.VarChar,10),
                    new SqlParameter("@DisplayOrder", SqlDbType.Decimal,5),
                    new SqlParameter("@IsForbid", SqlDbType.VarChar,1)};
            parameters[0].Value = model.BusinID;
            parameters[1].Value = model.BusinName;
            parameters[2].Value = model.BusinTypeID;
            parameters[3].Value = model.DisplayOrder;
            parameters[4].Value = model.IsForbid;

            try
            {
                DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
                return true;
            }
            catch(Exception ex)
            { return false; }
        }