/// <summary>
/// 输出智能表单 返回一个字段的HTML的描述 方法
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public static string FormPut(ROYcms.Sys.Model.ROYcms_Field Model)
{
return(FormPut("", "", Model.Name, Model.Lable, Model.Len.ToString(), Model.FieldType.ToString(), Model.IsNull.ToString(), Model.DefaultVal, Model.Display.ToString(), Model.InputType.ToString(), Model.InputLen.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ROYcms.Sys.Model.ROYcms_Field GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Id,Rid,Name,Lable,Len,FieldType,IsNull,IsKey,DefaultVal,Display,Expression,InputType,InputLen,OrderBy,TIME ");
strSql.Append(" from " + PubConstant.date_prefix + "Field ");
strSql.Append(" where Id=" + Id + "");
ROYcms.Sys.Model.ROYcms_Field model = new ROYcms.Sys.Model.ROYcms_Field();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Rid"] != null && ds.Tables[0].Rows[0]["Rid"].ToString() != "")
{
model.Rid = int.Parse(ds.Tables[0].Rows[0]["Rid"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Lable"] != null && ds.Tables[0].Rows[0]["Lable"].ToString() != "")
{
model.Lable = ds.Tables[0].Rows[0]["Lable"].ToString();
}
if (ds.Tables[0].Rows[0]["Len"] != null && ds.Tables[0].Rows[0]["Len"].ToString() != "")
{
model.Len = int.Parse(ds.Tables[0].Rows[0]["Len"].ToString());
}
if (ds.Tables[0].Rows[0]["FieldType"] != null && ds.Tables[0].Rows[0]["FieldType"].ToString() != "")
{
model.FieldType = int.Parse(ds.Tables[0].Rows[0]["FieldType"].ToString());
}
if (ds.Tables[0].Rows[0]["IsNull"] != null && ds.Tables[0].Rows[0]["IsNull"].ToString() != "")
{
model.IsNull = int.Parse(ds.Tables[0].Rows[0]["IsNull"].ToString());
}
if (ds.Tables[0].Rows[0]["IsKey"] != null && ds.Tables[0].Rows[0]["IsKey"].ToString() != "")
{
model.IsKey = int.Parse(ds.Tables[0].Rows[0]["IsKey"].ToString());
}
if (ds.Tables[0].Rows[0]["DefaultVal"] != null && ds.Tables[0].Rows[0]["DefaultVal"].ToString() != "")
{
model.DefaultVal = ds.Tables[0].Rows[0]["DefaultVal"].ToString();
}
if (ds.Tables[0].Rows[0]["Display"] != null && ds.Tables[0].Rows[0]["Display"].ToString() != "")
{
model.Display = int.Parse(ds.Tables[0].Rows[0]["Display"].ToString());
}
if (ds.Tables[0].Rows[0]["Expression"] != null && ds.Tables[0].Rows[0]["Expression"].ToString() != "")
{
model.Expression = ds.Tables[0].Rows[0]["Expression"].ToString();
}
if (ds.Tables[0].Rows[0]["InputType"] != null && ds.Tables[0].Rows[0]["InputType"].ToString() != "")
{
model.InputType = ds.Tables[0].Rows[0]["InputType"].ToString();
}
if (ds.Tables[0].Rows[0]["InputLen"] != null && ds.Tables[0].Rows[0]["InputLen"].ToString() != "")
{
model.InputLen = int.Parse(ds.Tables[0].Rows[0]["InputLen"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderBy"] != null && ds.Tables[0].Rows[0]["OrderBy"].ToString() != "")
{
model.OrderBy = int.Parse(ds.Tables[0].Rows[0]["OrderBy"].ToString());
}
if (ds.Tables[0].Rows[0]["TIME"] != null && ds.Tables[0].Rows[0]["TIME"].ToString() != "")
{
model.TIME = DateTime.Parse(ds.Tables[0].Rows[0]["TIME"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ROYcms.Sys.Model.ROYcms_Field model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.Rid != null)
{
strSql1.Append("Rid,");
strSql2.Append("" + model.Rid + ",");
}
if (model.Name != null)
{
strSql1.Append("Name,");
strSql2.Append("'" + model.Name + "',");
}
if (model.Lable != null)
{
strSql1.Append("Lable,");
strSql2.Append("'" + model.Lable + "',");
}
if (model.Len != null)
{
strSql1.Append("Len,");
strSql2.Append("" + model.Len + ",");
}
if (model.FieldType != null)
{
strSql1.Append("FieldType,");
strSql2.Append("" + model.FieldType + ",");
}
if (model.IsNull != null)
{
strSql1.Append("IsNull,");
strSql2.Append("" + model.IsNull + ",");
}
if (model.IsKey != null)
{
strSql1.Append("IsKey,");
strSql2.Append("" + model.IsKey + ",");
}
if (model.DefaultVal != null)
{
strSql1.Append("DefaultVal,");
strSql2.Append("'" + model.DefaultVal + "',");
}
if (model.Display != null)
{
strSql1.Append("Display,");
strSql2.Append("" + model.Display + ",");
}
if (model.Expression != null)
{
strSql1.Append("Expression,");
strSql2.Append("'" + model.Expression + "',");
}
if (model.InputType != null)
{
strSql1.Append("InputType,");
strSql2.Append("'" + model.InputType + "',");
}
if (model.InputLen != null)
{
strSql1.Append("InputLen,");
strSql2.Append("" + model.InputLen + ",");
}
if (model.OrderBy != null)
{
strSql1.Append("OrderBy,");
strSql2.Append("" + model.OrderBy + ",");
}
if (model.TIME != null)
{
strSql1.Append("TIME,");
strSql2.Append("'" + model.TIME + "',");
}
strSql.Append("insert into " + PubConstant.date_prefix + "Field(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DbHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ROYcms.Sys.Model.ROYcms_Field model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + PubConstant.date_prefix + "Field set ");
if (model.Rid != null)
{
strSql.Append("Rid=" + model.Rid + ",");
}
else
{
strSql.Append("Rid= null ,");
}
if (model.Name != null)
{
strSql.Append("Name='" + model.Name + "',");
}
else
{
strSql.Append("Name= null ,");
}
if (model.Lable != null)
{
strSql.Append("Lable='" + model.Lable + "',");
}
else
{
strSql.Append("Lable= null ,");
}
if (model.Len != null)
{
strSql.Append("Len=" + model.Len + ",");
}
else
{
strSql.Append("Len= null ,");
}
if (model.FieldType != null)
{
strSql.Append("FieldType=" + model.FieldType + ",");
}
else
{
strSql.Append("FieldType= null ,");
}
if (model.IsNull != null)
{
strSql.Append("IsNull=" + model.IsNull + ",");
}
else
{
strSql.Append("IsNull= null ,");
}
if (model.IsKey != null)
{
strSql.Append("IsKey=" + model.IsKey + ",");
}
else
{
strSql.Append("IsKey= null ,");
}
if (model.DefaultVal != null)
{
strSql.Append("DefaultVal='" + model.DefaultVal + "',");
}
else
{
strSql.Append("DefaultVal= null ,");
}
if (model.Display != null)
{
strSql.Append("Display=" + model.Display + ",");
}
else
{
strSql.Append("Display= null ,");
}
if (model.Expression != null)
{
strSql.Append("Expression='" + model.Expression + "',");
}
else
{
strSql.Append("Expression= null ,");
}
if (model.InputType != null)
{
strSql.Append("InputType='" + model.InputType + "',");
}
else
{
strSql.Append("InputType= null ,");
}
if (model.InputLen != null)
{
strSql.Append("InputLen=" + model.InputLen + ",");
}
else
{
strSql.Append("InputLen= null ,");
}
if (model.OrderBy != null)
{
strSql.Append("OrderBy=" + model.OrderBy + ",");
}
else
{
strSql.Append("OrderBy= null ,");
}
if (model.TIME != null)
{
strSql.Append("TIME='" + model.TIME + "',");
}
else
{
strSql.Append("TIME= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where Id=" + model.Id + "");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}