public List <Model_visit_client_s> DataTableToList(DataTable dt)
{
List <Model_visit_client_s> list = new List <Model_visit_client_s>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_visit_client_s item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_visit_client_s model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into visit_client_s(");
builder.Append("visit_client_id,user_id,resource_data_id,product_type,tab_id,open_time,close_time,operate_type)");
builder.Append(" values (");
builder.Append("@visit_client_id,@user_id,@resource_data_id,@product_type,@tab_id,@open_time,@close_time,@operate_type)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@visit_client_id", SqlDbType.Char, 0x24), new SqlParameter("@user_id", SqlDbType.Char, 0x24), new SqlParameter("@resource_data_id", SqlDbType.Char, 0x24), new SqlParameter("@product_type", SqlDbType.VarChar, 50), new SqlParameter("@tab_id", SqlDbType.VarChar, 100), new SqlParameter("@open_time", SqlDbType.DateTime), new SqlParameter("@close_time", SqlDbType.DateTime), new SqlParameter("@operate_type", SqlDbType.VarChar, 10) };
cmdParms[0].Value = model.visit_client_id;
cmdParms[1].Value = model.user_id;
cmdParms[2].Value = model.resource_data_id;
cmdParms[3].Value = model.product_type;
cmdParms[4].Value = model.tab_id;
cmdParms[5].Value = model.open_time;
cmdParms[6].Value = model.close_time;
cmdParms[7].Value = model.operate_type;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_visit_client_s DataRowToModel(DataRow row)
{
Model_visit_client_s _s = new Model_visit_client_s();
if (row != null)
{
if (row["visit_client_id"] != null)
{
_s.visit_client_id = row["visit_client_id"].ToString();
}
if (row["user_id"] != null)
{
_s.user_id = row["user_id"].ToString();
}
if (row["resource_data_id"] != null)
{
_s.resource_data_id = row["resource_data_id"].ToString();
}
if (row["product_type"] != null)
{
_s.product_type = row["product_type"].ToString();
}
if (row["tab_id"] != null)
{
_s.tab_id = row["tab_id"].ToString();
}
if ((row["open_time"] != null) && (row["open_time"].ToString() != ""))
{
_s.open_time = new DateTime?(DateTime.Parse(row["open_time"].ToString()));
}
if ((row["close_time"] != null) && (row["close_time"].ToString() != ""))
{
_s.close_time = new DateTime?(DateTime.Parse(row["close_time"].ToString()));
}
if (row["operate_type"] != null)
{
_s.operate_type = row["operate_type"].ToString();
}
}
return(_s);
}
public bool Update(Model_visit_client_s model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update visit_client_s set ");
builder.Append("user_id=@user_id,");
builder.Append("resource_data_id=@resource_data_id,");
builder.Append("product_type=@product_type,");
builder.Append("tab_id=@tab_id,");
builder.Append("open_time=@open_time,");
builder.Append("close_time=@close_time,");
builder.Append("operate_type=@operate_type");
builder.Append(" where visit_client_id=@visit_client_id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@user_id", SqlDbType.Char, 0x24), new SqlParameter("@resource_data_id", SqlDbType.Char, 0x24), new SqlParameter("@product_type", SqlDbType.VarChar, 50), new SqlParameter("@tab_id", SqlDbType.VarChar, 100), new SqlParameter("@open_time", SqlDbType.DateTime), new SqlParameter("@close_time", SqlDbType.DateTime), new SqlParameter("@operate_type", SqlDbType.VarChar, 10), new SqlParameter("@visit_client_id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.user_id;
cmdParms[1].Value = model.resource_data_id;
cmdParms[2].Value = model.product_type;
cmdParms[3].Value = model.tab_id;
cmdParms[4].Value = model.open_time;
cmdParms[5].Value = model.close_time;
cmdParms[6].Value = model.operate_type;
cmdParms[7].Value = model.visit_client_id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(Model_visit_client_s model)
{
return(this.dal.Update(model));
}
public bool Add(Model_visit_client_s model)
{
return(this.dal.Add(model));
}
