protected void btnSubmit_OnClick(object sender, EventArgs e)
{
CRM_AttendanceLogGroup newGroup = new CRM_AttendanceLogGroup();
newGroup.AddedTimeStamp = DateTime.Now;
if (dcDateOverride.Text != "")
{
newGroup.AddedTimeStamp = dcDateOverride.Value;
}
int eventID = 0;
if (int.TryParse(ddlEvents.SelectedValue, out eventID))
{
newGroup.CRM_AttendanceEventID = eventID;
}
newGroup.DateInserted = UKTime.Now;
newGroup.OriginType = (byte)CRM_AttendanceLogGroup.OriginTypes.CRM;
db.CRM_AttendanceLogGroups.InsertOnSubmit(newGroup);
foreach (RepeaterItem RI in repTypes.Items)
{
int quantity = 0;
int.TryParse(((HtmlInputText)RI.FindControl("txtQuantity")).Value, out quantity);
int typeID = 0;
int.TryParse(((HtmlInputHidden)RI.FindControl("hdn_typeID")).Value, out typeID);
if (quantity > 0 && typeID != 0)
{
CRM_AttendanceLog newlog = new CRM_AttendanceLog();
db.CRM_AttendanceLogs.InsertOnSubmit(newlog);
newlog.CRM_AttendanceLogGroup = newGroup;
newlog.CRM_AttendancePersonTypeID = typeID;
newlog.Quantity = quantity;
}
}
db.SubmitChanges();
NoticeManager.SetMessage(newGroup.CRM_AttendanceLogs.Sum(a => a.Quantity).ToString() + " Entries Added");
}
private void readForm()
{
var steps = new List <StepItem>();
foreach (RepeaterItem RI in StepRep.Items)
{
var step = new StepItem();
step.Name = ((TextBox)RI.FindControl("NameBox")).Text;
step.Ratio = Double.Parse(((TextBox)RI.FindControl("RatioBox")).Text);
step.SubSteps = new List <SubStepItem>();
var SubRep = (Repeater)RI.FindControl("SubStepRep");
foreach (RepeaterItem SubRI in SubRep.Items)
{
var subStep = new SubStepItem();
subStep.Name = ((TextBox)SubRI.FindControl("SubNameBox")).Text;
subStep.Ratio = Double.Parse(((TextBox)SubRI.FindControl("SubRatioBox")).Text);
step.SubSteps.Add(subStep);
}
steps.Add(step);
}
StoredList = steps;
}
protected void CreateSql()
{
if (txtVName.Value == "")
{
lbCheck.InnerHtml = "<font style='color:red'>视图名不允许为空！</font>";
lbCheck.Visible = true;
return;
}
if (string.IsNullOrEmpty(Request.QueryString["ViewName"]))
{
if (CheckView("ZL_V_" + txtVName.Value) != 0)
{
lbCheck.InnerHtml = "<font style='color:red'>已存在此视图名，请重新命名！</font>";
lbCheck.Visible = true;
return;
}
}
lbCheck.Visible = false;
if (string.IsNullOrEmpty(ListBox1.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请至少选择一个表！');</script>");
return;
}
foreach (RepeaterItem RI in Repeater1.Items)
{
if (RI.Visible == true)
{
ListBox lb = (ListBox)RI.FindControl("ListBox3");
HtmlInputHidden tN = (HtmlInputHidden)RI.FindControl("tN");
strTName = strTName + tN.Value + ",";
string[] checkStr = null;
for (int i = 0; i < lb.Items.Count; i++)
{
if (lb.Items[i].Selected == true)
{
if (!string.IsNullOrEmpty(strView))
{
checkStr = strView.Substring(0, strView.Length - 1).Split(',');
//Response.Write("<script>alert('"+checkStr.Length.ToString()+"');</script>");
foreach (string s in checkStr)
{
string s1 = s.Split('.')[1];
//Response.Write("<script>alert('" + s1.ToLower() + "');</script>");
if (lb.Items[i].Text.ToLower() == s1.ToLower())
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert(\"视图或函数中的列名必须唯一，在视图或函数 'ZL_V_" + tN.Value + "' 中多次指定了列名 '" + s1 + "'\");</script>");
return;
}
}
}
strView = strView + tN.Value + "." + lb.Items[i].Text + ",";
}
}
}
}
if (strView.Trim() == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请至少选择一个要显示的字段！');</script>");
return;
}
strTName = strTName.Substring(0, strTName.Length - 1);
strView = strView.Substring(0, strView.Length - 1);
if (string.IsNullOrEmpty(Request.QueryString["ViewName"]))
{
str = "create view " + "ZL_V_" + txtVName.Value.Trim() + " as select " + strView + " from " + strTName;
}
else
{
str = "alter view " + "ZL_V_" + txtVName.Value.Trim() + " as select " + strView + " from " + strTName;
}
if (taWhere.Value.Trim() != "")
{
if (!Regex.IsMatch(taWhere.Value.Trim(), @"^\w+\.\w+\s*=\s*\w+\.\w+(\s+[a,A] [n,N][d,D]\s+\w+\.\w+\s*=\s*\w+\.\w+)*$"))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('您输入的连接字符串格式有误！');</script>");
str = "";
return;
}
str = str + " where " + taWhere.Value.Trim();
}
status = true;
}
//Entry需要为一个名称空间的控件
public void GetNearestControl(Control Entry, int nCtrlCount, List <string> lsCtrlIDs, string strCtrlID)
{
if (nCtrlCount > 0)
{
if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.Repeater"))
{
foreach (RepeaterItem RI in ((Repeater)Entry).Items)
{
Control wbTemp = (Control)RI.FindControl(lsCtrlIDs[lsCtrlIDs.Count - nCtrlCount]);
GetNearestControl(wbTemp, nCtrlCount - 1, lsCtrlIDs, strCtrlID);
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.GridView"))
{
foreach (GridViewRow gvr in ((GridView)Entry).Rows)
{
Control wbTemp = (Control)gvr.FindControl(lsCtrlIDs[lsCtrlIDs.Count - nCtrlCount]);
GetNearestControl(wbTemp, nCtrlCount - 1, lsCtrlIDs, strCtrlID);
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.DataList"))
{
foreach (DataListItem dli in ((DataList)Entry).Items)
{
Control wbTemp = (Control)dli.FindControl(lsCtrlIDs[lsCtrlIDs.Count - nCtrlCount]);
GetNearestControl(wbTemp, nCtrlCount - 1, lsCtrlIDs, strCtrlID);
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.DetailsView"))
{
foreach (DetailsViewRow dvr in ((DetailsView)Entry).Rows)
{
Control wbTemp = (Control)dvr.FindControl(lsCtrlIDs[lsCtrlIDs.Count - nCtrlCount]);
GetNearestControl(wbTemp, nCtrlCount - 1, lsCtrlIDs, strCtrlID);
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.ListView"))
{
foreach (ListViewDataItem lvdi in ((ListView)Entry).Items)
{
Control wbTemp = (Control)lvdi.FindControl(lsCtrlIDs[lsCtrlIDs.Count - nCtrlCount]);
GetNearestControl(wbTemp, nCtrlCount - 1, lsCtrlIDs, strCtrlID);
}
}
//AjaxControlToolkit.TabContainer
else if (Entry.GetType().FullName.Equals("AjaxControlToolkit.TabContainer"))
{
string[] ctrlid = lsCtrlIDs.ToArray();
if (ctrlid.Length == 2)
{
Control wbFinal = ((AjaxControlToolkit.TabContainer)Entry).FindControl(ctrlid[1]).FindControl(strCtrlID);
wbFinal.Visible = false;
}
//TabContainer中有YYcontrol
else if (ctrlid.Length == 3)
{
Control con = ((AjaxControlToolkit.TabContainer)Entry).FindControl(ctrlid[1]).FindControl(ctrlid[2]);
if (con.GetType().FullName.Equals("YYControls.SmartGridView"))
{
foreach (GridViewRow gvr in ((YYControls.SmartGridView)con).Rows)
{
Control wbFinal = (Control)gvr.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
else if (con.GetType().FullName.Equals("System.Web.UI.WebControls.GridView"))
{
foreach (GridViewRow gvr in ((GridView)con).Rows)
{
Control wbFinal = (Control)gvr.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
}
}
//else if (Entry.GetType().FullName.Equals("YYControls.SmartGridView"))
//{
// string[] ctrlid = lsCtrlIDs.ToArray();
// Control wbFinal = ((YYControls.SmartGridView)Entry).FindControl(ctrlid[0]).FindControl(strCtrlID);
// wbFinal.Visible = false;
//}
}
else
{
//设置最终控件
if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.Repeater"))
{
foreach (RepeaterItem RI in ((Repeater)Entry).Items)
{
Control wbFinal = (Control)RI.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.GridView"))
{
foreach (GridViewRow gvr in ((GridView)Entry).Rows)
{
Control wbFinal = (Control)gvr.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.DataList"))
{
foreach (DataListItem dli in ((DataList)Entry).Items)
{
Control wbFinal = (Control)dli.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.DetailsView"))
{
foreach (DetailsViewRow dvr in ((DetailsView)Entry).Rows)
{
Control wbFinal = (Control)dvr.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
else if (Entry.GetType().FullName.Equals("System.Web.UI.WebControls.ListView"))
{
foreach (ListViewDataItem lvdi in ((ListView)Entry).Items)
{
Control wbFinal = (Control)lvdi.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
//yycontrol.smartgridview
else if (Entry.GetType().FullName.Equals("YYControls.SmartGridView"))
{
foreach (GridViewRow gvr in ((YYControls.SmartGridView)Entry).Rows)
{
Control wbFinal = (Control)gvr.FindControl(strCtrlID);
wbFinal.Visible = false;
}
}
else if (Entry.GetType().FullName.Equals("AjaxControlToolkit.TabContainer"))
{
string[] ctrlid = lsCtrlIDs.ToArray();
Control wbFinal = ((AjaxControlToolkit.TabContainer)Entry).FindControl(ctrlid[1]).FindControl(strCtrlID);
wbFinal.Visible = false;
}
return;
}
}