/// <summary>
/// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
/// </summary>
public void Dispose()
{
lock (this)
{
if (!Disposed)
{
Disposed = true;
GC.SuppressFinalize(this);
TraceStates.TraceLevel--;
if (TraceStates.TraceLevel == 0)
{
// must be parent trace method
ControlValues.RemoveState("TraceMethodState");
}
Int32 currentIndentLevel = ReflectInsight.IndentLevel;
while (currentIndentLevel > LastIndentLevel)
{
RI.ExitMethod("Matching ExitMethod was missing...");
currentIndentLevel--;
}
RI.ExitMethod(Message);
}
}
}
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");
}
///<summary>
/// Creates a TQ.
/// <param name="message">The Message to which this Type belongs</param>
/// <param name="description">The description of this type</param>
///</summary>
public TQ(IMessage message, string description) : base(message, description){
data = new IType[12];
data[0] = new CQ(message,"Quantity");
data[1] = new RI(message,"Interval");
data[2] = new ST(message,"Duration");
data[3] = new TS(message,"Start date/time");
data[4] = new TS(message,"End date/time");
data[5] = new ST(message,"Priority");
data[6] = new ST(message,"Condition");
data[7] = new ST(message,"Text");
data[8] = new ST(message,"Conjunction");
data[9] = new OSD(message,"Order sequencing");
data[10] = new CE(message,"Occurrence duration");
data[11] = new NM(message,"Total occurences");
}
void CIWClosed()
{
// when the check in window is closed we refresh the source control status icon
Object nodeObject = ((ITreeViewItem)this).NodeObject();
if (nodeObject is RepositoryItemBase) // Single Repository item
{
((RepositoryItemBase)nodeObject).RefreshSourceControlStatus();
}
else if (nodeObject is RepositoryFolderBase) // repositoryFolder
{
var v = ((RepositoryFolderBase)nodeObject).GetFolderRepositoryItems();
foreach (RepositoryItemBase RI in v)
{
RI.RefreshSourceControlStatus();
}
}
}
/// <summary>
/// Executes the specified action.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="action">The action.</param>
/// <param name="policy">The policy.</param>
/// <returns></returns>
public T Execute <T>(Func <T> action, TraceMethodExceptionPolicy policy = TraceMethodExceptionPolicy.LogAndSwallowParentsPolicy)
{
try
{
return(action());
}
catch (Exception ex)
{
ExceptionHandler(ex, (e) =>
{
Boolean handled = false;
if (policy != TraceMethodExceptionPolicy.Ignore)
{
RI.SendException(e);
handled = policy == TraceMethodExceptionPolicy.LogAndSwallowParentsPolicy;
}
return(handled);
});
throw;
}
}
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;
}
public FCSCoverage()
{
RI = new RI();
FCS = new FCS();
}
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;
}
}
