public ListElementsFactoryBase(ListVisualElement owner)
{
m_Owner = owner;
Controls = new ControlsClass(this);
if (m_Owner is IListControlAccesor)
{
m_Owner.Controls = Controls;
}
}
public void GetUpdate(HtmlTable TableUpdate1, string tablename, DataTable dts, string bCol, bool bRed, bool bNew)
{
PublicClass pc = new PublicClass();
string ctext = pc.GetLanguageColumn();
string h = "";
PublicData pd = new PublicData();
ControlsClass cc = new ControlsClass();
sSQL = "select * from _TableColInfo where TABLE_NAME in ('" + tablename + "') order by UpdateVisibleIndex";
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
bool b = true;
if (dts == null || dts.Rows.Count == 0)
{
b = false;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Session["uID"].ToString() == "游客" && tablename == "CW" && (dt.Rows[i]["COLUMN_NAME"].ToString() == "Date2" || dt.Rows[i]["COLUMN_NAME"].ToString() == "Date3" || dt.Rows[i]["COLUMN_NAME"].ToString() == "S6"))
{
continue;
}
HtmlTableRow tw = new HtmlTableRow();
if (dt.Rows[i]["UpdateVisibleIndex"].ToString().Trim() == "")
{
tw.Style.Add("display", "none");
}
string coltext = "";
if (dt.Rows[i]["ShowCol"].ToString().Trim() != "")
{
coltext = dt.Rows[i]["ShowCol"].ToString();
}
else
{
coltext = dt.Rows[i]["COLUMN_Text"].ToString();
}
if (dt.Rows[i]["IsInput"].ToString() == "*")
{
coltext = "<label id='lbltitle_" + dt.Rows[i]["COLUMN_NAME"].ToString() + "'>" + coltext + "</label><label id='lblisinput_" + dt.Rows[i]["COLUMN_NAME"].ToString() + "'>*</label>";
}
else
{
coltext = "<label id='lbltitle_" + dt.Rows[i]["COLUMN_NAME"].ToString() + "'>" + coltext + "</label>";
}
HtmlTableCell tclabel = new HtmlTableCell();
tclabel.Style.Add("font-weight", "bold");
tclabel.InnerHtml = coltext;
HtmlTableCell tc = new HtmlTableCell();
string value = "";
if (dts != null && dts.Rows.Count > 0)
{
value = dts.Rows[0][dt.Rows[i]["COLUMN_NAME"].ToString()].ToString();
}
string col = dt.Rows[i]["COLUMN_NAME"].ToString();
switch (dt.Rows[i]["UpdateType"].ToString())
{
case "textbox":
TextBox input = new TextBox();
input.ID = "text" + dt.Rows[i]["COLUMN_NAME"].ToString();
input.CssClass = "form-control";
if (b)
{
input.Text = value;
}
tc.Controls.Add(input);
if (col == bCol && bRed == true)
{
input.ReadOnly = true;
}
break;
case "label":
Label label = new Label();
label.ID = "label" + dt.Rows[i]["COLUMN_NAME"].ToString();
if (b)
{
label.Text = value;
}
label.CssClass = "form-control";
tc.Controls.Add(label);
break;
case "select":
DropDownList ddl = new DropDownList();
ddl.CssClass = "form-control";
ddl.ID = "ddl" + dt.Rows[i]["COLUMN_NAME"].ToString();
switch (dt.Rows[i]["ColSel"].ToString().Trim())
{
case "LookUpData":
ddl.DataSource = pd.GetLookUpData(dt.Rows[i]["ColSelFlag"].ToString());
ddl.DataValueField = "iID";
ddl.DataTextField = "iText";
ddl.DataBind();
break;
case "LookUpType":
ddl.DataSource = pd.GetLookUpType();
ddl.DataValueField = "iID";
ddl.DataTextField = "iText";
ddl.DataBind();
break;
}
if (b)
{
cc.Select(ddl, value);
}
if (col == bCol && bRed == true)
{
}
tc.Controls.Add(ddl);
break;
case "date":
UserControl userControl = (UserControl)LoadControl("_Controls/_Calendar.ascx");
userControl.ID = "Date" + dt.Rows[i]["COLUMN_NAME"].ToString();
TextBox text = ((TextBox)userControl.FindControl("datetimepicker"));
if (b)
{
if (value != "")
{
value = DateTime.Parse(value).ToString("yyyy-MM-dd");
}
text.Text = value;
}
tc.Controls.Add(userControl);
break;
case "date2":
UserControl userControl2 = (UserControl)LoadControl("_Controls/_Calendar2.ascx");
userControl2.ID = "Date" + dt.Rows[i]["COLUMN_NAME"].ToString();
TextBox text2 = ((TextBox)userControl2.FindControl("datetimepicker"));
if (b)
{
if (value != "")
{
value = DateTime.Parse(value).ToString();
text2.Text = DateTime.Parse(value).ToString("yyyy-MM-dd");
}
}
DropDownList ddld1 = ((DropDownList)userControl2.FindControl("ddlH"));
if (value != "")
{
string valueh = DateTime.Parse(value).ToString("HH");
if (ddld1.Items.Count == 0)
{
for (int s = 0; s < 24; s++)
{
string str = "";
if (s.ToString().Length < 2)
{
str = "0" + s.ToString();
}
else
{
str = s.ToString();
}
ListItem it = new ListItem();
it.Text = str;
it.Value = str;
ddld1.Items.Add(it);
}
}
for (int j = 0; j < ddld1.Items.Count; j++)
{
if (ddld1.Items[j].Value == valueh)
{
ddld1.Items[j].Selected = true;
}
}
DropDownList ddld2 = ((DropDownList)userControl2.FindControl("ddlM"));
string valuem = DateTime.Parse(value).ToString("mm");
if (ddld2.Items.Count == 0)
{
for (int s = 0; s < 60; s++)
{
string str = "";
if (s.ToString().Length < 2)
{
str = "0" + s.ToString();
}
else
{
str = s.ToString();
}
ListItem it = new ListItem();
it.Text = str;
it.Value = str;
ddld2.Items.Add(it);
}
}
for (int j = 0; j < ddld2.Items.Count; j++)
{
if (ddld2.Items[j].Value == valuem)
{
ddld2.Items[j].Selected = true;
}
}
}
tc.Controls.Add(userControl2);
break;
}
tw.Cells.Add(tclabel);
tw.Cells.Add(tc);
TableUpdate1.Controls.Add(tw);
}
}
