/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TFXK.Model.TestingCenter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_TestingCenter(");
strSql.Append("KDName,Address,UserName,UserPhone,UserTel,UserEmail,UserPass,KDDescription,IDNo,IDImage,IDImage2,WorkImage,KDLogo,Status,CreateTime)");
strSql.Append(" values (");
strSql.Append("@KDName,@Address,@UserName,@UserPhone,@UserTel,@UserEmail,@UserPass,@KDDescription,@IDNo,@IDImage,@IDImage2,@WorkImage,@KDLogo,@Status,@CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@KDName", SqlDbType.VarChar, 100),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@UserPhone", SqlDbType.VarChar, 100),
new SqlParameter("@UserTel", SqlDbType.VarChar, 100),
new SqlParameter("@UserEmail", SqlDbType.VarChar, 100),
new SqlParameter("@UserPass", SqlDbType.VarChar, 100),
new SqlParameter("@KDDescription", SqlDbType.Text),
new SqlParameter("@IDNo", SqlDbType.VarChar, 50),
new SqlParameter("@IDImage", SqlDbType.VarChar, 100),
new SqlParameter("@IDImage2", SqlDbType.VarChar, 100),
new SqlParameter("@WorkImage", SqlDbType.VarChar, 100),
new SqlParameter("@KDLogo", SqlDbType.VarChar, 100),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.KDName;
parameters[1].Value = model.Address;
parameters[2].Value = model.UserName;
parameters[3].Value = model.UserPhone;
parameters[4].Value = model.UserTel;
parameters[5].Value = model.UserEmail;
parameters[6].Value = model.UserPass;
parameters[7].Value = model.KDDescription;
parameters[8].Value = model.IDNo;
parameters[9].Value = model.IDImage;
parameters[10].Value = model.IDImage2;
parameters[11].Value = model.WorkImage;
parameters[12].Value = model.KDLogo;
parameters[13].Value = model.Status;
parameters[14].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public TFXK.Model.TestingCenter GetModelByName(string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,KDName,Address,UserName,UserPhone,UserTel,UserEmail,UserPass,KDDescription,IDNo,IDImage,IDImage2,WorkImage,KDLogo,Status,CreateTime from tb_TestingCenter ");
strSql.Append(" where KDName=@KDName");
SqlParameter[] parameters =
{
new SqlParameter("@KDName", SqlDbType.VarChar, 100)
};
parameters[0].Value = name;
TFXK.Model.TestingCenter model = new TFXK.Model.TestingCenter();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TFXK.Model.TestingCenter DataRowToModel(DataRow row)
{
TFXK.Model.TestingCenter model = new TFXK.Model.TestingCenter();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["KDName"] != null)
{
model.KDName = row["KDName"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserPhone"] != null)
{
model.UserPhone = row["UserPhone"].ToString();
}
if (row["UserTel"] != null)
{
model.UserTel = row["UserTel"].ToString();
}
if (row["UserEmail"] != null)
{
model.UserEmail = row["UserEmail"].ToString();
}
if (row["UserPass"] != null)
{
model.UserPass = row["UserPass"].ToString();
}
if (row["KDDescription"] != null)
{
model.KDDescription = row["KDDescription"].ToString();
}
if (row["IDNo"] != null)
{
model.IDNo = row["IDNo"].ToString();
}
if (row["IDImage"] != null)
{
model.IDImage = row["IDImage"].ToString();
}
if (row["IDImage2"] != null)
{
model.IDImage2 = row["IDImage2"].ToString();
}
if (row["WorkImage"] != null)
{
model.WorkImage = row["WorkImage"].ToString();
}
if (row["KDLogo"] != null)
{
model.KDLogo = row["KDLogo"].ToString();
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TFXK.Model.TestingCenter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_TestingCenter set ");
strSql.Append("KDName=@KDName,");
strSql.Append("Address=@Address,");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPhone=@UserPhone,");
strSql.Append("UserTel=@UserTel,");
strSql.Append("UserEmail=@UserEmail,");
strSql.Append("UserPass=@UserPass,");
strSql.Append("KDDescription=@KDDescription,");
strSql.Append("IDImage=@IDImage,");
strSql.Append("IDImage2=@IDImage2,");
strSql.Append("WorkImage=@WorkImage,");
strSql.Append("KDLogo=@KDLogo,");
strSql.Append("Status=@Status,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("IDNo=@IDNo");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@KDName", SqlDbType.VarChar, 100),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@UserPhone", SqlDbType.VarChar, 100),
new SqlParameter("@UserTel", SqlDbType.VarChar, 100),
new SqlParameter("@UserEmail", SqlDbType.VarChar, 100),
new SqlParameter("@UserPass", SqlDbType.VarChar, 100),
new SqlParameter("@KDDescription", SqlDbType.Text),
new SqlParameter("@IDImage", SqlDbType.VarChar, 100),
new SqlParameter("@IDImage2", SqlDbType.VarChar, 100),
new SqlParameter("@WorkImage", SqlDbType.VarChar, 100),
new SqlParameter("@KDLogo", SqlDbType.VarChar, 100),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IDNo", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.KDName;
parameters[1].Value = model.Address;
parameters[2].Value = model.UserName;
parameters[3].Value = model.UserPhone;
parameters[4].Value = model.UserTel;
parameters[5].Value = model.UserEmail;
parameters[6].Value = model.UserPass;
parameters[7].Value = model.KDDescription;
parameters[8].Value = model.IDImage;
parameters[9].Value = model.IDImage2;
parameters[10].Value = model.WorkImage;
parameters[11].Value = model.KDLogo;
parameters[12].Value = model.Status;
parameters[13].Value = model.CreateTime;
parameters[14].Value = model.IDNo;
parameters[15].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
