public List <PEIS.Model.BusPEPackage> DataTableToList(DataTable dt) { List <PEIS.Model.BusPEPackage> list = new List <PEIS.Model.BusPEPackage>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.BusPEPackage pePackage = new PEIS.Model.BusPEPackage(); if (dt.Rows[i]["PEPackageID"].ToString() != "") { pePackage.PEPackageID = int.Parse(dt.Rows[i]["PEPackageID"].ToString()); } pePackage.PEPackageName = dt.Rows[i]["PEPackageName"].ToString(); if (dt.Rows[i]["Forsex"].ToString() != "") { pePackage.Forsex = new int?(int.Parse(dt.Rows[i]["Forsex"].ToString())); } if (dt.Rows[i]["CreatorID"].ToString() != "") { pePackage.CreatorID = new int?(int.Parse(dt.Rows[i]["CreatorID"].ToString())); } if (dt.Rows[i]["CreateDate"].ToString() != "") { pePackage.CreateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["CreateDate"].ToString())); } if (dt.Rows[i]["isBanned"].ToString() != "") { if (dt.Rows[i]["isBanned"].ToString() == "1" || dt.Rows[i]["isBanned"].ToString().ToLower() == "true") { pePackage.isBanned = true; } else { pePackage.isBanned = false; } } if (dt.Rows[i]["IDBanOpr"].ToString() != "") { pePackage.IDBanOpr = new int?(int.Parse(dt.Rows[i]["IDBanOpr"].ToString())); } if (dt.Rows[i]["BanDate"].ToString() != "") { pePackage.BanDate = new DateTime?(DateTime.Parse(dt.Rows[i]["BanDate"].ToString())); } pePackage.BanDescribe = dt.Rows[i]["BanDescribe"].ToString(); pePackage.InputCode = dt.Rows[i]["InputCode"].ToString(); if (dt.Rows[i]["DispOrder"].ToString() != "") { pePackage.DispOrder = new int?(int.Parse(dt.Rows[i]["DispOrder"].ToString())); } pePackage.Note = dt.Rows[i]["Note"].ToString(); list.Add(pePackage); } } return(list); }
public bool Update(PEIS.Model.BusPEPackage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BusPEPackage set "); strSql.Append("PEPackageName=@PEPackageName,"); strSql.Append("Forsex=@Forsex,"); strSql.Append("CreatorID=@CreatorID,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("isBanned=@isBanned,"); strSql.Append("IDBanOpr=@IDBanOpr,"); strSql.Append("BanDate=@BanDate,"); strSql.Append("BanDescribe=@BanDescribe,"); strSql.Append("InputCode=@InputCode,"); strSql.Append("DispOrder=@DispOrder,"); strSql.Append("Note=@Note"); strSql.Append(" where PEPackageID=@PEPackageID "); SqlParameter[] parameters = { new SqlParameter("@PEPackageName", SqlDbType.VarChar, 50), new SqlParameter("@Forsex", SqlDbType.Int, 4), new SqlParameter("@CreatorID", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.SmallDateTime), new SqlParameter("@isBanned", SqlDbType.Bit, 1), new SqlParameter("@IDBanOpr", SqlDbType.Int, 4), new SqlParameter("@BanDate", SqlDbType.SmallDateTime), new SqlParameter("@BanDescribe", SqlDbType.VarChar, 50), new SqlParameter("@InputCode", SqlDbType.VarChar, 30), new SqlParameter("@DispOrder", SqlDbType.Int, 4), new SqlParameter("@Note", SqlDbType.VarChar, 50), new SqlParameter("@PEPackageID", SqlDbType.Int, 4) }; parameters[0].Value = model.PEPackageName; parameters[1].Value = model.Forsex; parameters[2].Value = model.CreatorID; parameters[3].Value = model.CreateDate; parameters[4].Value = model.isBanned; parameters[5].Value = model.IDBanOpr; parameters[6].Value = model.BanDate; parameters[7].Value = model.BanDescribe; parameters[8].Value = model.InputCode; parameters[9].Value = model.DispOrder; parameters[10].Value = model.Note; parameters[11].Value = model.PEPackageID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(PEIS.Model.BusPEPackage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BusPEPackage("); strSql.Append("PEPackageID,PEPackageName,Forsex,CreatorID,CreateDate,isBanned,IDBanOpr,BanDate,BanDescribe,InputCode,DispOrder,Note)"); strSql.Append(" values ("); strSql.Append("@PEPackageID,@PEPackageName,@Forsex,@CreatorID,@CreateDate,@isBanned,@IDBanOpr,@BanDate,@BanDescribe,@InputCode,@DispOrder,@Note)"); SqlParameter[] parameters = { new SqlParameter("@PEPackageID", SqlDbType.Int, 4), new SqlParameter("@PEPackageName", SqlDbType.VarChar, 50), new SqlParameter("@Forsex", SqlDbType.Int, 4), new SqlParameter("@CreatorID", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.SmallDateTime), new SqlParameter("@isBanned", SqlDbType.Bit, 1), new SqlParameter("@IDBanOpr", SqlDbType.Int, 4), new SqlParameter("@BanDate", SqlDbType.SmallDateTime), new SqlParameter("@BanDescribe", SqlDbType.VarChar, 50), new SqlParameter("@InputCode", SqlDbType.VarChar, 30), new SqlParameter("@DispOrder", SqlDbType.Int, 4), new SqlParameter("@Note", SqlDbType.VarChar, 50) }; parameters[0].Value = model.PEPackageID; parameters[1].Value = model.PEPackageName; parameters[2].Value = model.Forsex; parameters[3].Value = model.CreatorID; parameters[4].Value = model.CreateDate; parameters[5].Value = model.isBanned; parameters[6].Value = model.IDBanOpr; parameters[7].Value = model.BanDate; parameters[8].Value = model.BanDescribe; parameters[9].Value = model.InputCode; parameters[10].Value = model.DispOrder; parameters[11].Value = model.Note; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(0); } else { return(1); } }
protected void GetEditSetInfo(ref VelocityContext vltContext) { int @int = base.GetInt("PEPackageID", 0); if (@int > 0) { PEIS.Model.BusPEPackage model = PEIS.BLL.BusPEPackage.Instance.GetModel(@int); vltContext.Put("PEPackageID", model.PEPackageID); vltContext.Put("PEPackageName", model.PEPackageName); vltContext.Put("IDBanOpr", model.IDBanOpr); vltContext.Put("CreatorID", model.CreatorID); vltContext.Put("InputCode", model.InputCode); vltContext.Put("isBanned", model.isBanned); vltContext.Put("Note", model.Note); vltContext.Put("BanDescribe", model.BanDescribe); vltContext.Put("DispOrder", model.DispOrder); vltContext.Put("BanDate", model.BanDate); vltContext.Put("CreateDate", model.CreateDate); vltContext.Put("Forsex", model.Forsex); } }
public PEIS.Model.BusPEPackage GetModel(int PEPackageID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 PEPackageID,PEPackageName,Forsex,CreatorID,CreateDate,isBanned,IDBanOpr,BanDate,BanDescribe,InputCode,DispOrder,Note from BusPEPackage "); strSql.Append(" where PEPackageID=@PEPackageID "); SqlParameter[] parameters = { new SqlParameter("@PEPackageID", SqlDbType.Int, 4) }; parameters[0].Value = PEPackageID; PEIS.Model.BusPEPackage model = new PEIS.Model.BusPEPackage(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public int SaveBusPEPackage(PEIS.Model.BusPEPackage buspePackage) { return(CommonConfig.dal.SaveBusPEPackage(buspePackage)); }
public bool Update(PEIS.Model.BusPEPackage model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.BusPEPackage model) { return(this.dal.Add(model)); }
public PEIS.Model.BusPEPackage DataRowToModel(DataRow row) { PEIS.Model.BusPEPackage model = new PEIS.Model.BusPEPackage(); if (row != null) { if (row["PEPackageID"] != null && row["PEPackageID"].ToString() != "") { model.PEPackageID = int.Parse(row["PEPackageID"].ToString()); } if (row["PEPackageName"] != null) { model.PEPackageName = row["PEPackageName"].ToString(); } if (row["Forsex"] != null && row["Forsex"].ToString() != "") { model.Forsex = int.Parse(row["Forsex"].ToString()); } if (row["CreatorID"] != null && row["CreatorID"].ToString() != "") { model.CreatorID = int.Parse(row["CreatorID"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["isBanned"] != null && row["isBanned"].ToString() != "") { if ((row["isBanned"].ToString() == "1") || (row["isBanned"].ToString().ToLower() == "true")) { model.isBanned = true; } else { model.isBanned = false; } } if (row["IDBanOpr"] != null && row["IDBanOpr"].ToString() != "") { model.IDBanOpr = int.Parse(row["IDBanOpr"].ToString()); } if (row["BanDate"] != null && row["BanDate"].ToString() != "") { model.BanDate = DateTime.Parse(row["BanDate"].ToString()); } if (row["BanDescribe"] != null) { model.BanDescribe = row["BanDescribe"].ToString(); } if (row["InputCode"] != null) { model.InputCode = row["InputCode"].ToString(); } if (row["DispOrder"] != null && row["DispOrder"].ToString() != "") { model.DispOrder = int.Parse(row["DispOrder"].ToString()); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } } return(model); }