//栏目的更新
public bool Update(T_Column model)
{
// C_ColumnId, C_ColumnName, C_ColumnStatus, C_ColumnContent, C_ColumnParent, C_ColumnDelStatus
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Column set ");
strSql.Append("C_ColumnName=@name,");
strSql.Append("C_ColumnContent=@content,");
strSql.Append("C_ColumnDelStatus=@delstatus ");
strSql.Append("where C_ColumnId=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Char, 8),
new SqlParameter("@name", SqlDbType.NVarChar, 100),
new SqlParameter("@content", SqlDbType.NText),
new SqlParameter("@delstatus", SqlDbType.Int)
};
parameters[0].Value = model.ColumnId;
parameters[1].Value = model.ColumnName;
parameters[2].Value = model.ColumnContent;
parameters[3].Value = model.ColumnDelStatus;
int flag = SqlHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (flag > 0)
{
return(true);
}
else
{
return(false);
}
}
//根据栏目id获取model
public T_Column GetModelById(string columnid)
{
string sql = "select * from T_Column where C_ColumnId=@columnid";
SqlParameter[] pms = { new SqlParameter("@columnid", columnid) };
DataTable tb = SqlHelper.ExecuteDataTable(sql, CommandType.Text, pms);
T_Column model = new T_Column();
if (tb.Rows[0]["C_ColumnId"] != null)
{
model.ColumnId = tb.Rows[0]["C_ColumnId"].ToString();
}
if (tb.Rows[0]["C_ColumnName"] != null)
{
model.ColumnName = tb.Rows[0]["C_ColumnName"].ToString();
}
if (tb.Rows[0]["C_ColumnStatus"] != null)
{
model.ColumnStatus = int.Parse(tb.Rows[0]["C_ColumnStatus"].ToString());
}
if (tb.Rows[0]["C_ColumnContent"] != null)
{
model.ColumnContent = tb.Rows[0]["C_ColumnContent"].ToString();
}
if (tb.Rows[0]["C_ColumnParent"] != null)
{
model.ColumnParent = tb.Rows[0]["C_ColumnParent"].ToString();
}
if (tb.Rows[0]["C_ColumnDelStatus"] != null)
{
model.ColumnDelStatus = int.Parse(tb.Rows[0]["C_ColumnDelStatus"].ToString());
}
return(model);
}
private static GameObject GenerateColumnObj(T_Column col, Transform parent, int key)
{
GameObject curCol = Generate((int)View_Type.Column);
curCol.GetComponent <Column>().Initialize(key, parent);
return(curCol);
}
//插入model
public int InsertColumn(T_Column model)
{
string sql = "insert into T_Column values(@ColumnId,@ColumnName,@ColumnStatus,@ColumnContent,@ColumnParent,@ColumnDelStatus)";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@ColumnId", model.ColumnId),
new SqlParameter("@ColumnName", model.ColumnName),
new SqlParameter("@ColumnStatus", model.ColumnStatus),
new SqlParameter("@ColumnContent", model.ColumnContent),
new SqlParameter("@ColumnParent", model.ColumnParent),
new SqlParameter("@ColumnDelStatus", model.ColumnDelStatus),
};
return(SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms));
}
//根据以及栏目获取他的子栏目
public List <T_Column> GetColumn(string id)
{
List <T_Column> list = new List <T_Column>();
DataTable ColumnTab = dal.GetChildModelById(id);
if (ColumnTab.Rows.Count > 0)
{
for (int i = 0; i < ColumnTab.Rows.Count; i++)
{
T_Column model = new T_Column();
model.ColumnId = ColumnTab.Rows[i]["C_ColumnId"].ToString();
model.ColumnName = ColumnTab.Rows[i]["C_ColumnName"].ToString();
model.ColumnStatus = int.Parse(ColumnTab.Rows[i]["C_ColumnStatus"].ToString());
list.Add(model);
}
}
return(list);
}
// Update is called once per frame
void Update()
{
if (virgin)
{
virgin = false;
T_Column col1 = new T_Column();
col1.Name = "Name1";
col1.ColumnKey = 0;
T_Column col2 = new T_Column();
col2.Name = "Name2";
col2.ColumnKey = 1;
List <T_Column> colSet = new List <T_Column>();
colSet.Add(col1);
colSet.Add(col2);
List <T_Column> colSet2 = new List <T_Column>();
colSet2.Add(col1);
colSet2.Add(col2);
T_Table tab1 = new T_Table();
tab1.TableKey = 0;
tab1.Name = "TabName1";
tab1.ChildColumns = colSet;
T_Table tab2 = new T_Table();
tab2.TableKey = 1;
tab2.Name = "TabName2";
tab2.ChildColumns = colSet2;
List <T_Table> tabSet = new List <T_Table>();
tabSet.Add(tab1);
tabSet.Add(tab2);
T_Harness harness = new T_Harness();
harness.childTables = tabSet;
GameObject sample = ViewAssembler.GenerateViewObject(harness);
sample.name = "Rex";
}
}
public List <T_Column> DataTableToList(DataTable tb)
{
List <T_Column> list = new List <T_Column>();
int rowCount = tb.Rows.Count;
if (rowCount > 0)
{
for (int i = 0; i < rowCount; i++)
{
T_Column model = new T_Column();
if (tb.Rows[i]["C_ColumnId"] != null)
{
model.ColumnId = tb.Rows[i]["C_ColumnId"].ToString();
}
if (tb.Rows[i]["C_ColumnName"] != null)
{
model.ColumnName = tb.Rows[i]["C_ColumnName"].ToString();
}
if (tb.Rows[i]["C_ColumnStatus"] != null)
{
model.ColumnStatus = int.Parse(tb.Rows[i]["C_ColumnStatus"].ToString());
}
if (tb.Rows[i]["C_ColumnContent"] != null)
{
model.ColumnContent = tb.Rows[i]["C_ColumnContent"].ToString();
}
if (tb.Rows[i]["C_ColumnParent"] != null)
{
model.ColumnParent = tb.Rows[i]["C_ColumnParent"].ToString();
}
if (tb.Rows[i]["C_ColumnDelStatus"] != null)
{
model.ColumnDelStatus = int.Parse(tb.Rows[i]["C_ColumnDelStatus"].ToString());
}
list.Add(model);
}
}
return(list);
}
//插入model数据
public int InsertColumn(T_Column model)
{
return(dal.InsertColumn(model));
}
//更新栏目
public bool Update(T_Column model)
{
return(dal.Update(model));
}
