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