/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MultiColorPen.Model.base_caragentinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into base_caragentinfo(");
strSql.Append("id,caragentcode,caragenttype,caragentname,isenable,address,phone,avatar,wechaturl,sort,remark,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?id,?caragentcode,?caragenttype,?caragentname,?isenable,?address,?phone,?avatar,?wechaturl,?sort,?remark,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?caragentcode", MySqlDbType.VarChar, 30),
new MySqlParameter("?caragenttype", MySqlDbType.VarChar, 10),
new MySqlParameter("?caragentname", MySqlDbType.VarChar, 50),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?address", MySqlDbType.VarChar, 200),
new MySqlParameter("?phone", MySqlDbType.VarChar, 12),
new MySqlParameter("?avatar", MySqlDbType.Text),
new MySqlParameter("?wechaturl", MySqlDbType.Text),
new MySqlParameter("?sort", MySqlDbType.Int32, 11),
new MySqlParameter("?remark", MySqlDbType.VarChar, 200),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36)
};
parameters[0].Value = model.id;
parameters[1].Value = model.caragentcode;
parameters[2].Value = model.caragenttype;
parameters[3].Value = model.caragentname;
parameters[4].Value = model.isenable;
parameters[5].Value = model.address;
parameters[6].Value = model.phone;
parameters[7].Value = model.avatar;
parameters[8].Value = model.wechaturl;
parameters[9].Value = model.sort;
parameters[10].Value = model.remark;
parameters[11].Value = model.createtime;
parameters[12].Value = model.createman;
parameters[13].Value = model.updatetime;
parameters[14].Value = model.updateman;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* MySqlParameter[] parameters = {
* new MySqlParameter("?tblName", MySqlDbType.VarChar, 255),
* new MySqlParameter("?fldName", MySqlDbType.VarChar, 255),
* new MySqlParameter("?PageSize", MySqlDbType.Int32),
* new MySqlParameter("?PageIndex", MySqlDbType.Int32),
* new MySqlParameter("?IsReCount", MySqlDbType.Bit),
* new MySqlParameter("?OrderType", MySqlDbType.Bit),
* new MySqlParameter("?strWhere", MySqlDbType.VarChar,1000),
* };
* parameters[0].Value = "base_caragentinfo";
* parameters[1].Value = "caragentcode";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperMySQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_caragentinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, caragentcode, caragenttype, caragentname, isenable, address, phone, avatar, wechaturl, sort, remark, createtime, createman, updatetime, updateman ");
strSql.Append(" from base_caragentinfo ");
strSql.Append(" where id=" + id);
MultiColorPen.Model.base_caragentinfo model = new MultiColorPen.Model.base_caragentinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.caragentcode = ds.Tables[0].Rows[0]["caragentcode"].ToString();
model.caragenttype = ds.Tables[0].Rows[0]["caragenttype"].ToString();
model.caragentname = ds.Tables[0].Rows[0]["caragentname"].ToString();
if (ds.Tables[0].Rows[0]["isenable"].ToString() != "")
{
model.isenable = int.Parse(ds.Tables[0].Rows[0]["isenable"].ToString());
}
model.address = ds.Tables[0].Rows[0]["address"].ToString();
model.phone = ds.Tables[0].Rows[0]["phone"].ToString();
model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString();
model.wechaturl = ds.Tables[0].Rows[0]["wechaturl"].ToString();
if (ds.Tables[0].Rows[0]["sort"].ToString() != "")
{
model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString());
}
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(ds.Tables[0].Rows[0]["createtime"].ToString());
}
model.createman = ds.Tables[0].Rows[0]["createman"].ToString();
if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(ds.Tables[0].Rows[0]["updatetime"].ToString());
}
model.updateman = ds.Tables[0].Rows[0]["updateman"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_caragentinfo GetModel(string caragentcode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,caragentcode,caragenttype,caragentname,isenable,address,phone,avatar,wechaturl,sort,remark,createtime,createman,updatetime,updateman from base_caragentinfo ");
strSql.Append(" where caragentcode=?caragentcode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?caragentcode", MySqlDbType.VarChar, 30)
};
parameters[0].Value = caragentcode;
MultiColorPen.Model.base_caragentinfo model = new MultiColorPen.Model.base_caragentinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.base_caragentinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update base_caragentinfo set ");
strSql.Append("id=?id,");
strSql.Append("caragenttype=?caragenttype,");
strSql.Append("caragentname=?caragentname,");
strSql.Append("isenable=?isenable,");
strSql.Append("address=?address,");
strSql.Append("phone=?phone,");
strSql.Append("avatar=?avatar,");
strSql.Append("wechaturl=?wechaturl,");
strSql.Append("sort=?sort,");
strSql.Append("remark=?remark,");
strSql.Append("createtime=?createtime,");
strSql.Append("createman=?createman,");
strSql.Append("updatetime=?updatetime,");
strSql.Append("updateman=?updateman");
strSql.Append(" where caragentcode=?caragentcode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?caragenttype", MySqlDbType.VarChar, 10),
new MySqlParameter("?caragentname", MySqlDbType.VarChar, 50),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?address", MySqlDbType.VarChar, 200),
new MySqlParameter("?phone", MySqlDbType.VarChar, 12),
new MySqlParameter("?avatar", MySqlDbType.Text),
new MySqlParameter("?wechaturl", MySqlDbType.Text),
new MySqlParameter("?sort", MySqlDbType.Int32, 11),
new MySqlParameter("?remark", MySqlDbType.VarChar, 200),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36),
new MySqlParameter("?caragentcode", MySqlDbType.VarChar, 30)
};
parameters[0].Value = model.id;
parameters[1].Value = model.caragenttype;
parameters[2].Value = model.caragentname;
parameters[3].Value = model.isenable;
parameters[4].Value = model.address;
parameters[5].Value = model.phone;
parameters[6].Value = model.avatar;
parameters[7].Value = model.wechaturl;
parameters[8].Value = model.sort;
parameters[9].Value = model.remark;
parameters[10].Value = model.createtime;
parameters[11].Value = model.createman;
parameters[12].Value = model.updatetime;
parameters[13].Value = model.updateman;
parameters[14].Value = model.caragentcode;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_caragentinfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.base_caragentinfo model = new MultiColorPen.Model.base_caragentinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["caragentcode"] != null)
{
model.caragentcode = row["caragentcode"].ToString();
}
if (row["caragenttype"] != null)
{
model.caragenttype = row["caragenttype"].ToString();
}
if (row["caragentname"] != null)
{
model.caragentname = row["caragentname"].ToString();
}
if (row["isenable"] != null && row["isenable"].ToString() != "")
{
model.isenable = int.Parse(row["isenable"].ToString());
}
if (row["address"] != null)
{
model.address = row["address"].ToString();
}
if (row["phone"] != null)
{
model.phone = row["phone"].ToString();
}
if (row["avatar"] != null)
{
model.avatar = row["avatar"].ToString();
}
if (row["wechaturl"] != null)
{
model.wechaturl = row["wechaturl"].ToString();
}
if (row["sort"] != null && row["sort"].ToString() != "")
{
model.sort = int.Parse(row["sort"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createtime"] != null && row["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
if (row["createman"] != null)
{
model.createman = row["createman"].ToString();
}
if (row["updatetime"] != null && row["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(row["updatetime"].ToString());
}
if (row["updateman"] != null)
{
model.updateman = row["updateman"].ToString();
}
}
return(model);
}