/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_Company_MDL GetModel(int CompanyID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CompanyID,AREA_CODE,CompanyName,CompanyCode,CompanyNameEn,CompanyType,Addres,ChargeUserName,CharegeID,ContactPerson,Zipcode,Tel,Fax,Mobile,EMail,Description,IsCompany,CreateDate,CreateIP,CreateUserID from T_Company "); strSql.Append(" where CompanyID=@CompanyID "); SqlParameter[] parameters = { new SqlParameter("@CompanyID", SqlDbType.Int, 8) }; parameters[0].Value = CompanyID; DigiPower.Onlinecol.Standard.Model.T_Company_MDL model = new DigiPower.Onlinecol.Standard.Model.T_Company_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(ds.Tables[0].Rows[0]["CompanyID"].ToString()); } model.AREA_CODE = ds.Tables[0].Rows[0]["AREA_CODE"].ToString(); model.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString(); model.CompanyCode = ds.Tables[0].Rows[0]["CompanyCode"].ToString(); model.CompanyNameEn = ds.Tables[0].Rows[0]["CompanyNameEn"].ToString(); if (ds.Tables[0].Rows[0]["CompanyType"].ToString() != "") { model.CompanyType = int.Parse(ds.Tables[0].Rows[0]["CompanyType"].ToString()); } model.Addres = ds.Tables[0].Rows[0]["Addres"].ToString(); model.ChargeUserName = ds.Tables[0].Rows[0]["ChargeUserName"].ToString(); model.CharegeID = ds.Tables[0].Rows[0]["CharegeID"].ToString(); model.ContactPerson = ds.Tables[0].Rows[0]["ContactPerson"].ToString(); model.Zipcode = ds.Tables[0].Rows[0]["Zipcode"].ToString(); model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString(); model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString(); model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); model.EMail = ds.Tables[0].Rows[0]["EMail"].ToString(); model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); if (ds.Tables[0].Rows[0]["IsCompany"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsCompany"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsCompany"].ToString().ToLower() == "true")) { model.IsCompany = true; } else { model.IsCompany = false; } } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } model.CreateIP = ds.Tables[0].Rows[0]["CreateIP"].ToString(); if (ds.Tables[0].Rows[0]["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(ds.Tables[0].Rows[0]["CreateUserID"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DigiPower.Onlinecol.Standard.Model.T_Company_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Company("); strSql.Append("AREA_CODE,CompanyName,CompanyCode,CompanyNameEn,CompanyType,Addres,ChargeUserName,CharegeID,ContactPerson,Zipcode,Tel,Fax,Mobile,EMail,Description,IsCompany,CreateDate,CreateIP,CreateUserID)"); strSql.Append(" values ("); strSql.Append("@AREA_CODE,@CompanyName,@CompanyCode,@CompanyNameEn,@CompanyType,@Addres,@ChargeUserName,@CharegeID,@ContactPerson,@Zipcode,@Tel,@Fax,@Mobile,@EMail,@Description,@IsCompany,@CreateDate,@CreateIP,@CreateUserID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@AREA_CODE", SqlDbType.VarChar, 8), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 200), new SqlParameter("@CompanyCode", SqlDbType.NChar, 60), new SqlParameter("@CompanyNameEn", SqlDbType.NVarChar, 200), new SqlParameter("@CompanyType", SqlDbType.Int, 8), new SqlParameter("@Addres", SqlDbType.NVarChar, 100), new SqlParameter("@ChargeUserName", SqlDbType.NVarChar, 50), new SqlParameter("@CharegeID", SqlDbType.NVarChar, 20), new SqlParameter("@ContactPerson", SqlDbType.NVarChar, 20), new SqlParameter("@Zipcode", SqlDbType.NVarChar, 20), new SqlParameter("@Tel", SqlDbType.NVarChar, 20), new SqlParameter("@Fax", SqlDbType.NVarChar, 20), new SqlParameter("@Mobile", SqlDbType.NVarChar, 20), new SqlParameter("@EMail", SqlDbType.NVarChar, 60), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@IsCompany", SqlDbType.Bit, 1), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CreateIP", SqlDbType.NVarChar, 20), new SqlParameter("@CreateUserID", SqlDbType.Int, 8) }; parameters[0].Value = model.AREA_CODE; parameters[1].Value = model.CompanyName; parameters[2].Value = model.CompanyCode; parameters[3].Value = model.CompanyNameEn; parameters[4].Value = model.CompanyType; parameters[5].Value = model.Addres; parameters[6].Value = model.ChargeUserName; parameters[7].Value = model.CharegeID; parameters[8].Value = model.ContactPerson; parameters[9].Value = model.Zipcode; parameters[10].Value = model.Tel; parameters[11].Value = model.Fax; parameters[12].Value = model.Mobile; parameters[13].Value = model.EMail; parameters[14].Value = model.Description; parameters[15].Value = model.IsCompany; parameters[16].Value = model.CreateDate; parameters[17].Value = model.CreateIP; parameters[18].Value = model.CreateUserID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.T_Company_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Company set "); strSql.Append("AREA_CODE=@AREA_CODE,"); strSql.Append("CompanyName=@CompanyName,"); strSql.Append("CompanyCode=@CompanyCode,"); strSql.Append("CompanyNameEn=@CompanyNameEn,"); strSql.Append("CompanyType=@CompanyType,"); strSql.Append("Addres=@Addres,"); strSql.Append("ChargeUserName=@ChargeUserName,"); strSql.Append("CharegeID=@CharegeID,"); strSql.Append("ContactPerson=@ContactPerson,"); strSql.Append("Zipcode=@Zipcode,"); strSql.Append("Tel=@Tel,"); strSql.Append("Fax=@Fax,"); strSql.Append("Mobile=@Mobile,"); strSql.Append("EMail=@EMail,"); strSql.Append("Description=@Description,"); strSql.Append("IsCompany=@IsCompany,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("CreateIP=@CreateIP,"); strSql.Append("CreateUserID=@CreateUserID"); strSql.Append(" where CompanyID=@CompanyID "); SqlParameter[] parameters = { new SqlParameter("@CompanyID", SqlDbType.Int, 8), new SqlParameter("@AREA_CODE", SqlDbType.VarChar, 8), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 200), new SqlParameter("@CompanyCode", SqlDbType.NChar, 60), new SqlParameter("@CompanyNameEn", SqlDbType.NVarChar, 200), new SqlParameter("@CompanyType", SqlDbType.Int, 8), new SqlParameter("@Addres", SqlDbType.NVarChar, 100), new SqlParameter("@ChargeUserName", SqlDbType.NVarChar, 50), new SqlParameter("@CharegeID", SqlDbType.NVarChar, 20), new SqlParameter("@ContactPerson", SqlDbType.NVarChar, 20), new SqlParameter("@Zipcode", SqlDbType.NVarChar, 20), new SqlParameter("@Tel", SqlDbType.NVarChar, 20), new SqlParameter("@Fax", SqlDbType.NVarChar, 20), new SqlParameter("@Mobile", SqlDbType.NVarChar, 20), new SqlParameter("@EMail", SqlDbType.NVarChar, 60), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@IsCompany", SqlDbType.Bit, 1), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CreateIP", SqlDbType.NVarChar, 20), new SqlParameter("@CreateUserID", SqlDbType.Int, 8) }; parameters[0].Value = model.CompanyID; parameters[1].Value = model.AREA_CODE; parameters[2].Value = model.CompanyName; parameters[3].Value = model.CompanyCode; parameters[4].Value = model.CompanyNameEn; parameters[5].Value = model.CompanyType; parameters[6].Value = model.Addres; parameters[7].Value = model.ChargeUserName; parameters[8].Value = model.CharegeID; parameters[9].Value = model.ContactPerson; parameters[10].Value = model.Zipcode; parameters[11].Value = model.Tel; parameters[12].Value = model.Fax; parameters[13].Value = model.Mobile; parameters[14].Value = model.EMail; parameters[15].Value = model.Description; parameters[16].Value = model.IsCompany; parameters[17].Value = model.CreateDate; parameters[18].Value = model.CreateIP; parameters[19].Value = model.CreateUserID; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }