protected void BindSite()
{
colSite = objSite.Get_All();
for (int i = 0; i < colSite.Count; i++)
{
for (int j = i; j < colSite.Count; j++)
{
if (String.Compare(colSite[i].Sitename, colSite[j].Sitename) > 0)
{
Site_mst obj = new Site_mst();
obj = colSite[i];
colSite[i] = colSite[j];
colSite[j] = obj;
}
}
}
drpsite.DataTextField = "sitename";
drpsite.DataValueField = "siteid";
drpsite.DataSource = colSite;
drpsite.DataBind();
ListItem item = new ListItem();
item.Text = "All";
item.Value = "0";
drpsite.Items.Add(item);
//item.Text = "---Select Site---";
//item.Value = "0";
//drpsite.Items.Add(item);
drpsite.SelectedValue = "0";
}
protected void btnGonder_Click(object sender, EventArgs e)
{
int i;
pnlPanel.Height = Unit.Percentage(75);
pnlPanel.Width = Unit.Pixel(200);
lblAd.BorderStyle = BorderStyle.Dotted;
lblAd.BackColor = Color.LawnGreen;
lblAd.BorderColor = Color.FromArgb(255, 255, 0, 0);
txtAD.ForeColor = ColorTranslator.FromHtml("#00ff00");
ListItem Li=new ListItem("nolsun","denemeeee");
chklCheckDeneme.Items.Add( Li);
///*****************************************************
///
tbl.Controls.Clear();
tbl.BorderStyle = BorderStyle.Double;
tbl.BorderWidth = Unit.Pixel(1);
int rows = 3, cols = 4;
TableCell tc;
for (int sat = 0; sat < rows; sat++)
{
TableRow tr = new TableRow();
tbl.Controls.Add(tr);
for (int sut = 0; sut < cols; sut++)
{
tc = new TableCell();
tc.BorderStyle = BorderStyle.Double;
tc.BorderWidth = Unit.Pixel(1);
tc.Text = sat.ToString() + " " + sut.ToString();
tr.Controls.Add(tc);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
// renk
string[] colorArray = Enum.GetNames(typeof(System.Drawing.KnownColor));
lstBackColor.DataSource = colorArray;
lstBackColor.DataBind();
// font
System.Drawing.Text.InstalledFontCollection fonts = new System.Drawing.Text.InstalledFontCollection();
foreach (FontFamily family in fonts.Families)
{
lstFontName.Items.Add(family.Name);
}
ListItem item = new ListItem();
string[] borderStyleArray = Enum.GetNames(typeof(BorderStyle));
lstBorder.DataSource = borderStyleArray;
lstBorder.DataBind();
lstBorder.SelectedIndex = 0;
imgDefault.ImageUrl = "images/default-user-image.png";
imgDefault.Visible = false;
}
}
/// <summary>
/// Helper Method to set a Taxonomy Field on a list item
/// </summary>
/// <param name="ctx">The Authenticated ClientContext</param>
/// <param name="listItem">The listitem to modify</param>
/// <param name="model">Domain Object of key/value pairs of the taxonomy field & value</param>
public static void SetTaxonomyField(ClientContext ctx, ListItem listItem, Hashtable model)
{
FieldCollection _fields = listItem.ParentList.Fields;
ctx.Load(_fields);
ctx.ExecuteQuery();
foreach(var _key in model.Keys)
{
var _termName = model[_key].ToString();
TaxonomyField _field = ctx.CastTo<TaxonomyField>(_fields.GetByInternalNameOrTitle(_key.ToString()));
ctx.Load(_field);
ctx.ExecuteQuery();
Guid _id = _field.TermSetId;
string _termID = AutoTaggingHelper.GetTermIdByName(ctx, _termName, _id );
var _termValue = new TaxonomyFieldValue()
{
Label = _termName,
TermGuid = _termID,
WssId = -1
};
_field.SetFieldValueByValue(listItem, _termValue);
listItem.Update();
ctx.ExecuteQuery();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
if (this.Session["admin"] == null)
{
base.Response.Redirect("/account/Login.aspx");
}
if (GeneralMethods.GetPermissions(HttpContext.Current.Request.Url.ToString(), this.Session["admin"].ToString()))
{
base.Response.Redirect("/Index.aspx");
}
Model.SelectRecord selectRecord = new Model.SelectRecord("Role", "", "*", "where isState=1 order by id desc");
DataTable table = BLL.SelectRecord.SelectRecordData(selectRecord).Tables[0];
if (table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
ListItem li=new ListItem(table.Rows[i][1].ToString(),table.Rows[i][0].ToString());
this.selIsState.Items.Add(li);
if (i == 0)
{
this.selIsState.SelectedValue = table.Rows[0][0].ToString();
}
}
}
BLL.Organizational.BindToListBox(List_Organ, "");
}
}
private void CreateCheckBoxListGroup()
{
if (DataGridUser.EditItemIndex != -1)
{
CheckBoxList groupList = DataGridUser.Items[DataGridUser.EditItemIndex].Cells[6].FindControl("CheckBoxListGroup") as CheckBoxList;
FSEye.Security.User user = TheAdminServer.SecurityManager.GetUser((int)Store.Rows[DataGridUser.EditItemIndex].ItemArray[0]);
if (groupList != null)
{
Group[] groups = TheAdminServer.SecurityManager.GetAllGroups();
if (groups != null && groups.Length != 0)
foreach (Group group in groups)
{
ListItem item = new ListItem(group.SecurityObject.Name, group.SecurityObject.Id.ToString());
if(user!=null)
{
foreach (int groupId in user.Groups)
{
if (groupId == group.SecurityObject.Id) item.Selected = true;
}
}
groupList.Items.Add(item);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.cadenaconexion =
"Data Source=LOCALHOST;Initial Catalog=HOSPITAL;User ID=SA";
this.cn = new SqlConnection(this.cadenaconexion);
this.com = new SqlCommand();
//LA PRIMERA VEZ...
if (this.Page.IsPostBack == false)
{
this.lstdepartamentos.AutoPostBack = true;
this.com.Connection = this.cn;
this.com.CommandType = System.Data.CommandType.Text;
this.com.CommandText = "SELECT * FROM DEPT";
this.cn.Open();
this.lector = this.com.ExecuteReader();
while (this.lector.Read())
{
ListItem it = new ListItem();
it.Text = this.lector["DNOMBRE"].ToString();
it.Value = this.lector["DEPT_NO"].ToString();
this.lstdepartamentos.Items.Add(it);
}
this.lector.Close();
this.cn.Close();
}
}
protected void FillDropDownList()
{
//从web.config中获取数据库连接
string connectionStr = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
//创建与数据库的连接
using (SqlConnection conn = new SqlConnection(connectionStr))
{
conn.Open();
//新建一个SqlCommand对象
SqlCommand cmd = new SqlCommand("Select * from Customers", conn);
//创建一个SqlDataReader对象
SqlDataReader sdr = cmd.ExecuteReader();
//一次一行读取SqlDataReader对象并添加到DropDownList中去。
while (sdr.Read())
{
ListItem newItem = new ListItem();
newItem.Text = sdr["CompanyName"] as string;
newItem.Value = sdr["CustomerID"].ToString();
DropDownList1.Items.Add(newItem);
}
//使用完毕记得关毕SqlDataReader对象
sdr.Close();
}
}
protected override void MapProperties(object modelHost, ListItem item, ContentPageDefinitionBase definition)
{
base.MapProperties(modelHost, item, definition);
var typedDefinition = definition.WithAssertAndCast<JavaScriptDisplayTemplateDefinition>("model", value => value.RequireNotNull());
item[BuiltInInternalFieldNames.ContentTypeId] = "0x0101002039C03B61C64EC4A04F5361F3851068";
if (!string.IsNullOrEmpty(typedDefinition.Standalone))
item["DisplayTemplateJSTemplateType"] = typedDefinition.Standalone;
if (!string.IsNullOrEmpty(typedDefinition.TargetControlType))
item["DisplayTemplateJSTargetControlType"] = typedDefinition.TargetControlType;
if (!string.IsNullOrEmpty(typedDefinition.TargetListTemplateId))
item["DisplayTemplateJSTargetListTemplate"] = typedDefinition.TargetListTemplateId;
if (!string.IsNullOrEmpty(typedDefinition.TargetScope))
item["DisplayTemplateJSTargetScope"] = typedDefinition.TargetScope;
if (!string.IsNullOrEmpty(typedDefinition.IconUrl))
{
var iconValue = new FieldUrlValue { Url = typedDefinition.IconUrl };
if (!string.IsNullOrEmpty(typedDefinition.IconDescription))
iconValue.Description = typedDefinition.IconDescription;
item["DisplayTemplateJSIconUrl"] = iconValue;
}
}
protected override void MapProperties(object modelHost, ListItem item, ContentPageDefinitionBase definition)
{
base.MapProperties(modelHost, item, definition);
var typedDefinition = definition.WithAssertAndCast<FilterDisplayTemplateDefinition>("model", value => value.RequireNotNull());
item[BuiltInInternalFieldNames.ContentTypeId] = "0x0101002039C03B61C64EC4A04F5361F38510660400F643FF79F6BD764F8A469B6F153396EE";
if (!string.IsNullOrEmpty(typedDefinition.CrawlerXSLFileURL))
{
var crawlerXSLFileValue = new FieldUrlValue { Url = typedDefinition.CrawlerXSLFileURL };
if (!string.IsNullOrEmpty(typedDefinition.CrawlerXSLFileDescription))
crawlerXSLFileValue.Description = typedDefinition.CrawlerXSLFileDescription;
item["CrawlerXSLFile"] = crawlerXSLFileValue;
}
if (!string.IsNullOrEmpty(typedDefinition.CompatibleManagedProperties))
item["CompatibleManagedProperties"] = typedDefinition.CompatibleManagedProperties;
if (typedDefinition.CompatibleSearchDataTypes.Count > 0)
{
item["CompatibleSearchDataTypes"] = typedDefinition.CompatibleSearchDataTypes.ToArray();
}
}
public void getfiles(string dir)
{
ddFilesMovie.Items.Clear();
ListItem li1 = new ListItem();
li1.Text = "-- select --";
li1.Value = "-1";
ddFilesMovie.Items.Add(li1);
ArrayList af = new ArrayList();
string[] Filesmovie = Directory.GetFiles(dir);
foreach (string file in Filesmovie)
{
string appdir = Server.MapPath("~/App_Uploads_Img/") + ddCatMovie.SelectedValue;
string filename = file.Substring(appdir.Length + 1);
if ((!filename.Contains("_svn")) && (!filename.Contains(".svn")))
{
if (filename.ToLower().Contains(".mov") || filename.ToLower().Contains(".flv") || filename.ToLower().Contains(".wmv") )
{
ListItem li = new ListItem();
li.Text = filename;
li.Value = filename;
ddFilesMovie.Items.Add(li);
}
}
}
UpdatePanel1Movie.Update();
}
protected override void SetProperties(ListItem item)
{
BaseSet(item, FIELD_FIRSTNAME, SpeakerFirstName);
BaseSet(item, FIELD_LASTNAME, SpeakerLastName);
BaseSet(item, FIELD_EMAIL, SpeakerEmail);
BaseSet(item, FIELD_ID, SpeakerId);
}
public void fill_list()
{
DropDownList2.Items.Clear();
DropDownList3.Items.Clear();
DropDownList2.Items.Add("Select");
DropDownList3.Items.Add("Select");
//string s = Request.Cookies["fdet"].Values["city"];
//Response.Write(s);
string cnstr = @"Data Source=.\sqlexpress;AttachDbFilename=E:\projects\FIR\fir_sys\fir.mdf;Integrated Security=True";
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
con.ConnectionString = cnstr;
cmd.Connection = con;
string query = "select distinct zone from stations where city='" + DropDownList1.SelectedItem.ToString() + "'";
con.Open();
cmd.CommandText = query;
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
ListItem z = new ListItem();
z.Text = r[0].ToString();
DropDownList2.Items.Add(z);
//DropDownList2.Items.Add(r[0].ToString);
}
con.Close();
TextBox5.Focus();
}
public static Event Parse(ListItem sharepointListItem)
{
Event e = new Event()
{
ID = (int)sharepointListItem["ID"],
Title = (string)sharepointListItem["Title"],
Created = DateTime.Parse(sharepointListItem["Created"].ToString()),
Description = (string)sharepointListItem["Description"],
Location = (string)sharepointListItem["Location"],
Category = (string)sharepointListItem["Category"],
UID = sharepointListItem["UID"] == null ? Guid.NewGuid().ToString() : sharepointListItem["UID"].ToString(),
EventDate = DateTime.Parse(sharepointListItem["EventDate"].ToString()),
EndDate = DateTime.Parse(sharepointListItem["EndDate"].ToString()),
Duration = (int)sharepointListItem["Duration"],
Recurrence = (bool)sharepointListItem["fRecurrence"],
RecurrenceData = (string)sharepointListItem["RecurrenceData"],
RecurrenceID = sharepointListItem["RecurrenceID"] != null ? DateTime.Parse(sharepointListItem["RecurrenceID"].ToString()) : DateTime.MinValue,
MasterSeriesItemID = sharepointListItem["MasterSeriesItemID"] == null ? -1 : (int)sharepointListItem["MasterSeriesItemID"],
EventType = (EventType)Enum.Parse(typeof(EventType), sharepointListItem["EventType"].ToString()),
AllDayEvent = (bool)sharepointListItem["fAllDayEvent"],
LastModified = DateTime.Parse(sharepointListItem["Last_x0020_Modified"].ToString())
};
return e;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["ret"]))
{
dt = objKat.HentAlleKategorier();
foreach (DataRow kategori in dt.Rows)
{
ListItem li = new ListItem(kategori["fldKategori"].ToString(), kategori["fldKatID"].ToString());
ddlKat.Items.Add(li);
}
objNyhed._id = Convert.ToInt32(Request.QueryString["ret"]);
dt = objNyhed.HentNyhedFraID();
if (!IsPostBack)
{
ShowSubject();
}
txtOverskrift.Text = dt.Rows[0]["fldOverskrift"].ToString();
txtTeaser.Text = dt.Rows[0]["fldTeaser"].ToString();
txtTekst.Text = dt.Rows[0]["fldTekst"].ToString();
ddlKat.SelectedValue = dt.Rows[0]["fldKatID_fk"].ToString();
}
else
{
Response.Redirect("NyhedRetSlet.aspx");
}
}
}
public void BindDrpDepartment()
{
BLLCollection<Department_mst> col = new BLLCollection<Department_mst>();
Department_mst Objdepartment = new Department_mst();
int Selectedsiteval = Convert.ToInt16(DrpSite.SelectedValue);
if (Selectedsiteval==0)
{
DrpDepartment.DataSource = col;
DrpDepartment.DataBind();
ListItem item = new ListItem();
item.Text = "--------------Select---------------";
item.Value = "0";
DrpDepartment.Items.Add(item);
DrpDepartment.SelectedValue = "0";
}
else
{
col = Objdepartment.Get_All_By_SiteId(Selectedsiteval);
DrpDepartment.DataTextField = "departmentName";
DrpDepartment.DataValueField = "deptid";
DrpDepartment.DataSource = col;
DrpDepartment.DataBind();
ListItem item = new ListItem();
item.Text = Resources.MessageResource.errSelectDept.ToString();
item.Value = "0";
DrpDepartment.Items.Add(item);
DrpDepartment.SelectedValue = "0";
}
}
public void LoadJobType()
{
DataAccess dataaccess = new DataAccess();
using (SqlConnection Sqlcon = dataaccess.OpenConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetJobType";
cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.VarChar, 50));
cmd.Parameters["@Action"].Value = "select";
cmd.Parameters.Add("@Exists", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlAda = new SqlDataAdapter(cmd);
ds = new DataSet();
SqlAda.Fill(ds);
ddlJobType.DataSource = ds;
ddlJobType.DataTextField = "JobTypeName";
ddlJobType.DataValueField = "JobTypeId";
ddlJobType.DataBind();
if (ddlJobType.Items.Count >= 1)
{
ListItem lstitem = new ListItem();
lstitem.Text = "[Select]";
lstitem.Value = "0";
ddlJobType.Items.Insert(0, lstitem);
}
}
}
}
/// <summary>
/// Fill year drop down with the avaliable news year
/// </summary>
private void FillYearDropDown()
{
var allNewsArticles = SiteDataManager.GetLatestNews();
if (allNewsArticles != null && allNewsArticles.Any())
{
var yearList = allNewsArticles.Select(x => x.SmartForm.Date.Year).Distinct().ToList();
if(yearList != null && yearList.Any())
{
int currentYear = DateTime.Now.Year;
lblYearSelected.Text = currentYear.ToString();
ListItem item = null;
//initial item
item = new ListItem("-Select a year-", "");
ddlArchiveYear.Items.Add(item);
foreach(var y in yearList)
{
item = new ListItem(y.ToString(), y.ToString());
if (y == currentYear)
item.Selected = true;
ddlArchiveYear.Items.Add(item);
}
}
}
}
private void CreateCheckBoxListRoleType()
{
ListItem item = new ListItem(string.Format("{0}[{1}]", StringDef.Jiashi, StringDef.ProfessionalNotChoose), "0,-1");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Jiashi, StringDef.XuanFeng), "0,0");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Jiashi, StringDef.XingTian), "0,1");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Daoshi, StringDef.ProfessionalNotChoose), "1,-1");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Daoshi, StringDef.ZhenRen), "1,0");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Daoshi, StringDef.TianShi), "1,1");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Yiren, StringDef.ProfessionalNotChoose), "2,-1");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Yiren, StringDef.ShouShi), "2,0");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
item = new ListItem(string.Format("{0}[{1}]", StringDef.Yiren, StringDef.YiShi), "2,1");
item.Selected = true;
CheckBoxListRoleType.Items.Add(item);
}
public void InnerListTest()
{
List li = new List(this._td, "L1", ListStyles.Bullet, "L1P1");
ListItem lit = new ListItem(li);
lit.Paragraph.TextContent.Add(new SimpleText(lit, "Hello"));
li.Content.Add(lit);
//The ListItem will become a inner list !!
lit = new ListItem(li);
lit.Paragraph.TextContent.Add(new SimpleText(lit, "Hello Again"));
//Inner List - see the constrctor usage !
List liinner = new List(this._td, li);
Assert.IsNull(liinner.Style, "Style must be null! The inner list inherited his style from the outer list!");
ListItem litinner = new ListItem(liinner);
litinner.Paragraph.TextContent.Add(new SimpleText(lit, "Hello i'm in the inner list"));
liinner.Content.Add(litinner);
//Add the inner list to ListItem lit
lit.Content.Add(liinner);
//Add the ListItem with inner list inside
li.Content.Add(lit);
//Add the whole list to the document
this._td.Content.Add(li);
this._td.SaveTo("innerlist.odt");
}
protected override void ReadProperties(ListItem item)
{
SpeakerId = BaseGet<string>(item, FIELD_ID);
SpeakerFirstName = BaseGet<string>(item, FIELD_FIRSTNAME);
SpeakerLastName = BaseGet<string>(item, FIELD_LASTNAME);
SpeakerEmail = BaseGet<string>(item, FIELD_EMAIL);
}
protected void btnAdd_Click(object sender, System.EventArgs e)
{
//如果Text文本框输入的数据为空
if (txtItemText.Text.Trim() == "")
{
//显示错误提示
lblInfo.Text ="Text值不能为空";
}
//如果Value文本框输入的数据为空
else if (txtItemValue.Text.Trim() == "")
{
lblInfo.Text = "Value值不能为空";
}
else
{
//创建一个新的选项
ListItem li = new ListItem();
li.Text = txtItemText.Text.Trim();
li.Value = txtItemValue.Text.Trim();
//将选项添加到下拉列表中
dplItems.Items.Add(li);
//选中最后一个选项（即新添加进的选项）
dplItems.SelectedIndex = dplItems.Items.Count - 1;
//显示信息并设置按钮可用状态
DisplayInfoAndSetButtonEnabled();
//清空Text与Value文本框
txtItemText.Text = "";
txtItemValue.Text = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.Page.Title = "问答题管理";
if (!IsPostBack)
{
if (Session["userID"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
string userId = Session["userID"].ToString();
string userName = userService.GetUserName(userId);
Label i1 = (Label)Page.Master.FindControl("labUser");
i1.Text = userName;
//展示绑定的数据并将它展示在下拉列表中
ddlCourse.Items.Clear();
Course course = new Course();
Course[] list = singleSelectedService.ListCourse();
for (int i = 0; i < list.Length; i++)
{
ListItem item = new ListItem(list[i].DepartmentName.ToString(), list[i].DepartmentId.ToString());
ddlCourse.Items.Add(item);
}
string selectvalue = this.ddlCourse.SelectedValue;
this.GridView1.DataSource = questionProblemService.GetQuestionProblem(selectvalue);
this.GridView1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["auth"] == null)
{
Response.Redirect("Homepage.aspx");
}
Button1.Text = "Delete";
ListItem newItem = new ListItem();
string constr = Session["connection"].ToString();
OdbcConnection cn = new OdbcConnection(constr);
cn.Open();
string sql = "select agent_id from AGENT";
OdbcCommand cmd = new OdbcCommand(sql, cn);
OdbcDataReader reader;
reader = cmd.ExecuteReader();
while (reader.Read())
{
newItem = new ListItem();
newItem.Text = reader["agent_id"].ToString();
DropDownList1.Items.Add(newItem);
}
reader.Close();
cn.Close();
}
protected void Add()
{
if (!this.Disabled)
{
string viewStateString = base.GetViewStateString("ID");
TreeviewEx ex = this.FindControl(viewStateString + "_all") as TreeviewEx;
Assert.IsNotNull(ex, typeof(DataTreeview));
Listbox listbox = this.FindControl(viewStateString + "_selected") as Listbox;
Assert.IsNotNull(listbox, typeof(Listbox));
Item selectionItem = ex.GetSelectionItem();
if (selectionItem == null)
{
SheerResponse.Alert("Select an item in the Content Tree.", new string[0]);
}
else if (!this.HasExcludeTemplateForSelection(selectionItem))
{
if (this.IsDeniedMultipleSelection(selectionItem, listbox))
{
SheerResponse.Alert("You cannot select the same item twice.", new string[0]);
}
else if (this.HasIncludeTemplateForSelection(selectionItem))
{
SheerResponse.Eval("scForm.browser.getControl('" + viewStateString + "_selected').selectedIndex=-1");
ListItem control = new ListItem();
control.ID = Sitecore.Web.UI.HtmlControls.Control.GetUniqueID("L");
Sitecore.Context.ClientPage.AddControl(listbox, control);
control.Header = selectionItem.DisplayName;
control.Value = control.ID + "|" + selectionItem.ID;
SheerResponse.Refresh(listbox);
SetModified();
}
}
}
}
public override void AddPage(ListItem item, ProvisioningTemplate template)
{
string url = GetUrl(item, true);
if (null == template.Pages.Find((p) => string.Equals(p.Url, url, System.StringComparison.OrdinalIgnoreCase)))
{
var fieldValues = item.FieldValues;
var pageLayoutUrl = string.Empty;
if (fieldValues.ContainsKey("PublishingPageLayout"))
{
pageLayoutUrl = fieldValues["PublishingPageLayout"] == null ? "" : (fieldValues["PublishingPageLayout"] as FieldUrlValue).Url;
}
pageLayoutUrl = this.TokenParser.TokenizeUrl(pageLayoutUrl);
string html = "";
if (fieldValues.ContainsKey("PublishingPageContent"))
{
html = fieldValues["PublishingPageContent"] == null ? " " : fieldValues["PublishingPageContent"].ToString();
}
var title = fieldValues["Title"] == null ? "" : fieldValues["Title"].ToString();
bool needToOverwrite = NeedOverride(item);
var webParts = GetWebParts(item);
bool isHomePage = IsWelcomePage(item);
PublishingPage page = new PublishingPage(url, title, html, pageLayoutUrl, needToOverwrite, webParts, isHomePage);
template.Pages.Add(page);
}
}
public void OnMenuChanged(object sender, EventArgs e)
{
using (DBDataContext db = new DBDataContext())
{
var menudata = from LM in db.LeftMenu
orderby LM.Order
select LM;
int i;
if (int.TryParse(ddlMenu.SelectedValue, out i))
{
cblSubmenu.Items.Clear();
foreach (var sd in menudata)
{
if (sd.id != i && (sd.ParetnId == i || sd.ParetnId == null))
{
ListItem l = new ListItem();
l.Selected = sd.ParetnId == i;
l.Text = sd.ItemName;
l.Value = sd.id.ToString();
cblSubmenu.Items.Add(l);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//site içi sayfa linkleri listeleniyor
Snlg_DBConnect vt = new Snlg_DBConnect(true);
Snlg_DBParameter[] DBPrms = new Snlg_DBParameter[1];
DBPrms[0] = new Snlg_DBParameter("@Dil", SqlDbType.SmallInt, DBNull.Value);
using (SqlDataReader sdr = vt.DBReaderOlustur("snlg_V1.msp_LinkListele", CommandType.StoredProcedure, DBPrms))
{
while (sdr.Read())
{
ListItem item = new ListItem(sdr["LinkText"].ToString(), sdr["Link"].ToString());
item.Selected = sdr["Link"].ToString() == "/" + Snlg_ConfigValues.startPage;
DDLLinks.Items.Add(item);
}
}
DataTable dtLang= vt.DataTableOlustur("SELECT DId, Name FROM snlg_V1.TblDiller WHERE Aktif = 1 ORDER BY Name", CommandType.Text);
DDLDefLang.DataSource = dtLang;
DDLDefLang.DataBind();
DDLAdminLang.DataSource = dtLang;
DDLAdminLang.DataBind();
vt.Kapat();
CBExtension.Checked = !string.IsNullOrEmpty(Snlg_ConfigValues.urlExtension);
try { DDLDefLang.SelectedValue = Snlg_ConfigValues.defaultLangId; }
catch { }
try { DDLAdminLang.SelectedValue = Snlg_ConfigValues.adminDefaultLangId.ToString(); }
catch { }
}
}
static void Main(string[] args)
{
var firstItem = new ListItem<int>(5, null);
var linkedList = new LinkedList<int>(firstItem);
//TODO: IMPLEMENT FUNCTIONS
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (LoginSession.IsLogin())
{
if (!LoginSession.IsAdmin())
{
if (!LoginSession.IsView("MN-00016"))
{
Response.Redirect("NoPermitsion.aspx");
}
}
}
else
{
Response.Redirect("/Account/Login.aspx?Url=" + Request.Url.PathAndQuery);
}
hidUserName.Value = LoginSession.UserName();
#region
UsersMN aUsersMN = new UsersMN();
CategorysMN aCategorysMN = new CategorysMN();
ListItem aListItem = new ListItem();
string CatTypeCode = string.Empty;
CatTypeCode = "CT-00003"; //Application Site
ddlApplicationSite.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode);
ddlApplicationSite.DataValueField = "CatCode";
ddlApplicationSite.DataTextField = "CatName";
ddlApplicationSite.DataBind();
//CatTypeCode = "CT-00004"; //Doc Type
//ddlDocType.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode);
//ddlDocType.DataValueField = "CatCode";
//ddlDocType.DataTextField = "CatName";
//ddlDocType.DataBind();
#endregion
#region
string PublishDocument = Convert.ToString(Request.QueryString["PublishDocument"]);
string ObsoletedDocument = Convert.ToString(Request.QueryString["ObsoletedDocument"]);
if (!String.IsNullOrEmpty(PublishDocument))
{
#region
RegisterPublishDocumentMN aRegisterPublishDocumentMN = new RegisterPublishDocumentMN();
txtApplicationName.Text = LoginSession.FullName();
txtApplicationNO.Text = string.Empty;
txtApplicationDate.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
hidPublishDocument.Value = PublishDocument;
DataTable aData = aRegisterPublishDocumentMN.ListRegisterPublishDocument(PublishDocument, string.Empty, "C26", string.Empty,
string.Empty, string.Empty, string.Empty, string.Empty, Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("1900-01-01"));
if (aData.Rows.Count > 0)
{
ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]);
//hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]);
txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocumentNo"]);
txtREV.Text = Convert.ToString(aData.Rows[0]["Rev"]);
txtDocName.Text = Convert.ToString(aData.Rows[0]["DocumentName"]);
txtReleaseDate.Text = Convert.ToString(aData.Rows[0]["EffectiveDate_Text"]);
//ddlDocType.Text = Convert.ToString(aData.Rows[0]["DocumentType"]);
//hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]);
//hidDepartmentCheck.Value = Convert.ToString(aData.Rows[0]["DepartmentCheck"]);
DataTable aTemp = new DataTable();
aTemp = aCategorysMN.ListCategorys(Convert.ToString(aData.Rows[0]["Department"]), string.Empty, string.Empty);
txtApplicationDep.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty;
txtDepartment.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty;
aTemp = aUsersMN.GetManagerCurrent();
txtManager.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["HoTen"]) : string.Empty;
}
#endregion
}
else
{
if (!String.IsNullOrEmpty(ObsoletedDocument))
{
#region
ApplicationObsoletedDocumentMN aApplicationObsoletedDocumentMN = new ApplicationObsoletedDocumentMN();
DataTable aData = aApplicationObsoletedDocumentMN.ListApplicationObsoletedDocument(ObsoletedDocument, string.Empty, string.Empty,
string.Empty, string.Empty, string.Empty, string.Empty, Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("1900-01-01"));
if (aData.Rows.Count > 0)
{
txtApplicationName.Text = Convert.ToString(aData.Rows[0]["HoTen"]);
hidID.Value = Convert.ToString(aData.Rows[0]["ID"]);
hidObsoletedDocument.Value = ObsoletedDocument;
hidStates.Value = Convert.ToString(aData.Rows[0]["States"]);
txtApplicationNO.Text = Convert.ToString(aData.Rows[0]["ObsoletedDocument"]);
hidPublishDocument.Value = Convert.ToString(aData.Rows[0]["PublishDocument"]);
txtEffectiveDate.Text = Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).Year > 1900 ? Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).ToString("yyyy/MM/dd") : string.Empty;
txtApplicationDate.Text = Convert.ToString(aData.Rows[0]["ApplicationDate_Text"]);
ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]);
//hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]);
txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocumentNo"]);
txtREV.Text = Convert.ToString(aData.Rows[0]["Rev"]);
txtDocName.Text = Convert.ToString(aData.Rows[0]["DocumentName"]);
txtReleaseDate.Text = Convert.ToString(aData.Rows[0]["EffectiveDate_Text"]);
//ddlDocType.Text = Convert.ToString(aData.Rows[0]["DocumentType"]);
//hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]);
//hidDepartmentCheck.Value = Convert.ToString(aData.Rows[0]["DepartmentCheck"]);
DataTable aTemp = new DataTable();
aTemp = aCategorysMN.ListCategorys(Convert.ToString(aData.Rows[0]["Department"]), string.Empty, string.Empty);
txtApplicationDep.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty;
txtDepartment.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty;
aTemp = aUsersMN.GetManagerCurrent();
txtManager.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["HoTen"]) : string.Empty;
txtReasonObsoleted.Text = Convert.ToString(aData.Rows[0]["ReasonObsoleted"]);
}
#endregion
}
}
#endregion
}
}
/// <summary>
/// Instantiates a wiki page object
/// </summary>
/// <param name="page">ListItem holding the page to analyze</param>
/// <param name="pageTransformation">Page transformation information</param>
public WikiPage(ListItem page, PageTransformation pageTransformation) : base(page, pageTransformation)
{
this.parser = new HtmlParser();
}
protected void InsertFisrtItem(DropDownList ddlList, string text)
{
ListItem item = new ListItem(text, "0");
ddlList.Items.Insert(0, item);
}
//Method to add user's answers to correct questions
public void addAnswersToQuestion()
{
List <Question> questions = currentUser.newTest.questions;
int c = questions.Count();
for (int i = 0; i < c; i++)
{
Question currentQuestion = questions[i];
List <Answer> currentAnswers = currentQuestion.answerList;
List <Answer> userAnswers = new List <Answer>();
int qId = questions[i].id;
Control div = FindControl(qId.ToString());
foreach (Control ctrl in div.Controls)
{
if (ctrl is RadioButtonList)
{
RadioButtonList rblist = (RadioButtonList)ctrl;
for (int rb = 0; rb < rblist.Items.Count; rb++)
{
if (rblist.Items[rb].Selected)
{
ListItem li = rblist.Items[rb];
Answer currentAnswer = currentAnswers[rb];
Answer userAnswer = new Answer()
{
id = li.Value,
correct = currentAnswer.correct,
text = currentAnswer.text
};
userAnswers.Add(userAnswer);
}
}
}
else if (ctrl is CheckBoxList)
{
CheckBoxList cblist = (CheckBoxList)ctrl;
for (int cb = 0; cb < cblist.Items.Count; cb++)
{
if (cblist.Items[cb].Selected)
{
ListItem li = cblist.Items[cb];
Answer currentAnswer = currentAnswers[cb];
Answer userAnswer = new Answer()
{
id = li.Value,
correct = currentAnswer.correct,
text = currentAnswer.text
};
userAnswers.Add(userAnswer);
}
}
}
currentQuestion.userAnswerList = userAnswers;
}
questions[i] = currentQuestion;
}
currentUser.newTest.questions = questions;
//System.Diagnostics.Debug.WriteLine(currentUser.newTest.questions[4].userAnswerList[0].id);
}
private void HandleWikiPageProvision(ListItem listItem, WebPartDefinitionBase webpartModel)
{
if (!webpartModel.AddToPageContent)
{
return;
}
TraceService.Information((int)LogEventId.ModelProvisionCoreCall, "AddToPageContent = true. Handling wiki/publishig page provision case.");
var context = listItem.Context;
var targetFieldName = string.Empty;
if (listItem.FieldValues.ContainsKey(BuiltInInternalFieldNames.WikiField))
{
TraceService.Information((int)LogEventId.ModelProvisionCoreCall, "WikiField field is detected. Switching to wiki page web part provision.");
targetFieldName = BuiltInInternalFieldNames.WikiField;
}
else if (listItem.FieldValues.ContainsKey(BuiltInInternalFieldNames.PublishingPageLayout))
{
TraceService.Information((int)LogEventId.ModelProvisionCoreCall, "PublishingPageLayout field is detected. Switching to publishin page web part provision.");
targetFieldName = BuiltInInternalFieldNames.PublishingPageContent;
}
else
{
TraceService.Information((int)LogEventId.ModelProvisionCoreCall, "Not PublishingPageLayout field, nor WikiField is detected. Skipping.");
return;
}
var wikiTemplate = new StringBuilder();
var wpId = webpartModel.Id
.Replace("g_", string.Empty)
.Replace("_", "-");
var content = listItem[targetFieldName] == null
? string.Empty
: listItem[targetFieldName].ToString();
wikiTemplate.AppendFormat(
"<div class='ms-rtestate-read ms-rte-wpbox' contentEditable='false'>");
wikiTemplate.AppendFormat(" <div class='ms-rtestate-read {0}' id='div_{0}'>", wpId);
wikiTemplate.AppendFormat(" </div>");
wikiTemplate.AppendFormat("</div>");
var wikiResult = wikiTemplate.ToString();
if (string.IsNullOrEmpty(content))
{
TraceService.Verbose((int)LogEventId.ModelProvisionCoreCall, "Page content is empty Generating new one.");
content = wikiResult;
listItem[targetFieldName] = content;
listItem.Update();
context.ExecuteQueryWithTrace();
}
else
{
if (content.ToUpper().IndexOf(wpId.ToUpper()) == -1)
{
TraceService.VerboseFormat((int)LogEventId.ModelProvisionCoreCall, "Replacing web part with ID: [{0}] on the page content.", wpId);
content += wikiResult;
listItem[targetFieldName] = content;
listItem.Update();
context.ExecuteQueryWithTrace();
}
else
{
TraceService.WarningFormat((int)LogEventId.ModelProvisionCoreCall,
"Cannot find web part ID: [{0}] the page content. Provision won't add web part on the page content.",
new object[]
{
wpId
});
}
}
}
public void BindNumType(MapAttr mattr)
{
this.Pub1.AddTable("align=left");
this.Pub1.AddCaptionLeft("数据获取 - 当一个字段值需要从其它表中得到时，请设置此功能。");
this.Pub1.AddTR();
this.Pub1.Add("<TD>");
RadioBtn rb = new RadioBtn();
rb.GroupName = "s";
rb.Text = "方式0：不做任何设置。";
rb.ID = "RB_Way_0";
if (mattr.HisAutoFull == AutoFullWay.Way0)
{
rb.Checked = true;
}
this.Pub1.AddFieldSet(rb);
this.Pub1.Add("不做任何设置。");
this.Pub1.AddFieldSetEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.Add("<TD>");
rb = new RadioBtn();
rb.GroupName = "s";
rb.Text = "方式1：本表单中数据计算。"; //"";
rb.ID = "RB_Way_1";
if (mattr.HisAutoFull == AutoFullWay.Way1_JS)
{
rb.Checked = true;
}
this.Pub1.AddFieldSet(rb);
this.Pub1.Add("比如:@单价*@数量");
this.Pub1.AddBR();
TextBox tb = new TextBox();
tb.ID = "TB_JS";
tb.Width = 450;
tb.TextMode = TextBoxMode.MultiLine;
tb.Rows = 5;
if (mattr.HisAutoFull == AutoFullWay.Way1_JS)
{
tb.Text = mattr.AutoFullDoc;
}
this.Pub1.Add(tb);
this.Pub1.AddFieldSetEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
// 方式2 利用SQL自动填充
this.Pub1.AddTR();
this.Pub1.Add("<TD>");
rb = new RadioBtn();
rb.GroupName = "s";
rb.Text = "方式2：利用SQL自动填充。";
rb.ID = "RB_Way_2";
if (mattr.HisAutoFull == AutoFullWay.Way2_SQL)
{
rb.Checked = true;
}
this.Pub1.AddFieldSet(rb);
this.Pub1.Add("比如:Select Addr From 商品表 WHERE No=@FK_Pro FK_Pro是本表中的任意字段名<BR>");
tb = new TextBox();
tb.ID = "TB_SQL";
tb.Width = 450;
tb.TextMode = TextBoxMode.MultiLine;
tb.Rows = 5;
if (mattr.HisAutoFull == AutoFullWay.Way2_SQL)
{
tb.Text = mattr.AutoFullDoc;
}
this.Pub1.Add(tb);
this.Pub1.AddFieldSetEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
// 方式3 本表单中外键列
this.Pub1.AddTR();
this.Pub1.Add("<TD>");
rb = new RadioBtn();
rb.GroupName = "s";
rb.Text = "方式3：本表单中外键列。";
// rb.Text = "方式3：本表单中外键列</font></b>";
rb.ID = "RB_Way_3";
if (mattr.HisAutoFull == AutoFullWay.Way3_FK)
{
rb.Checked = true;
}
this.Pub1.AddFieldSet(rb);
this.Pub1.Add("比如:表单中有商品编号列,需要填充商品地址、供应商电话。");
this.Pub1.AddBR();
// 让它等于外键表的一个值。
Attrs attrs = null;
MapData md = new MapData();
md.No = mattr.FK_MapData;
if (md.RetrieveFromDBSources() == 0)
{
attrs = md.GenerHisMap().HisFKAttrs;
}
else
{
MapDtl mdtl = new MapDtl();
mdtl.No = mattr.FK_MapData;
attrs = mdtl.GenerMap().HisFKAttrs;
}
if (attrs.Count > 0)
{
}
else
{
rb.Enabled = false;
if (rb.Checked)
{
rb.Checked = false;
}
this.Pub1.Add("@本表没有外键字段。");
}
foreach (Attr attr in attrs)
{
if (attr.IsRefAttr)
{
continue;
}
rb = new RadioBtn();
rb.Text = attr.Desc;
rb.ID = "RB_FK_" + attr.Key;
rb.GroupName = "sd";
if (mattr.AutoFullDoc.Contains(attr.Key))
{
rb.Checked = true;
}
this.Pub1.Add(rb);
DDL ddl = new DDL();
ddl.ID = "DDL_" + attr.Key;
string sql = "";
switch (BP.SystemConfig.AppCenterDBType)
{
case DBType.Oracle:
case DBType.Informix:
continue;
sql = "Select fname as 'No' ,fDesc as 'Name' FROM Sys_FieldDesc WHERE tableName='" + attr.HisFKEn.EnMap.PhysicsTable + "'";
break;
default:
sql = "Select name as 'No' ,Name as 'Name' from syscolumns WHERE ID=OBJECT_ID('" + attr.HisFKEn.EnMap.PhysicsTable + "')";
break;
}
// string sql = "Select fname as 'No' ,fDesc as 'Name' FROM Sys_FieldDesc WHERE tableName='" + attr.HisFKEn.EnMap.PhysicsTable + "'";
//string sql = "Select NO , NAME FROM Port_Emp ";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
foreach (DataRow dr in dt.Rows)
{
// ddl.Items.Add(new ListItem(this.ToE("Field") + dr[0].ToString() + " " + this.ToE("Desc") + " " + dr[1].ToString(), dr[0].ToString()));
ListItem li = new ListItem(dr[0].ToString() + "；" + dr[1].ToString(), dr[0].ToString());
if (mattr.AutoFullDoc.Contains(dr[0].ToString()))
{
li.Selected = true;
}
ddl.Items.Add(li);
}
this.Pub1.Add(ddl);
this.Pub1.AddBR();
}
this.Pub1.AddFieldSetEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
// 方式3 本表单中外键列
this.Pub1.AddTR();
this.Pub1.Add("<TD>");
rb = new RadioBtn();
rb.GroupName = "s";
rb.Text = "方式4：对一个从表的列求值。";
rb.ID = "RB_Way_4";
if (mattr.HisAutoFull == AutoFullWay.Way4_Dtl)
{
rb.Checked = true;
}
this.Pub1.AddFieldSet(rb);
this.Pub1.Add("比如:对从表中的列求值。");
this.Pub1.AddBR();
// 让它对一个从表求和、求平均、求最大、求最小值。
MapDtls dtls = new MapDtls(mattr.FK_MapData);
if (dtls.Count > 0)
{
}
else
{
rb.Enabled = false;
if (rb.Checked)
{
rb.Checked = false;
}
// this.Pub1.Add("@没有从表。");
}
foreach (MapDtl dtl in dtls)
{
DDL ddlF = new DDL();
ddlF.ID = "DDL_" + dtl.No + "_F";
MapAttrs mattrs1 = new MapAttrs(dtl.No);
int count = 0;
foreach (MapAttr mattr1 in mattrs1)
{
if (mattr1.LGType != FieldTypeS.Normal)
{
continue;
}
if (mattr1.KeyOfEn == MapAttrAttr.MyPK)
{
continue;
}
if (mattr1.IsNum == false)
{
continue;
}
switch (mattr1.KeyOfEn)
{
case "OID":
case "RefOID":
case "FID":
continue;
default:
break;
}
count++;
ListItem li = new ListItem(mattr1.Name, mattr1.KeyOfEn);
if (mattr.HisAutoFull == AutoFullWay.Way4_Dtl)
{
if (mattr.AutoFullDoc.Contains("=" + mattr1.KeyOfEn))
{
li.Selected = true;
}
}
ddlF.Items.Add(li);
}
if (count == 0)
{
continue;
}
rb = new RadioBtn();
rb.Text = dtl.Name;
rb.ID = "RB_" + dtl.No;
rb.GroupName = "dtl";
if (mattr.AutoFullDoc.Contains(dtl.No))
{
rb.Checked = true;
}
this.Pub1.Add(rb);
DDL ddl = new DDL();
ddl.ID = "DDL_" + dtl.No + "_Way";
ddl.Items.Add(new ListItem("求合计", "SUM"));
ddl.Items.Add(new ListItem("求平均", "AVG"));
ddl.Items.Add(new ListItem("求最大", "MAX"));
ddl.Items.Add(new ListItem("求最小", "MIN"));
this.Pub1.Add(ddl);
if (mattr.HisAutoFull == AutoFullWay.Way4_Dtl)
{
if (mattr.AutoFullDoc.Contains("SUM"))
{
ddl.SetSelectItem("SUM");
}
if (mattr.AutoFullDoc.Contains("AVG"))
{
ddl.SetSelectItem("AVG");
}
if (mattr.AutoFullDoc.Contains("MAX"))
{
ddl.SetSelectItem("MAX");
}
if (mattr.AutoFullDoc.Contains("MIN"))
{
ddl.SetSelectItem("MIN");
}
}
this.Pub1.Add(ddlF);
this.Pub1.AddBR();
}
this.Pub1.AddFieldSetEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
#region 方式5
//this.Pub1.AddTD();
//this.Pub1.AddTR();
//this.Pub1.AddFieldSet(rb);
//this.Pub1.Add(this.ToE("Way2D", "嵌入的JS"));
//tb = new TextBox();
//tb.ID = "TB_JS";
//tb.Width = 450;
//tb.TextMode = TextBoxMode.MultiLine;
//tb.Rows = 5;
//if (mattr.HisAutoFull == AutoFullWay.Way5_JS)
// tb.Text = mattr.AutoFullDoc;
//this.Pub1.Add(tb);
//this.Pub1.AddFieldSetEnd();
//this.Pub1.AddTDEnd();
//this.Pub1.AddTREnd();
#endregion 方式5
this.Pub1.AddTRSum();
this.Pub1.AddTDBegin("aligen=center");
Button btn = new Button();
btn.ID = "Btn_Save";
btn.CssClass = "Btn";
btn.Text = " 保存 ";
btn.Click += new EventHandler(btn_Click);
this.Pub1.Add(btn);
btn = new Button();
btn.ID = "Btn_SaveAndClose";
btn.CssClass = "Btn";
btn.Text = " 保存并关闭 ";
btn.Click += new EventHandler(btn_Click);
this.Pub1.Add(btn);
this.Pub1.AddTREnd();
this.Pub1.AddTableEnd();
return;
}
void BindChannel()
{
string enumState = "";
if (Int32.Parse(InfomationType) < 2)
{
enumState = "0" + InfomationType;
}
else
{
enumState = InfomationType;
}
//此处加载权限过滤栏目
List <Channel> channelList = new List <Channel>();
if (We7Helper.IsEmptyID(AccountID))
{
channelList = ChannelHelper.GetChannelsByType(enumState);
}
else
{
List <string> channelIds = AccountHelper.GetObjectsByPermission(AccountID, "Channel.Input");
if (channelIds != null && channelIds.Count > 0)
{
channelList = ChannelHelper.GetChannelByIDList(enumState, channelIds);
}
}
List <Channel> removeList = new List <Channel>();
foreach (Channel ch in channelList)
{
if (String.IsNullOrEmpty(ch.ModelName))
{
continue;
}
if (String.Compare(ch.ModelName, "Article", true) == 0)
{
continue;
}
if (String.Compare(ch.ModelName, "System.Article", true) == 0)
{
continue;
}
removeList.Add(ch);
}
foreach (Channel ch in removeList)
{
channelList.Remove(ch);
}
if (channelList != null && channelList.Count > 0)
{
channelList.Sort();
foreach (Channel ch in channelList)
{
string name = ch.FullPath.Replace("//", "/").Replace("/", " 》");
string value = ch.ID;
ListItem item = new ListItem(name, value);
ChannelDropDownList.Items.Add(item);
}
}
}
private void PopulateLabels()
{
Title = SiteUtils.FormatPageTitle(siteSettings, Resource.ProfileLink);
litSecurityTab.Text = "<a href='#tabSecurity'>" + Resource.UserProfileSecurityTab + "</a>";
litProfileTab.Text = "<a href='#" + tabProfile.ClientID + "'>" + Resource.UserProfileProfileTab + "</a>";
litOrderHistoryTab.Text = "<a href='#" + tabOrderHistory.ClientID + "'>" + Resource.CommerceOrderHistoryTab + "</a>";
litNewsletterTab.Text = "<a href='#" + tabNewsletters.ClientID + "'>" + Resource.UserProfileNewslettersTab + "</a>";
lnkAllowLiveMessenger.Text = Resource.EnableLiveMessengerLink;
btnUpdate.Text = Resource.UserProfileUpdateButton;
SiteUtils.SetButtonAccessKey(btnUpdate, AccessKeys.UserProfileSaveButtonAccessKey);
if ((siteSettings.AllowUserEditorPreference) && (ddEditorProviders.Items.Count == 0))
{
ddEditorProviders.DataSource = EditorManager.Providers;
ddEditorProviders.DataBind();
foreach (ListItem providerItem in ddEditorProviders.Items)
{
providerItem.Text = providerItem.Text.Replace("Provider", string.Empty);
}
ListItem listItem = new ListItem();
listItem.Value = string.Empty;
listItem.Text = Resource.SiteDefaultEditor;
ddEditorProviders.Items.Insert(0, listItem);
}
//if ((!allowGravatars)&&(!disableOldAvatars)&&(!Page.IsPostBack))
//{
// ddAvatars.DataSource = SiteUtils.GetAvatarList(this.siteSettings);
// ddAvatars.DataBind();
// ddAvatars.Items.Insert(0, new ListItem(Resource.UserProfileNoAvatarLabel, "blank.gif"));
// ddAvatars.Attributes.Add("onChange", "javascript:showAvatar(this);");
// ddAvatars.Attributes.Add("size", "6");
//}
// lnkPublicProfile.DialogCloseText = Resource.DialogCloseLink;
//lnkPublicProfile.Text = Resource.PublicProfileLink;
lnkPubProfile.Text = Resource.PublicProfileLink;
lnkPubProfile.ToolTip = Resource.PublicProfileLink;
rfvName.ErrorMessage = Resource.UserProfileNameRequired;
regexEmail.ErrorMessage = Resource.UserProfileEmailValidation;
rfvEmail.ErrorMessage = Resource.UserProfileEmailRequired;
QuestionRequired.ErrorMessage = Resource.RegisterSecurityQuestionRequiredMessage;
AnswerRequired.ErrorMessage = Resource.RegisterSecurityAnswerRequiredMessage;
//regexAvatarFile.ErrorMessage = Resource.FileTypeNotAllowed;
//regexAvatarFile.ValidationExpression = SecurityHelper.GetRegexValidationForAllowedExtensions(SiteUtils.ImageFileExtensions());
//lnkAvatarUpload.Text = Resource.UploadAvatarLink;
lnkAvatarUpld.Text = Resource.UploadAvatarLink;
lnkAvatarUpld.ToolTip = Resource.UploadAvatarLink;
btnUpdateAvartar.ImageUrl = Page.ResolveUrl("~/Data/SiteImages/1x1.gif");
btnUpdateAvartar.Attributes.Add("tabIndex", "-1");
if (allowGravatars)
{
//gravatar1.Visible = true;
//ddAvatars.Visible = false;
//imgAvatar.Visible = false;
avatarHelp.Visible = false;
//lnkAvatarUpload.Visible = false;
lnkAvatarUpld.Visible = false;
}
else
{
//gravatar1.Visible = false;
if (disableAvatars)
{
divAvatar.Visible = false;
//imgAvatar.Visible = false;
avatarHelp.Visible = false;
//lnkAvatarUpload.Visible = false;
lnkAvatarUpld.Visible = false;
}
else
{
//lblMaxAvatarSize.Text = string.Format(Resource.AvatarMaxSizeLabelFormat, WebConfigSettings.AvatarMaxWidth.ToInvariantString(), WebConfigSettings.AvatarMaxHeight.ToInvariantString());
//imgAvatar.Visible = true;
if (!WebConfigSettings.AvatarsCanOnlyBeUploadedByAdmin)
{
avatarHelp.Visible = true;
}
}
}
lnkOpenIDUpdate.Text = Resource.OpenIDUpdateButton;
lnkOpenIDUpdate.ToolTip = Resource.OpenIDUpdateButton;
lnkOpenIDUpdate.NavigateUrl = SiteRoot + "/Secure/UpdateOpenID.aspx";
rpxLink.OverrideText = Resource.OpenIDUpdateButton;
pnlSecurityQuestion.Visible = siteSettings.RequiresQuestionAndAnswer;
}
/// <summary>Flush hanging leaves.</summary>
/// <param name="container">a container element</param>
public virtual void FlushHangingLeaves(IPropertyContainer container)
{
Paragraph p = CreateLeavesContainer();
if (p != null)
{
IDictionary <String, String> map = new Dictionary <String, String>();
map.Put(CssConstants.OVERFLOW, CommonCssConstants.VISIBLE);
OverflowApplierUtil.ApplyOverflow(map, p);
if (container is Document)
{
((Document)container).Add(p);
}
else
{
if (container is Paragraph)
{
foreach (IElement leafElement in waitingLeaves)
{
if (leafElement is ILeafElement)
{
((Paragraph)container).Add((ILeafElement)leafElement);
}
else
{
if (leafElement is IBlockElement)
{
((Paragraph)container).Add((IBlockElement)leafElement);
}
}
}
}
else
{
if (container is Div)
{
((Div)container).Add(p);
}
else
{
if (container is Cell)
{
((Cell)container).Add(p);
}
else
{
if (container is List)
{
ListItem li = new ListItem();
li.Add(p);
((List)container).Add(li);
}
else
{
throw new InvalidOperationException("Unable to process hanging inline content");
}
}
}
}
}
waitingLeaves.Clear();
}
}
private bool getNewRandomJob()
{
double price = 0;
bool success = Double.TryParse(Hidden_Price.Value, out price);
if (!success)
{
price = 0;
}
SatyamTaskTableAccess taskTableDB = new SatyamTaskTableAccess();
SatyamTaskTableEntry entry = null;
if (Submit_Button.Enabled == true)
{
//entry = taskTableDB.getMinimumTriedNewEntryForWorkerIDByTemplateAndPrice(Hidden_AmazonWorkerID.Value,
// TaskConstants.TrackletLabeling_MTurk, price);
entry = taskTableDB.getTopKNewEntryForWorkerIDByTemplateAndPrice(50, Hidden_AmazonWorkerID.Value,
TaskConstants.TrackletLabeling_MTurk, price);
}
else
{
entry = taskTableDB.getMinimumTriedEntryByTemplate(TaskConstants.TrackletLabeling_MTurk);
}
taskTableDB.close();
if (entry == null)
{
return(false);
}
taskTableDB = new SatyamTaskTableAccess();
taskTableDB.IncrementDoneScore(entry.ID);
taskTableDB.close();
SatyamTask task = JSonUtils.ConvertJSonToObject <SatyamTask>(entry.TaskParametersString);
SatyamJobStorageAccountAccess satyamStorage = new SatyamJobStorageAccountAccess();
string videoDir = URIUtilities.localDirectoryFullPathFromURI(task.SatyamURI);
List <string> ImageURLs = satyamStorage.getURLListOfSpecificExtensionUnderSubDirectoryByURI(videoDir, new List <string>()
{
"jpg"
});
string annotationFilePath = task.SatyamURI;
//string urls = "";
//for (int i=0;i<ImageURLs.Count;i++)
//{
// urls += ImageURLs[i];
// if (i == ImageURLs.Count - 1) break;
// urls += ',';
//}
Hidden_ImageURLList.Value = ObjectsToStrings.ListString(ImageURLs, ',');
SatyamJob jobDefinitionEntry = task.jobEntry;
MultiObjectTrackingSubmittedJob job = JSonUtils.ConvertJSonToObject <MultiObjectTrackingSubmittedJob>(jobDefinitionEntry.JobParameters);
Dictionary <string, List <string> > subcategories = job.Categories;
List <string> categories = subcategories.Keys.ToList();
//CategorySelection_RakdioButtonList.Items.Clear();
for (int i = 0; i < categories.Count; i++)
{
ListItem l = new ListItem(categories[i]);
//CategorySelection_RadioButtonList.Items.Add(l);
}
if (job.Description != "")
{
//DescriptionPanel.Visible = true;
//DescriptionTextPanel.Controls.Add(new LiteralControl(job.Description));
}
//Hidden_BoundaryLines.Value = JSonUtils.ConvertObjectToJSon(job.BoundaryLines);
Hidden_TaskEntryString.Value = JSonUtils.ConvertObjectToJSon <SatyamTaskTableEntry>(entry);
Hidden_PageLoadTime.Value = DateTime.Now.ToString();
// pass parameters from old template
Slug_Hidden.Value = "null";
Start_Hidden.Value = "0";
Stop_Hidden.Value = (ImageURLs.Count - 1).ToString();
Skip_Hidden.Value = "0";
PerObject_Hidden.Value = "0.1";
Completion_Hidden.Value = "0.5";
BlowRadius_Hidden.Value = "0";
JobId_Hidden.Value = "1";
LabelString_Hidden.Value = ObjectsToStrings.ListString(categories.ToList(), ',');
Attributes_Hidden.Value = ObjectsToStrings.DictionaryStringListString(subcategories, ',', ':', '_');
Training_Hidden.Value = "0";
fps_Hidden.Value = job.FrameRate.ToString();
Hidden_ChunkDuration.Value = job.ChunkDuration.ToString();
var web = new WebClient();
System.Drawing.Image x = System.Drawing.Image.FromStream(web.OpenRead(ImageURLs[0]));
ImageWidth_Hidden.Value = x.Width.ToString();
ImageHeight_Hidden.Value = x.Height.ToString();
// image boundary for now
//string[] region = new string[] { "0-0-1242-0-1242-375-0-375-0-0" };
string[] region = new string[] { "0-0-" + x.Width + "-0-" + x.Width + "-" + x.Height + "-0-" + x.Height + "-0-0" };
RegionString_Hidden.Value = ObjectsToStrings.ListString(region, ',');
// temp test
List <VATIC_Tracklet> prevTracesTemp = new List <VATIC_Tracklet>();
WebClient client = new WebClient();
Stream stream = client.OpenRead(annotationFilePath);
StreamReader reader = new StreamReader(stream);
List <string> trace = new List <string>();
while (reader.Peek() >= 0)
{
string content = reader.ReadLine();
trace.Add(content);
}
Dictionary <string, VATIC_Tracklet> tracklets = VATIC_Tracklet.ReadTrackletsFromVIRAT(trace);
foreach (string id in tracklets.Keys)
{
//string output = JSonUtils.ConvertObjectToJSon(tracklets[id]);
prevTracesTemp.Add(tracklets[id]);
}
string output = JSonUtils.ConvertObjectToJSon(prevTracesTemp);
PreviousTrackString_Hidden.Value = output;
return(true);
}
// Publish results from selected query to SharePoint Online
private void publishToSharepoint()
{
// Perform search
string XMLOutput = this.EARepository.SQLQuery(tbQuery.Text);
XDocument XMLDoc = XDocument.Parse(XMLOutput);
// Check whether the query returns any results
if (XMLDoc.Root.Element("Dataset_0").Element("Data").HasElements)
{
// Update progress information
statusStrip.Invoke((Action) delegate { lblStatus.Text = "Publishing ..."; });
statusStrip.Invoke((Action) delegate { progressBar.Value = 10; });
// Connect to SharePoint Online
using (ClientContext clientContext = new ClientContext(new Uri(tbSharepointSite.Text)))
{
try
{
// Connect to SharePoint (Office365)
clientContext.Credentials = this.sharepointCredentials;
Web web = clientContext.Web;
// Open list
string selectedList = (string)cbLists.Items[cbLists.SelectedIndex];
List list = web.Lists.GetByTitle(selectedList);
FieldCollection fieldCollection = list.Fields;
clientContext.Load(fieldCollection);
clientContext.ExecuteQuery();
// Retrieve and store list column information
Dictionary <string, string> Fields = new Dictionary <string, string>();
foreach (Field tmpField in fieldCollection)
{
if (!Fields.ContainsKey(tmpField.Title))
{
Fields[tmpField.Title] = tmpField.InternalName;
}
}
// Purge (empty) list if this option has been selected
if (cbPurgeList.Checked)
{
// Get all list items
ListItemCollection listItems = list.GetItems(CamlQuery.CreateAllItemsQuery());
clientContext.Load(listItems, eachItem => eachItem.Include(item => item, item => item["ID"]));
clientContext.ExecuteQuery();
// Delete all list items
var totalListItems = listItems.Count;
if (totalListItems > 0)
{
for (var counter = totalListItems - 1; counter > -1; counter--)
{
listItems[counter].DeleteObject();
}
// Execute query
clientContext.ExecuteQuery();
}
}
// Loop through query results
foreach (XElement Node in XMLDoc.Root.Element("Dataset_0").Element("Data").Elements())
{
ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
ListItem newItem = list.AddItem(itemCreateInfo);
foreach (XElement Field in Node.Elements())
{
if (Fields.ContainsKey(Field.Name.LocalName))
{
string tmpInternalName = Fields[Field.Name.LocalName];
newItem[tmpInternalName] = Field.Value;
}
// Save item
newItem.Update();
// Update progressbar
statusStrip.Invoke((Action) delegate { progressBar.Value += 1; });
}
}
// Execute query
clientContext.ExecuteQuery();
}
catch (Exception exception)
{
MessageBox.Show("An error has occured: " +
System.Environment.NewLine + System.Environment.NewLine + exception.Message);
}
}
}
// Update progress information
statusStrip.Invoke((Action) delegate { lblStatus.Text = "Done"; });
statusStrip.Invoke((Action) delegate { progressBar.Value = 100; });
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!CurrUser.userRole.CompanySetup)
{
Response.Redirect("../Unauthorize.aspx");
Response.End();
}
this.imgUserPic.Attributes.Add("onload", string.Format("resizeImage('{0}')", this.imgUserPic.ClientID));
// get UserId from query string
int nUserId = -1;
if (!int.TryParse(Request.QueryString["uid"], out nUserId))
{
nUserId = -1;
}
if (-1 == nUserId)
{
UserId = null;
}
else
{
UserId = nUserId;
}
BLL.Company_General comGeneral = new BLL.Company_General();
Model.Company_General company = comGeneral.GetModel();
if (null != company)
{
this.lbPrefix.Text = company.AD_OU_Filter;
}
// bind User Loan Rep gridview
BindLoanRep();
// bind Group gridview
BindGroup();
// bind Role dropdown list
BLL.Roles RolesManager = new BLL.Roles();
DataSet dsRoles = RolesManager.GetList(string.Empty);
this.ddlRole.DataSource = dsRoles;
this.ddlRole.DataValueField = "RoleId";
this.ddlRole.DataTextField = "Name";
this.ddlRole.DataBind();
this.ddlRole.Items.Insert(0, new ListItem("Please Select", ""));
Mode = Request.QueryString["mode"];
if ("0" == Mode)
{
this.btnDelete.Enabled = false;
this.btnClone.Enabled = false;
}
if ("1" == Mode)
{
// Load user info
if (!UserId.HasValue)
{
// if no UserId，thorw exception
LPLog.LogMessage(LogType.Logerror, "Invalid UserId");
throw new Exception("Invalid UserId");
}
else
{
Model.Users user = UsersManager.GetModel(UserId.Value);
if (null == user)
{
LPLog.LogMessage(LogType.Logerror, string.Format("Cannot find the user with UserId = {0}", UserId.Value));
}
else
{
this.ckbEnabled.Checked = user.UserEnabled;
this.tbUserName.Text = user.Username;
this.tbEmail.Text = user.EmailAddress;
this.tbFirstName.Text = user.FirstName;
this.tbLastName.Text = user.LastName;
ListItem item = this.ddlRole.Items.FindByValue(user.RoleId.ToString());
if (null != item)
{
this.ddlRole.ClearSelection();
item.Selected = true;
}
this.hiUserLoanCount.Value = LoanTeamManager.GetUserLoanCount(UserId.Value).ToString();
this.hiUserContactCount.Value = ContactUsersManager.GetUserContactCount(UserId.Value).ToString();
//gdc 20110606 Add
this.txbPhone.Text = user.Phone;
this.txbFax.Text = user.Fax;
this.txbCell.Text = user.Cell;
this.txbBranchManagerCompensation.Text = user.BranchMgrComp.ToString("00.000");
this.txbDivisionManagerCompensation.Text = user.DivisionMgrComp.ToString("00.000");
this.txbLoanOfficerCompenstation.Text = user.LOComp.ToString("00.000");
this.txbRegionalManagerCompensation.Text = user.RegionMgrComp.ToString("00.000");
//ExchangePassword
this.txbExchangePassword.Text = user.ExchangePassword;
this.txbExchangePassword.Attributes.Add("value", user.ExchangePassword);
}
}
}
if (UserId.HasValue && Mode == "1")
{
this.tbUserName.Enabled = false;
this.tbUserName.BackColor = System.Drawing.Color.LightGray;
}
else
{
this.tbUserName.Enabled = true;
this.tbUserName.BackColor = System.Drawing.Color.Transparent;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
userid = BasePage.GetRequestId(Cookies.GetCookie("User_Id").ToString());
if (!Page.IsPostBack)
{
((Literal)Master.FindControl("breadcrumbs")).Text = "<a href=\"AdminAdd.aspx\" class=\"home\">添加管理员</a>";
string checklogin = new AdminBll().CheckLogin("no");
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
txtadmin1.Visible = false;//模型权限勾选，只允许两个用户可设置
txtadmin.Visible = false;
if (userid == 1)
{
txtadmin.Visible = true;//设置其它管理员默认权限
txtadmin1.Visible = true;
}
else if (userid == 2)
{
txtadmin1.Visible = true;
}
int id = BasePage.GetRequestId(Request.QueryString["id"]);
ActionName.Text = "添加网站管理员";
//动态模型，其它管理员不显示这个
if (userid == 1)
{
DataSet ds = new DataSet();
ds = new CommonBll().GetList("", "GL_Model", "ModelLock=0", "id asc");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem ListItem1 = new ListItem(dr["ModelName"].ToString() + "内容管理", "m" + dr["id"].ToString());
string[] a = dr["ModeContent"].ToString().Split('`');
if (a[5] == "1")//需要审核时显示
{
ListItem ListItem2 = new ListItem(dr["ModelName"].ToString() + "发表审核", "ms" + dr["id"].ToString());
txtModelPower.Items.Add(ListItem2);
}
ListItem ListItem3 = new ListItem(dr["ModelName"].ToString() + "内容删除", "md" + dr["id"].ToString());
ListItem ListItem4 = new ListItem(dr["ModelName"].ToString() + "栏目添加", "ca" + dr["id"].ToString());
ListItem ListItem5 = new ListItem(dr["ModelName"].ToString() + "栏目编辑", "ce" + dr["id"].ToString());
ListItem ListItem6 = new ListItem(dr["ModelName"].ToString() + "栏目删除", "cd" + dr["id"].ToString());
ListItem ListItem7 = new ListItem(dr["ModelName"].ToString() + "字段管理", "z" + dr["id"].ToString());
txtModelPower.Items.Add(ListItem1);
txtModelPower.Items.Add(ListItem3);
txtModelPower.Items.Add(ListItem4);
txtModelPower.Items.Add(ListItem5);
txtModelPower.Items.Add(ListItem6);
txtModelPower.Items.Add(ListItem7);
}
}
}
if (id != 0)//编辑
{
if (userid == 2)//二管理员
{
string adminpur = new CommonBll().GetTitle("GL_Webconfig", "adminpur", 1);
if (!String.IsNullOrEmpty(adminpur))
{
string[] ap = adminpur.Split('|');
for (int i = 0; i < ap.Length; i++)
{
string[] ap2 = ap[i].Split(',');
ListItem ListItem1 = new ListItem(ap2[0], ap2[1]);
txtModelPower2.Items.Add(ListItem1);
}
}
}
AdminModel model = new AdminBll().GetModel(id);
txtUserName.Text = model.UserName;
txtEmail.Text = model.Email;
txtPassWordOld.Value = model.PassWord;
txtTTelPhone.Text = model.TelPhone;
if (model.Sex == 0)
{
TxtSex.Checked = true;
}
else
{
TxtSex1.Checked = true;
}
if (model.Locked == 1)
{
txtLocked.Checked = true;
}
if (Request.QueryString["id"] == "1")
{
txtLocked.Enabled = false;//管理员时锁定
}
if (userid == 1)
{
SetChecked(this.txtModelPower, model.ModelPower, ",");
}
else if (userid == 2)
{
SetChecked(this.txtModelPower2, model.ModelPower, ",");
}
Literal1.Text = " 不修改密码请留空！";
ActionName.Text = "修改" + txtUserName.Text + "资料";
string other = "";
other += "<tr><td class=\"align-right\">添加时间：</td><td class=\"align-left\">" +BasePage.formatDateTime(model.AddDate.ToString()) + "</td></tr>";
other += "<tr><td class=\"align-right\">登录次数：</td><td class=\"align-left\">" + model.LoginTime + "</td></tr>";
other += "<tr><td class=\"align-right\">最后登录：</td><td class=\"align-left\">" + BasePage.formatDateTime(model.LastLoginTime.ToString()) + "</td></tr>";
other += "<tr><td class=\"align-right\">最后登录IP：</td><td class=\"align-left\">" + model.LastLoginIP + "</td></tr>";
Literal2.Text = other;
Button1.Text = "确认修改";
HiddenFieldmp.Value = model.ModelPower;
}
}
}
public override TokenParser ProvisionObjects(Web web, ProvisioningTemplate template, TokenParser parser, ProvisioningTemplateApplyingInformation applyingInformation)
{
using (var scope = new PnPMonitoredScope(this.Name))
{
if (template.Lists.Any())
{
var rootWeb = (web.Context as ClientContext).Site.RootWeb;
web.EnsureProperties(w => w.ServerRelativeUrl);
web.Context.Load(web.Lists, lc => lc.IncludeWithDefaultProperties(l => l.RootFolder.ServerRelativeUrl));
web.Context.ExecuteQueryRetry();
var existingLists = web.Lists.AsEnumerable <List>().Select(existingList => existingList.RootFolder.ServerRelativeUrl).ToList();
var serverRelativeUrl = web.ServerRelativeUrl;
#region DataRows
foreach (var listInstance in template.Lists)
{
if (listInstance.DataRows != null && listInstance.DataRows.Any())
{
scope.LogDebug(CoreResources.Provisioning_ObjectHandlers_ListInstancesDataRows_Processing_data_rows_for__0_, listInstance.Title);
// Retrieve the target list
var list = web.Lists.GetByTitle(parser.ParseString(listInstance.Title));
web.Context.Load(list);
// Retrieve the fields' types from the list
Microsoft.SharePoint.Client.FieldCollection fields = list.Fields;
web.Context.Load(fields, fs => fs.Include(f => f.InternalName, f => f.FieldTypeKind, f => f.TypeAsString));
web.Context.ExecuteQueryRetry();
var keyColumnType = "Text";
var parsedKeyColumn = parser.ParseString(listInstance.DataRows.KeyColumn);
if (!string.IsNullOrEmpty(parsedKeyColumn))
{
var keyColumn = fields.FirstOrDefault(f => f.InternalName.Equals(parsedKeyColumn, StringComparison.InvariantCultureIgnoreCase));
if (keyColumn != null)
{
switch (keyColumn.FieldTypeKind)
{
case FieldType.User:
case FieldType.Lookup:
keyColumnType = "Lookup";
break;
case FieldType.URL:
keyColumnType = "Url";
break;
case FieldType.DateTime:
keyColumnType = "DateTime";
break;
case FieldType.Number:
case FieldType.Counter:
keyColumnType = "Number";
break;
}
}
}
foreach (var dataRow in listInstance.DataRows)
{
try
{
scope.LogDebug(CoreResources.Provisioning_ObjectHandlers_ListInstancesDataRows_Creating_list_item__0_, listInstance.DataRows.IndexOf(dataRow) + 1);
bool create = true;
ListItem listitem = null;
if (!string.IsNullOrEmpty(listInstance.DataRows.KeyColumn))
{
// if it is empty, skip the check
if (!string.IsNullOrEmpty(dataRow.Key))
{
var query = $@"<View><Query><Where><Eq><FieldRef Name=""{parsedKeyColumn}""/><Value Type=""{keyColumnType}"">{parser.ParseString(dataRow.Key)}</Value></Eq></Where></Query><RowLimit>1</RowLimit></View>";
var camlQuery = new CamlQuery()
{
ViewXml = query
};
var existingItems = list.GetItems(camlQuery);
list.Context.Load(existingItems);
list.Context.ExecuteQueryRetry();
if (existingItems.Count > 0)
{
if (listInstance.DataRows.UpdateBehavior == UpdateBehavior.Skip)
{
create = false;
}
else
{
listitem = existingItems[0];
create = true;
}
}
}
}
if (create)
{
if (listitem == null)
{
var listitemCI = new ListItemCreationInformation();
listitem = list.AddItem(listitemCI);
}
foreach (var dataValue in dataRow.Values)
{
Field dataField = fields.FirstOrDefault(
f => f.InternalName == parser.ParseString(dataValue.Key));
if (dataField != null)
{
String fieldValue = parser.ParseString(dataValue.Value);
switch (dataField.FieldTypeKind)
{
case FieldType.Geolocation:
// FieldGeolocationValue - Expected format: Altitude,Latitude,Longitude,Measure
var geolocationArray = fieldValue.Split(',');
if (geolocationArray.Length == 4)
{
var geolocationValue = new FieldGeolocationValue
{
Altitude = Double.Parse(geolocationArray[0]),
Latitude = Double.Parse(geolocationArray[1]),
Longitude = Double.Parse(geolocationArray[2]),
Measure = Double.Parse(geolocationArray[3]),
};
listitem[parser.ParseString(dataValue.Key)] = geolocationValue;
}
else
{
listitem[parser.ParseString(dataValue.Key)] = fieldValue;
}
break;
case FieldType.Lookup:
// FieldLookupValue - Expected format: LookupID or LookupID,LookupID,LookupID...
if (fieldValue.Contains(","))
{
var lookupValues = new List <FieldLookupValue>();
fieldValue.Split(',').All(value =>
{
lookupValues.Add(new FieldLookupValue
{
LookupId = int.Parse(value),
});
return(true);
});
listitem[parser.ParseString(dataValue.Key)] = lookupValues.ToArray();
}
else
{
var lookupValue = new FieldLookupValue
{
LookupId = int.Parse(fieldValue),
};
listitem[parser.ParseString(dataValue.Key)] = lookupValue;
}
break;
case FieldType.URL:
// FieldUrlValue - Expected format: URL,Description
var urlArray = fieldValue.Split(',');
var linkValue = new FieldUrlValue();
if (urlArray.Length == 2)
{
linkValue.Url = urlArray[0];
linkValue.Description = urlArray[1];
}
else
{
linkValue.Url = urlArray[0];
linkValue.Description = urlArray[0];
}
listitem[parser.ParseString(dataValue.Key)] = linkValue;
break;
case FieldType.User:
// FieldUserValue - Expected format: loginName or loginName,loginName,loginName...
if (fieldValue.Contains(","))
{
var userValues = new List <FieldUserValue>();
fieldValue.Split(',').All(value =>
{
var user = web.EnsureUser(value);
web.Context.Load(user);
web.Context.ExecuteQueryRetry();
if (user != null)
{
userValues.Add(new FieldUserValue
{
LookupId = user.Id,
});;
}
return(true);
});
listitem[parser.ParseString(dataValue.Key)] = userValues.ToArray();
}
else
{
var user = web.EnsureUser(fieldValue);
web.Context.Load(user);
web.Context.ExecuteQueryRetry();
if (user != null)
{
var userValue = new FieldUserValue
{
LookupId = user.Id,
};
listitem[parser.ParseString(dataValue.Key)] = userValue;
}
else
{
listitem[parser.ParseString(dataValue.Key)] = fieldValue;
}
}
break;
case FieldType.DateTime:
var dateTime = DateTime.MinValue;
if (DateTime.TryParse(fieldValue, out dateTime))
{
listitem[parser.ParseString(dataValue.Key)] = dateTime;
}
break;
default:
listitem[parser.ParseString(dataValue.Key)] = fieldValue;
break;
}
}
}
listitem.Update();
web.Context.ExecuteQueryRetry(); // TODO: Run in batches?
if (dataRow.Security != null && (dataRow.Security.ClearSubscopes == true || dataRow.Security.CopyRoleAssignments == true || dataRow.Security.RoleAssignments.Count > 0))
{
listitem.SetSecurity(parser, dataRow.Security);
}
}
}
catch (Exception ex)
{
if (ex.GetType().Equals(typeof(ServerException)) &&
(ex as ServerException).ServerErrorTypeName.Equals("Microsoft.SharePoint.SPDuplicateValuesFoundException", StringComparison.InvariantCultureIgnoreCase) &&
applyingInformation.IgnoreDuplicateDataRowErrors)
{
scope.LogWarning(CoreResources.Provisioning_ObjectHandlers_ListInstancesDataRows_Creating_listitem_duplicate);
continue;
}
else
{
scope.LogError(CoreResources.Provisioning_ObjectHandlers_ListInstancesDataRows_Creating_listitem_failed___0_____1_, ex.Message, ex.StackTrace);
throw;
}
}
}
}
}
#endregion
}
}
return(parser);
}
protected virtual string GetWebpartXmlDefinition(ListItemModelHost listItemModelHost, WebPartDefinitionBase webPartModel)
{
var result = string.Empty;
var context = listItemModelHost.HostListItem.Context;
if (!string.IsNullOrEmpty(webPartModel.WebpartFileName))
{
lock (_wpCacheLock)
{
var wpKey = webPartModel.WebpartFileName.ToLower();
if (_wpCache.ContainsKey(wpKey))
{
result = _wpCache[wpKey];
}
else
{
var rootWeb = listItemModelHost.HostSite.RootWeb;
var rootWebContext = rootWeb.Context;
var webPartCatalog =
rootWeb.QueryAndGetListByUrl(BuiltInListDefinitions.Calalogs.Wp.GetListUrl());
//var webParts = webPartCatalog.GetItems(CamlQuery.CreateAllItemsQuery());
//rootWebContext.Load(webParts);
//rootWebcontext.ExecuteQueryWithTrace();
ListItem targetWebPart = SearchItemByName(webPartCatalog, webPartCatalog.RootFolder,
webPartModel.WebpartFileName);
//foreach (var webPart in webParts)
// if (webPart["FileLeafRef"].ToString().ToUpper() == webPartModel.WebpartFileName.ToUpper())
// targetWebPart = webPart;
if (targetWebPart == null)
{
throw new SPMeta2Exception(string.Format("Cannot find web part file by name:[{0}]",
webPartModel.WebpartFileName));
}
var webPartFile = targetWebPart.File;
rootWebContext.Load(webPartFile);
rootWebContext.ExecuteQueryWithTrace();
// does not work for apps - https://github.com/SubPointSolutions/spmeta2/issues/174
//var fileInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(listItemModelHost.HostclientContext, webPartFile.ServerRelativeUrl);
//using (var reader = new StreamReader(fileInfo.Stream))
//{
// webPartXML = reader.ReadToEnd();
//}
var data = webPartFile.OpenBinaryStream();
context.Load(webPartFile);
context.ExecuteQueryWithTrace();
using (var reader = new StreamReader(data.Value))
{
result = reader.ReadToEnd();
}
if (!_wpCache.ContainsKey(wpKey))
{
_wpCache.Add(wpKey, result);
}
else
{
_wpCache[wpKey] = result;
}
}
}
}
if (!string.IsNullOrEmpty(webPartModel.WebpartType))
{
throw new Exception("WebpartType is not supported yet.");
}
if (!string.IsNullOrEmpty(webPartModel.WebpartXmlTemplate))
{
result = webPartModel.WebpartXmlTemplate;
}
return(result);
}
private void PopulateAddress()
{
if (_address != null)
{
_hasChanged = false;
chkUserSaved.Checked = _address.UserSaved;
chkPrimary.Checked = _address.PrimaryAddress;
txtDescription.Text = _address.Description;
txtFirstName.Text = _address.FirstName;
txtLastName.Text = _address.LastName;
txtStreet.Text = _address.Address1;
txtUnit.Text = _address.Address2;
txtPostal.Text = _address.PostalCode;
txtCity.Text = _address.City;
txtEmail.Text = _address.Email;
txtTelephone.Text = _address.Phone1;
txtCell.Text = _address.Phone2;
if (UserController.Instance.GetCurrentUserInfo().UserID != _address.UserID)
{
chkUserSaved.Checked = false;
ShowDescription = false;
chkPrimary.Checked = false;
txtDescription.Text = "";
}
cboCountry.ClearSelection();
if (string.IsNullOrEmpty(_address.CountryCode))
cboCountry.SelectedIndex = 0;
else
{
ListItem country = null;
if (_settings.CountryData.ToLower() == "text")
country = cboCountry.Items.FindByText(_address.CountryCode);
else if (_settings.CountryData.ToLower() == "value")
country = cboCountry.Items.FindByValue(_address.CountryCode);
if (country != null)
country.Selected = true;
}
Localize();
if (cboRegion.Items.Count > 0)
{
cboRegion.ClearSelection();
if (string.IsNullOrEmpty(_address.RegionCode))
cboRegion.SelectedIndex = 0;
else
{
ListItem region = null;
if (_settings.RegionData.ToLower() == "text")
region = cboRegion.Items.FindByText(_address.RegionCode);
else if (_settings.RegionData.ToLower() == "value")
region = cboRegion.Items.FindByValue(_address.RegionCode);
if (region != null)
region.Selected = true;
}
}
else
txtRegion.Text = _address.RegionCode;
}
else
{
cboCountry.ClearSelection();
Localize();
}
}
private PlaceHolder DetermineConfigEditControl(string StoreName, int StoreId, AppConfig config)
{
PlaceHolder plhConfigValueEditor = new PlaceHolder();
String editorId;
Boolean isnew = (config == null);
if (isnew)
{
//return AddParameterControl(StoreName, StoreId, config);
config = AppLogic.GetAppConfigRouted(this.Datasource.Name, StoreId);
editorId = string.Format("ctrlNewConfig{0}_{1}", StoreId, this.Datasource.AppConfigID);
plhConfigValueEditor.Controls.Add(new LiteralControl("<small style=\"color:gray;\">(Unassigned for <em>{0}</em>. Currently using default.)</small><br />".FormatWith(Store.GetStoreName(StoreId))));
}
else
{
editorId = string.Format("ctrlConfigEditor{0}", config.AppConfigID);
}
if (config.ValueType.EqualsIgnoreCase("integer"))
{
TextBox txt = new TextBox();
txt.ID = editorId;
txt.Text = config.ConfigValue;
m_configvalue = txt.Text;
CompareValidator compInt = new CompareValidator();
compInt.Type = ValidationDataType.Integer;
compInt.Operator = ValidationCompareOperator.DataTypeCheck;
compInt.ControlToValidate = txt.ID;
compInt.ErrorMessage = AppLogic.GetString("admin.editquantitydiscounttable.EnterInteger", ThisCustomer.LocaleSetting);
plhConfigValueEditor.Controls.Add(txt);
plhConfigValueEditor.Controls.Add(compInt);
}
else if (config.ValueType.EqualsIgnoreCase("decimal") || config.ValueType.EqualsIgnoreCase("double"))
{
TextBox txt = new TextBox();
txt.ID = editorId;
txt.Text = config.ConfigValue;
m_configvalue = txt.Text;
FilteredTextBoxExtender extFilterNumeric = new FilteredTextBoxExtender();
extFilterNumeric.ID = DB.GetNewGUID();
extFilterNumeric.TargetControlID = editorId;
extFilterNumeric.FilterType = FilterTypes.Numbers | FilterTypes.Custom;
extFilterNumeric.ValidChars = ".";
plhConfigValueEditor.Controls.Add(txt);
plhConfigValueEditor.Controls.Add(extFilterNumeric);
}
else if (config.ValueType.EqualsIgnoreCase("boolean"))
{
bool isYes = Localization.ParseBoolean(config.ConfigValue);
RadioButtonList rbYesNo = new RadioButtonList();
rbYesNo.ID = editorId;
rbYesNo.RepeatDirection = System.Web.UI.WebControls.RepeatDirection.Horizontal;
ListItem optionYes = new ListItem("Yes");
ListItem optionNo = new ListItem("No");
if (StoreId == 0)
{
optionYes.Attributes.Add("onclick", "$(this).parents('.modal_popup_Content').find('span.defaultTrue input').each(function (index, value) {$(value).click();});");
optionNo.Attributes.Add("onclick", "$(this).parents('.modal_popup_Content').find('span.defaultFalse input').each(function (index, value) {$(value).click();});");
}
else if (isnew)
{
optionYes.Attributes.Add("class", "defaultTrue");
optionNo.Attributes.Add("class", "defaultFalse");
}
optionYes.Selected = isYes;
optionNo.Selected = !isYes;
rbYesNo.Items.Add(optionYes);
rbYesNo.Items.Add(optionNo);
m_configvalue = optionYes.Selected.ToString().ToLowerInvariant();
plhConfigValueEditor.Controls.Add(rbYesNo);
}
else if (config.ValueType.EqualsIgnoreCase("enum"))
{
DropDownList cboValues = new DropDownList();
cboValues.ID = editorId;
foreach (string value in config.AllowableValues)
{
cboValues.Items.Add(value);
}
cboValues.SelectedValue = config.ConfigValue;
m_configvalue = cboValues.SelectedValue;
plhConfigValueEditor.Controls.Add(cboValues);
}
else if (config.ValueType.EqualsIgnoreCase("invoke"))
{
DropDownList cboValues = new DropDownList();
cboValues.ID = editorId;
bool invocationSuccessful = false;
string errorMessage = string.Empty;
try
{
if (config.AllowableValues.Count == 3)
{
// format should be
// {FullyQualifiedName},MethodName
// Fully qualified name format is Namespace.TypeName,AssemblyName
string typeName = config.AllowableValues[0];
string assemblyName = config.AllowableValues[1];
string methodName = config.AllowableValues[2];
string fqName = typeName + "," + assemblyName;
Type t = Type.GetType(fqName);
object o = Activator.CreateInstance(t);
MethodInfo method = o.GetType().GetMethod(methodName, BindingFlags.Public | BindingFlags.Static);
object result = method.Invoke(o, new object[] { });
if (result is IEnumerable)
{
cboValues.DataSource = result;
cboValues.DataBind();
invocationSuccessful = true;
// now try to find which one is matching, case-insensitive
foreach (ListItem item in cboValues.Items)
{
item.Selected = item.Text.EqualsIgnoreCase(config.ConfigValue);
}
}
else
{
errorMessage = "Invocation method must return IEnumerable";
invocationSuccessful = false;
}
}
else
{
errorMessage = "Invalid invocation value";
invocationSuccessful = false;
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
invocationSuccessful = false;
}
if (invocationSuccessful == false)
{
cboValues.Items.Add(errorMessage);
}
m_configvalue = cboValues.SelectedValue;
plhConfigValueEditor.Controls.Add(cboValues);
}
else if (config.ValueType.EqualsIgnoreCase("multiselect"))
{
CheckBoxList chkValues = new CheckBoxList();
chkValues.ID = editorId;
Func <string, bool> isIncluded = (optionValue) =>
{
return(config.ConfigValue.Split(',').Any(val => val.Trim().EqualsIgnoreCase(optionValue)));
};
foreach (string optionValue in config.AllowableValues)
{
ListItem option = new ListItem(optionValue, optionValue);
option.Selected = isIncluded(optionValue);
chkValues.Items.Add(option);
}
List <string> selectedValues = new List <string>();
foreach (ListItem option in chkValues.Items)
{
if (option.Selected)
{
selectedValues.Add(option.Value);
}
}
// format the selected values into a comma delimited string
m_configvalue = selectedValues.ToCommaDelimitedString();
plhConfigValueEditor.Controls.Add(chkValues);
}
else
{
// determine length for proper control to use
string configValue = config.ConfigValue;
TextBox txt = new TextBox();
txt.ID = editorId;
txt.Text = configValue;
if (configValue.Length >= MAX_COLUMN_LENGTH)
{
// use textArea
txt.TextMode = TextBoxMode.MultiLine;
txt.Rows = 4; // make it 4 rows by default
}
txt.Columns = DetermineProperTextColumnLength(configValue);
m_configvalue = txt.Text;
plhConfigValueEditor.Controls.Add(txt);
}
return(plhConfigValueEditor);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//记录页面使用次数
DB.RecordPageUseCount("Plant_DISPACCOUNT");
date1 = "1910-01";
newdate = false;
int CurrentYear = Convert.ToInt32(DateTime.Now.Year);
int i;
for (i = CurrentYear - 5; i <= CurrentYear; i++)
{
ListItem Year = new ListItem();
Year.Text = Convert.ToString(i);
Year.Value = Convert.ToString(i);
if (i == CurrentYear)
{
Year.Selected = true;
}
else
{
Year.Selected = false;
}
ddlYear.Items.Add(Year);
//EndYear.Items.Add(Year);
}
string CurrentDate = Convert.ToString(DateTime.Now.Month);
if (CurrentDate.Length == 1)
{
CurrentDate = "0" + CurrentDate;
}
foreach (ListItem Month in ddlMonth.Items)
{
if (Month.Text == CurrentDate)
{
Month.Selected = true;
ddlMonth.Text = Month.Text;
//EndMonth.Text = Month.Text;
break;
}
else
{
Month.Selected = false;
}
}
AddDate(sender, e);
CurrentDate = Convert.ToString(DateTime.Now.Day - 1);
if (CurrentDate.Length == 1)
{
CurrentDate = "0" + CurrentDate;
}
foreach (ListItem day in ddlDay.Items)
{
if (day.Text == CurrentDate)
{
day.Selected = true;
ddlDay.Text = day.Text;
//EndDay.Text = day.Text;
break;
}
else
{
day.Selected = false;
}
}
}
else
{
date1 = ddlYear.SelectedValue.ToString() + '-' + ddlMonth.SelectedValue.ToString() + '-' + ddlDay.SelectedValue.ToString();
string strCurrentDate = date1;
OracleConnection conn = DB.createConn();
try
{
OracleDataAdapter da = new OracleDataAdapter();
if (newdate)
{
//CrystalReportViewer1.ResetReportPartNavigation();
newdate = false;
}
conn.Open();
DataSet ds = new DataSet();
//ReportDocument CRptHeatName = new ReportDocument();
string j = ddlDISPACCOUNT.SelectedValue.ToString();
if (j == "3")
{
string strSQL = "Select * from TP_REHEAT_ACCOUNT where LOGTIME='" + strCurrentDate + "' ORDER BY CCMID";
da.SelectCommand = new OracleCommand(strSQL, conn);
da.Fill(ds, "TP_REHEAT_ACCOUNT");
rdt.Load(this.Server.MapPath("").ToString() + "\\REHEATACCOUNT.rpt");
//rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer";
rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet;
rdt.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rdt;
CrystalReportViewer1.DataBind();
}
else
{
string strSQL = "Select * from TP_DISP_ACCOUNT where PRODUCTDATE='" + strCurrentDate + "'AND ACCOUNTTYPE='" + ddlDISPACCOUNT.SelectedValue + "' ORDER BY UNITID";
da.SelectCommand = new OracleCommand(strSQL, conn);
da.Fill(ds, "TP_DISP_ACCOUNT");
rdt.Load(this.Server.MapPath("").ToString() + "\\DISPACCOUNT.rpt");
//rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer";
rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet;
rdt.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rdt;
CrystalReportViewer1.DataBind();
rdt.SetParameterValue("p", ddlDISPACCOUNT.Items[ddlDISPACCOUNT.SelectedIndex].ToString() + ")");
}
ds.Dispose();
}
catch (Exception ee)
{
Response.Write(ee.ToString());//"出错");
}
finally
{
conn.Close();
}
}
}
public static void AddNewListItem(CsvRecord record, List spList, ClientContext clientContext)
{
Dictionary <string, object> itemFieldValues = new Dictionary <string, object>();
//Use reflection to iterate through the record's properties
PropertyInfo[] properties = typeof(CsvRecord).GetProperties();
foreach (PropertyInfo property in properties)
{
object propValue = property.GetValue(record, null);
if (!String.IsNullOrEmpty(propValue.ToString()))
{
Field matchingField = spList.Fields.GetByInternalNameOrTitle(property.Name);
clientContext.Load(matchingField);
clientContext.ExecuteQuery();
switch (matchingField.FieldTypeKind)
{
case FieldType.User:
FieldUserValue userFieldValue = GetUserFieldValue(propValue.ToString(), clientContext);
if (userFieldValue != null)
{
itemFieldValues.Add(matchingField.InternalName, userFieldValue);
}
else
{
throw new Exception("User field value could not be added: " + propValue.ToString());
}
break;
case FieldType.Lookup:
FieldLookupValue lookupFieldValue = GetLookupFieldValue(propValue.ToString(),
ConfigurationManager.AppSettings["LookupListName"].ToString(),
clientContext);
if (lookupFieldValue != null)
{
itemFieldValues.Add(matchingField.InternalName, lookupFieldValue);
}
else
{
throw new Exception("Lookup field value could not be added: " + propValue.ToString());
}
break;
case FieldType.Invalid:
switch (matchingField.TypeAsString)
{
default:
//Code for publishing site columns not implemented
continue;
}
default:
itemFieldValues.Add(matchingField.InternalName, propValue);
break;
}
}
}
//Add new item to list
ListItemCreationInformation creationInfo = new ListItemCreationInformation();
ListItem oListItem = spList.AddItem(creationInfo);
foreach (KeyValuePair <string, object> itemFieldValue in itemFieldValues)
{
//Set each field value
oListItem[itemFieldValue.Key] = itemFieldValue.Value;
}
//Persist changes
oListItem.Update();
clientContext.ExecuteQuery();
}
protected void Page_Load(object sender, EventArgs e)
{
if (EditedObject == null)
{
RedirectToAccessDenied(GetString("general.invalidparameters"));
}
Save += btnOK_Click;
var user = MembershipContext.AuthenticatedUser;
// Check permissions for Forms application
if (!user.IsAuthorizedPerUIElement("cms.form", "Form"))
{
RedirectToUIElementAccessDenied("cms.form", "Form");
}
// Check 'ReadData' permission
if (!user.IsAuthorizedPerResource("cms.form", "ReadData", SiteInfoProvider.GetSiteName(FormInfo.FormSiteID)))
{
RedirectToAccessDenied("cms.form", "ReadData");
}
// Check authorized roles for this form
if (!FormInfo.IsFormAllowedForUser(MembershipContext.AuthenticatedUser.UserName, SiteContext.CurrentSiteName))
{
RedirectToAccessDenied(GetString("Bizforms.FormNotAllowedForUserRoles"));
}
List <String> columnNames = null;
DataClassInfo dci = null;
Hashtable reportFields = new Hashtable();
FormInfo fi = null;
// Initialize controls
PageTitle.TitleText = GetString("BizForm_Edit_Data_SelectFields.Title");
CurrentMaster.DisplayActionsPanel = true;
HeaderActions.AddAction(new HeaderAction
{
Text = GetString("UniSelector.SelectAll"),
OnClientClick = "ChangeFields(true); return false;",
ButtonStyle = ButtonStyle.Default,
});
HeaderActions.AddAction(new HeaderAction
{
Text = GetString("UniSelector.DeselectAll"),
OnClientClick = "ChangeFields(false); return false;",
ButtonStyle = ButtonStyle.Default,
});
if (!RequestHelper.IsPostBack())
{
if (FormInfo != null)
{
// Get dataclass info
dci = DataClassInfoProvider.GetDataClassInfo(FormInfo.FormClassID);
if (dci != null)
{
// Get columns names
fi = FormHelper.GetFormInfo(dci.ClassName, false);
columnNames = fi.GetColumnNames(false, i => i.System);
}
// Get report fields
if (String.IsNullOrEmpty(FormInfo.FormReportFields))
{
reportFields = LoadReportFields(columnNames);
}
else
{
reportFields.Clear();
foreach (string field in FormInfo.FormReportFields.Split(';'))
{
// Add field key to hastable
reportFields[field] = null;
}
}
if (columnNames != null)
{
FormFieldInfo ffi = null;
ListItem item = null;
MacroResolver resolver = MacroResolverStorage.GetRegisteredResolver(FormHelper.FORM_PREFIX + FormInfo.ClassName);
foreach (string name in columnNames)
{
ffi = fi.GetFormField(name);
// Add checkboxes to the list
item = new ListItem(HTMLHelper.HTMLEncode(ResHelper.LocalizeString(GetFieldCaption(ffi, name, resolver))), name);
if (reportFields.Contains(name))
{
// Select checkbox if field is reported
item.Selected = true;
}
chkListFields.Items.Add(item);
}
}
}
}
}
private void renderTest(List <Question> inputList)
{
testContent.Controls.Clear();
foreach (Question q in inputList)
{
HtmlGenericControl div = new HtmlGenericControl("div");
div.Attributes.Add("ID", q.id.ToString());
Label activeCategory = new Label();
Label activeQuestion = new Label();
string catequest;
if (q.category == 1)
{
catequest = "Produkter och hantering av kundens affärer. ";
}
else if (q.category == 2)
{
catequest = "Ekonomi. ";
}
else
{
catequest = "Etik och regelverk. ";
}
activeCategory.Text = catequest;
activeQuestion.Text = q.question;
div.Controls.Add(activeCategory);
div.Controls.Add(activeQuestion);
testContent.Controls.Add(div);
//Get radiobuttons if there is only one correct answer
if (q.answerList.FindAll(x => x.correct == true).ToList().Count == 1)
{
RadioButtonList rbList = new RadioButtonList();
rbList.ID = q.id.ToString();
foreach (var answer in q.answerList)
{
ListItem li = new ListItem();
if (answer.text.IndexOf(".jpg") > 0)
{
Image newImg = new Image();
newImg.ImageUrl = answer.text;
li.Value = answer.id;
li.Text = "<img src='" + newImg.ImageUrl + "'>";
rbList.Items.Add(li);
div.Controls.Add(rbList);
div.Controls.Add(newImg);
}
else
{
li.Text = answer.text;
li.Value = answer.id;
rbList.Items.Add(li);
div.Controls.Add(rbList);
}
}
}
//Get checkbuttons if there is more than one correct answer
else
{
CheckBoxList cbList = new CheckBoxList();
cbList.ID = q.id.ToString();
foreach (var answer in q.answerList)
{
ListItem li = new ListItem();
if (answer.text.IndexOf(".jpg") > 0)
{
Image newImg = new Image();
newImg.ImageUrl = answer.text;
li.Value = answer.id;
li.Text = "<img src='" + newImg.ImageUrl + "'>";
cbList.Items.Add(li);
div.Controls.Add(cbList);
}
else
{
li.Text = answer.text;
li.Value = answer.id;
cbList.Items.Add(li);
div.Controls.Add(cbList);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["edit_message"] != null)
{
Response.Write(Session["edit_message"]);
Session["edit_message"] = null;
}
string connString = ConfigurationManager.ConnectionStrings["iWorkDBConn"].ToString();
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("View_prev_job_titles_of_Manager", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@user", Session["username"]));
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
int counter = 0;
while (rdr.Read())
{
ListItem listItem = new ListItem();
listItem.Text = rdr.GetValue(rdr.GetOrdinal("job_title")).ToString();
previous_jobtitles_ddl.Items.Add(listItem);
counter++;
}
conn.Close();
Label passwordLabel = new Label(); passwordLabel.Text = "New Password: "******"New First Name: ";
Label middlenameLabel = new Label(); middlenameLabel.Text = "New Middle Name: ";
Label lastnameLabel = new Label(); lastnameLabel.Text = "New Last Name: ";
Label birthdateLabel = new Label(); birthdateLabel.Text = "New Birthdate: ";
Label emailLabel = new Label(); emailLabel.Text = "New Email: ";
Label yearsLabel = new Label(); yearsLabel.Text = "New Years of Experience: ";
passwordLabel.CssClass = "labels";
firstnameLabel.CssClass = "labels";
middlenameLabel.CssClass = "labels";
lastnameLabel.CssClass = "labels";
birthdateLabel.CssClass = "labels";
emailLabel.CssClass = "labels";
yearsLabel.CssClass = "labels";
Button submit_update_button = new Button();
submit_update_button.Text = "Update Personal Info";
submit_update_button.Click += new EventHandler(update_personal_info);
Button add_jobtitle_button = new Button();
add_jobtitle_button.Text = "Add a New Title";
add_jobtitle_button.Click += new EventHandler(add_new_title);
Button delete_jobtitle_button = new Button();
delete_jobtitle_button.Text = "Delete Selected Title";
delete_jobtitle_button.Click += new EventHandler(delete_title);
edit_form.Controls.Add(new Literal {
Text = "<H2>Update your personal information, " + Session["username"].ToString() + ".</H2>"
});
edit_form.Controls.Add(passwordLabel); edit_form.Controls.Add(password_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(firstnameLabel); edit_form.Controls.Add(first_name_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(middlenameLabel); edit_form.Controls.Add(middle_name_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(lastnameLabel); edit_form.Controls.Add(last_name_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(birthdateLabel); edit_form.Controls.Add(birthdate_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(emailLabel); edit_form.Controls.Add(email_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(yearsLabel); edit_form.Controls.Add(years_of_experience_textbox);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
edit_form.Controls.Add(submit_update_button);
edit_form.Controls.Add(new Literal {
Text = "<H3>Edit Previous Job Titles: </H3>"
});
edit_form.Controls.Add(add_new_jobtitle_textbox); edit_form.Controls.Add(add_jobtitle_button);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
if (counter > 0)
{
edit_form.Controls.Add(previous_jobtitles_ddl); edit_form.Controls.Add(delete_jobtitle_button);
edit_form.Controls.Add(new Literal {
Text = "<br/>"
});
}
else
{
edit_form.Controls.Add(new Literal {
Text = "You have entered zero previous job titles so far.<br/>"
});
}
}
protected void btnTestSurvey_Click(object sender, EventArgs e)
{
ListItem li = ddlSurveys.SelectedItem;
Response.Redirect("TestSurvey.aspx?SurveyID=" + li.Value.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
// return to test start on refresh
if (Page.IsPostBack && _isRefresh)
{
Response.Redirect(Request.RawUrl);
}
// do not update answers/questions on partial async postback (timer tick)
if (Page.IsPostBack && ScriptManager.GetCurrent(this.Page).IsInAsyncPostBack)
{
return;
}
string var_id = Request.QueryString["id"];
//manage page content
if (var_id != null)
{
TestsList_Form.Visible = false;
if (var_id == "new")
{
//display new test UI
if (Session["teacher"] == null)
{
Response.Redirect("~/Content/Tests.aspx");
}
if (!Page.IsPostBack)
{
GenerateEmptyGridView();
}
TestsList.Visible = false;
NewTest_Form.Visible = true;
}
else // display test
{
string SQL_SELECT = "SELECT * FROM " + TestsDB + " WHERE TestID=" + Request.QueryString["id"];
SqlCommand CMD_SELECT = new SqlCommand(SQL_SELECT, DB_Connection);
CMD_SELECT.CommandType = CommandType.Text;
int TestID = 0;
int QuestionsLimit = 0;
int ChancesLimit = 0;
int ChancesUsed = 0;
int TimeLimit = 0;
bool IsFree = false;
List <int> Questions = new List <int>();
DB_Connection.Open();
using (SqlDataReader Reader = CMD_SELECT.ExecuteReader())
{
if (Reader.Read())
{
DisplayTest_Title.Text = Reader["Title"].ToString();
TestID = int.Parse(Reader["TestID"].ToString());
QuestionsLimit = int.Parse(Reader["QuestionsLimit"].ToString());
ChancesLimit = int.Parse(Reader["ChancesLimit"].ToString());
TimeLimit = int.Parse(Reader["TimeLimit"].ToString());
IsFree = Convert.ToBoolean(Reader["IsFreeTest"]);
if (!IsFree && Session["student"] == null && Session["teacher"] == null)
{
Response.Redirect("~/Content/Tests.aspx");
}
}
}
if (ViewState["CurrentQuestion"] == null)
{
string SQL_SELECT_2 = "SELECT * FROM " + TestQuestionsDB + " WHERE TestID=" + TestID;
SqlCommand CMD_SELECT_2 = new SqlCommand(SQL_SELECT_2, DB_Connection);
CMD_SELECT_2.CommandType = CommandType.Text;
//make list of question IDs
using (SqlDataReader Reader = CMD_SELECT_2.ExecuteReader())
{
while (Reader.Read())
{
Questions.Add(int.Parse(Reader["QuestionID"].ToString()));
}
}
int[] Questions_Array = new int[QuestionsLimit];
// shuffle questions
for (int i = 0; i < QuestionsLimit; ++i)
{
int q = Questions[new Random().Next(Questions.Count)];
if (Array.IndexOf(Questions_Array, q) < 0)
{
Questions_Array[i] = q;
}
else
{
--i;
}
}
// display test info
if (Session["student"] != null || Session["teacher"] != null)
{
string SQL_SELECT_3 = "SELECT count(*) FROM " + MarksDB + " WHERE Username='******' AND TestID=" + TestID;
SqlCommand CMD_SELECT_3 = new SqlCommand(SQL_SELECT_3, DB_Connection);
CMD_SELECT_3.CommandType = CommandType.Text;
ChancesUsed = int.Parse(CMD_SELECT_3.ExecuteScalar().ToString());
TestInfo_UserInfo.Text = Session["SurName"].ToString();
}
int QuestionTimer = (TimeLimit * 60) / QuestionsLimit;
TestInfo_QuestionsLimit.Text = Questions_Array.Length.ToString();
TestInfo_TimeLimit.Text = TimeLimit == 0 ? "Необмежено" : TimeLimit + " хв.";
TestInfo_TimePerQuestionLimit.Text = TimeLimit == 0 ? "Необмежено" : QuestionTimer.ToString() + " сек.";
TestInfo_TimesPassed.Text = ChancesLimit == 0 ? "Необмежено" : ChancesUsed.ToString() + " / " + ChancesLimit.ToString();
int j = new Random().Next(Questions_Array.Length);
ViewState["CurrentQuestion"] = Questions_Array[j];
ViewState["Questions"] = Questions_Array;
ViewState["QuestionTimer"] = QuestionTimer;
ViewState["TestTimer"] = TimeLimit * 60;
// no chances left
if (ChancesUsed >= ChancesLimit && ChancesLimit != 0)
{
TestInfo_TimesPassed.ForeColor = System.Drawing.Color.Red;
next_question.Enabled = false;
}
DisplayTest_InfoForm.Visible = true;
}
else
{
// save answer
if (ViewState["Answers"] != null && ViewState["PassedQuestions"] != null)
{
int[] answers = ViewState["Answers"] as int[];
int[] answers_new = new int[answers.Length + 1];
for (int i = 0; i < answers.Length; ++i)
{
answers_new[i] = answers[i];
}
answers_new[answers_new.Length - 1] = int.Parse(DisplayTest_ChoicesList.SelectedValue);
ViewState["Answers"] = answers_new;
}
else
{
if (DisplayTest_ChoicesList.SelectedIndex >= 0)
{
int[] answers = new int[1] {
int.Parse(DisplayTest_ChoicesList.SelectedValue)
};
ViewState["Answers"] = answers;
}
}
//show result if finished test
if (ViewState["Answers"] != null && ViewState["Questions"] != null && (ViewState["Answers"] as int[]).Length == (ViewState["Questions"] as int[]).Length)
{
DisplayTest_TimerPeriodic.Enabled = false;
int[] answers = ViewState["Answers"] as int[];
int correct = 0;
int Mark = 0;
for (int i = 0; i < answers.Length; ++i)
{
string SQL_SELECT_2 = "SELECT IsCorrect FROM " + TestAnswersDB + " WHERE ChoiceID=" + answers[i];
SqlCommand CMD_SELECT_2 = new SqlCommand(SQL_SELECT_2, DB_Connection);
CMD_SELECT_2.CommandType = CommandType.Text;
using (SqlDataReader Reader = CMD_SELECT_2.ExecuteReader())
{
if (Reader.Read() && Convert.ToBoolean(Reader["IsCorrect"]))
{
++correct;
}
}
}
float Points = (float)100 / answers.Length * correct;
Mark = (int)Points;
// save to DB if not free and if student logged in
if (!IsFree && Session["student"] != null)
{
string SQL_SelectGroupID = "(SELECT GroupID FROM " + UsersDB + " WHERE Username='******')";
string SQL_INSERT = "INSERT INTO " + MarksDB + " VALUES('" + Session["student"].ToString() + "', " + TestID + ", " + Mark + ", '" + DateTime.Now.ToString() + "', " + SQL_SelectGroupID + ")";
SqlCommand CMD_INSERT = new SqlCommand(SQL_INSERT, DB_Connection);
CMD_INSERT.CommandType = CommandType.Text;
CMD_INSERT.ExecuteNonQuery();
}
DB_Connection.Close();
DisplayTest_Result.Text = "Кількість правильних відповідей " + correct + " з " + answers.Length + " запитань. Ви набрали " + Mark + " балів.";
DisplayTest_QuestionForm.Visible = false;
DisplayTest_ResultForm.Visible = true;
next_question.Visible = false;
return;
}
// display (next) question
// update timer
if (ViewState["TestTimer"] != null && ViewState["Questions"] != null)
{
DisplayTest_TimeLeft.ForeColor = System.Drawing.Color.LightGreen;
DisplayTest_TimeLeft.Text = "Залишилось часу: " + ViewState["QuestionTimer"].ToString() + " сек.";
Timer1.Enabled = false;
}
// show question
int CurrentQuestion = int.Parse(ViewState["CurrentQuestion"].ToString());
string SQL_SELECT_3 = "SELECT QuestionText FROM " + TestQuestionsDB + " WHERE QuestionID=" + CurrentQuestion;
SqlCommand CMD_SELECT_3 = new SqlCommand(SQL_SELECT_3, DB_Connection);
CMD_SELECT_3.CommandType = CommandType.Text;
string SQL_SELECT_4 = "SELECT * FROM " + TestAnswersDB + " WHERE QuestionID=" + CurrentQuestion;
SqlCommand CMD_SELECT_4 = new SqlCommand(SQL_SELECT_4, DB_Connection);
CMD_SELECT_4.CommandType = CommandType.Text;
using (SqlDataReader Reader = CMD_SELECT_3.ExecuteReader())
{
int PassedQuestions = ViewState["PassedQuestions"] != null ? (ViewState["PassedQuestions"] as int[]).Length + 1 : 1;
string QuestionIndex = "<b>" + PassedQuestions + "/" + QuestionsLimit + " </b>";
if (Reader.Read())
{
DisplayTest_QuestionText.Text = QuestionIndex + Reader["QuestionText"].ToString() + "<br />";
}
}
using (SqlDataReader Reader = CMD_SELECT_4.ExecuteReader())
{
DisplayTest_ChoicesList.Items.Clear();
//fill list of choices
while (Reader.Read())
{
ListItem item = new ListItem();
item.Value = Reader["ChoiceID"].ToString();
item.Text = Reader["ChoiceText"].ToString();
DisplayTest_ChoicesList.Items.Add(item);
}
//shuffle choices
for (int i = 0; i < DisplayTest_ChoicesList.Items.Count; ++i)
{
int r = new Random().Next(DisplayTest_ChoicesList.Items.Count);
ListItem temp = DisplayTest_ChoicesList.Items[i];
DisplayTest_ChoicesList.Items.Remove(temp);
DisplayTest_ChoicesList.Items.Insert(r, temp);
}
//add default selection
ListItem item0 = new ListItem();
item0.Text = "<b>жоден із варіантів</b>";
item0.Value = "0";
item0.Selected = true;
DisplayTest_ChoicesList.Items.Add(item0);
}
}
TestsList.Visible = false;
DisplayTest_QuestionForm.Visible = true;
DisplayTest_Form.Visible = true;
DB_Connection.Close();
}
}
else
{
// display list of tests
if (Session["teacher"] == null)
{
TestsList.Columns[5].Visible = false;
TestsList.ShowFooter = false;
}
string SQL_SELECT = "SELECT * FROM " + TestsDB + " WHERE IsFreeTest=1";
// display full list of tests only for logged in users
if (Session["student"] != null || Session["teacher"] != null)
{
SQL_SELECT = "SELECT * FROM " + TestsDB + " ORDER BY IsFreeTest DESC";
}
SqlDataAdapter da = new SqlDataAdapter(SQL_SELECT, DB_Connection);
DataTable dt = new DataTable();
DB_Connection.Open();
da.Fill(dt);
TestsList.DataSource = dt;
TestsList.DataBind();
DB_Connection.Close();
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("siteId");
_channelId = AuthRequest.IsQueryExists("channelId") ? AuthRequest.GetQueryInt("channelId") : SiteId;
_isCheckOnly = AuthRequest.GetQueryBool("isCheckOnly");
_isTrashOnly = AuthRequest.GetQueryBool("isTrashOnly");
_isWritingOnly = AuthRequest.GetQueryBool("isWritingOnly");
_isAdminOnly = AuthRequest.GetQueryBool("isAdminOnly");
_channelInfo = ChannelManager.GetChannelInfo(SiteId, _channelId);
var tableName = ChannelManager.GetTableName(SiteInfo, _channelInfo);
_styleInfoList = TableStyleManager.GetContentStyleInfoList(SiteInfo, _channelInfo);
_attributesOfDisplay = TranslateUtils.StringCollectionToStringCollection(ChannelManager.GetContentAttributesOfDisplay(SiteId, _channelId));
_allStyleInfoList = ContentUtility.GetAllTableStyleInfoList(_styleInfoList);
_pluginIds = PluginContentManager.GetContentPluginIds(_channelInfo);
_pluginColumns = PluginContentManager.GetContentColumns(_pluginIds);
_isEdit = TextUtility.IsEdit(SiteInfo, _channelId, AuthRequest.AdminPermissionsImpl);
var state = AuthRequest.IsQueryExists("state") ? AuthRequest.GetQueryInt("state") : CheckManager.LevelInt.All;
var searchType = AuthRequest.IsQueryExists("searchType") ? AuthRequest.GetQueryString("searchType") : ContentAttribute.Title;
var dateFrom = AuthRequest.IsQueryExists("dateFrom") ? AuthRequest.GetQueryString("dateFrom") : string.Empty;
var dateTo = AuthRequest.IsQueryExists("dateTo") ? AuthRequest.GetQueryString("dateTo") : string.Empty;
var keyword = AuthRequest.IsQueryExists("keyword") ? AuthRequest.GetQueryString("keyword") : string.Empty;
var checkedLevel = 5;
var isChecked = true;
foreach (var owningChannelId in AuthRequest.AdminPermissionsImpl.ChannelIdList)
{
int checkedLevelByChannelId;
var isCheckedByChannelId = CheckManager.GetUserCheckLevel(AuthRequest.AdminPermissionsImpl, SiteInfo, owningChannelId, out checkedLevelByChannelId);
if (checkedLevel > checkedLevelByChannelId)
{
checkedLevel = checkedLevelByChannelId;
}
if (!isCheckedByChannelId)
{
isChecked = false;
}
}
RptContents.ItemDataBound += RptContents_ItemDataBound;
var allAttributeNameList = TableColumnManager.GetTableColumnNameList(tableName, DataType.Text);
var onlyAdminId = _isAdminOnly
? AuthRequest.AdminId
: AuthRequest.AdminPermissionsImpl.GetOnlyAdminId(SiteInfo.Id, _channelInfo.Id);
var whereString = DataProvider.ContentDao.GetPagerWhereSqlString(SiteInfo, _channelInfo,
searchType, keyword,
dateFrom, dateTo, state, _isCheckOnly, false, _isTrashOnly, _isWritingOnly, onlyAdminId,
AuthRequest.AdminPermissionsImpl,
allAttributeNameList);
PgContents.Param = new PagerParam
{
ControlToPaginate = RptContents,
TableName = tableName,
PageSize = SiteInfo.Additional.PageSize,
Page = AuthRequest.GetQueryInt(Pager.QueryNamePage, 1),
OrderSqlString = ETaxisTypeUtils.GetContentOrderByString(ETaxisType.OrderByIdDesc),
ReturnColumnNames = TranslateUtils.ObjectCollectionToString(allAttributeNameList),
WhereSqlString = whereString,
TotalCount = DataProvider.DatabaseDao.GetPageTotalCount(tableName, whereString)
};
if (IsPostBack)
{
return;
}
if (_isTrashOnly)
{
if (AuthRequest.IsQueryExists("IsDeleteAll"))
{
//DataProvider.ContentDao.DeleteContentsByTrash(SiteId, _channelId, tableName);
var list = DataProvider.ContentDao.GetContentIdListByTrash(SiteId, tableName);
foreach (var(contentChannelId, contentId) in list)
{
ContentUtility.Delete(tableName, SiteInfo, contentChannelId, contentId);
}
AuthRequest.AddSiteLog(SiteId, "清空回收站");
SuccessMessage("成功清空回收站!");
}
else if (AuthRequest.IsQueryExists("IsRestore"))
{
var idsDictionary = ContentUtility.GetIDsDictionary(Request.QueryString);
foreach (var channelId in idsDictionary.Keys)
{
var contentIdList = idsDictionary[channelId];
DataProvider.ContentDao.UpdateTrashContents(SiteId, channelId, ChannelManager.GetTableName(SiteInfo, channelId), contentIdList);
}
AuthRequest.AddSiteLog(SiteId, "从回收站还原内容");
SuccessMessage("成功还原内容!");
}
else if (AuthRequest.IsQueryExists("IsRestoreAll"))
{
DataProvider.ContentDao.UpdateRestoreContentsByTrash(SiteId, _channelId, tableName);
AuthRequest.AddSiteLog(SiteId, "从回收站还原所有内容");
SuccessMessage("成功还原所有内容!");
}
}
ChannelManager.AddListItems(DdlChannelId.Items, SiteInfo, true, true, AuthRequest.AdminPermissionsImpl);
if (_isCheckOnly)
{
CheckManager.LoadContentLevelToCheck(DdlState, SiteInfo, isChecked, checkedLevel);
}
else
{
CheckManager.LoadContentLevelToList(DdlState, SiteInfo, _isCheckOnly, isChecked, checkedLevel);
}
ControlUtils.SelectSingleItem(DdlState, state.ToString());
foreach (var styleInfo in _allStyleInfoList)
{
if (styleInfo.InputType == InputType.TextEditor)
{
continue;
}
var listitem = new ListItem(styleInfo.DisplayName, styleInfo.AttributeName);
DdlSearchType.Items.Add(listitem);
}
//ETriStateUtils.AddListItems(DdlState, "全部", "已审核", "待审核");
if (SiteId != _channelId)
{
ControlUtils.SelectSingleItem(DdlChannelId, _channelId.ToString());
}
//ControlUtils.SelectSingleItem(DdlState, AuthRequest.GetQueryString("State"));
ControlUtils.SelectSingleItem(DdlSearchType, searchType);
TbKeyword.Text = keyword;
TbDateFrom.Text = dateFrom;
TbDateTo.Text = dateTo;
PgContents.DataBind();
LtlColumnsHead.Text += TextUtility.GetColumnsHeadHtml(_styleInfoList, _pluginColumns, _attributesOfDisplay);
BtnSelect.Attributes.Add("onclick", ModalSelectColumns.GetOpenWindowString(SiteId, _channelId));
if (_isTrashOnly)
{
LtlColumnsHead.Text += @"<th class=""text-center text-nowrap"" width=""150"">删除时间</th>";
BtnAddToGroup.Visible = BtnTranslate.Visible = BtnCheck.Visible = false;
PhTrash.Visible = true;
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentDelete))
{
BtnDelete.Visible = false;
BtnDeleteAll.Visible = false;
}
else
{
BtnDelete.Attributes.Add("onclick", PageContentDelete.GetRedirectClickStringForMultiChannels(SiteId, true, PageUrl));
BtnDeleteAll.Attributes.Add("onclick", PageUtils.GetRedirectStringWithConfirm(PageUtils.AddQueryString(PageUrl, "IsDeleteAll", "True"), "确实要清空回收站吗?"));
}
BtnRestore.Attributes.Add("onclick", PageUtils.GetRedirectStringWithCheckBoxValue(PageUtils.AddQueryString(PageUrl, "IsRestore", "True"), "IDsCollection", "IDsCollection", "请选择需要还原的内容！"));
BtnRestoreAll.Attributes.Add("onclick", PageUtils.GetRedirectStringWithConfirm(PageUtils.AddQueryString(PageUrl, "IsRestoreAll", "True"), "确实要还原所有内容吗?"));
}
else
{
LtlColumnsHead.Text += @"<th class=""text-center text-nowrap"" width=""100"">操作</th>";
BtnAddToGroup.Attributes.Add("onclick", ModalAddToGroup.GetOpenWindowStringToContentForMultiChannels(SiteId));
if (HasChannelPermissions(SiteId, ConfigManager.ChannelPermissions.ContentCheck))
{
BtnCheck.Attributes.Add("onclick", ModalContentCheck.GetOpenWindowStringForMultiChannels(SiteId, PageUrl));
if (_isCheckOnly)
{
BtnCheck.CssClass = "btn m-r-5 btn-success";
}
}
else
{
PhCheck.Visible = false;
}
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentTranslate))
{
BtnTranslate.Visible = false;
}
else
{
BtnTranslate.Attributes.Add("onclick", PageContentTranslate.GetRedirectClickStringForMultiChannels(SiteId, PageUrl));
}
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentDelete))
{
BtnDelete.Visible = false;
}
else
{
BtnDelete.Attributes.Add("onclick", PageContentDelete.GetRedirectClickStringForMultiChannels(SiteId, false, PageUrl));
}
}
}
private void BindGrdApplicationsPersons()
{
GrdApplicationsPersons.DataSource = null;
GrdApplicationsPersons.DataBind();
PnlSearch.BindControls(FilterDictionary, _TableName);
FilterDictionary = new Dictionary <string, object>()
{
{ "OrganizationsID", int.Parse(DListFltOrganizations.SelectedValue) },
{ "ID", TxtFltPersonID.Text },
{ "ApplicationsID", TxtFltApplicationsID.Text },
{ "ApplicationsTypesID", int.Parse(DListFltApplicationsTypes.SelectedValue) },
{ "ApplicationsPersonsTypesID", int.Parse(DListFltApplicationsPersonsType.SelectedValue) },
{ "DocumentTypesID", int.Parse(DListFltDocumentTypes.SelectedValue) },
{ "DocumentNumber", TxtFltDocumentNumber.Text },
{ "Surname(LIKE)", TxtFltSurname.Text },
{ "Name(LIKE)", TxtFltName.Text },
{ "Patronymic(LIKE)", TxtFltPatronymic.Text },
{ "SocialStatusID", int.Parse(DListFltSocialStatusID.SelectedValue) },
{ "RegisteredAddress(LIKE)", TxtFilterRegisteredAddress.Text },
{ "CurrentAddress(LIKE)", TxtFilterCurrentAddress.Text },
{ "Add_Dt(Between)", Config.DateTimeFilter(TxtFilterDate1.Text, TxtFilterDate2.Text) },
};
if (PnlOperations.Visible == true)
{
//Əməliyyatlar multi secim oldugu ucun onun axtarish algoritmasini elave olaraq burda yazdim
for (int i = 0; i < DListFltListOperationTypes.Items.Count; i++)
{
ListItem Item = DListFltListOperationTypes.Items[i];
if (Item.Selected == true)
{
FilterDictionary.Add(((Tools.ListOperationTypes) int.Parse(Item.Value)).ToDescriptionString() + "(OR)", "IS NOT NULL");
}
}
}
else
{
switch (Config._GetQueryString("type"))
{
case "sibr-evaluations":
FilterDictionary.Add("SIBRID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "SIB-R Qiymətləndirilənlər";
break;
case "evaluations":
FilterDictionary.Add("EvaluationsID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "Qiymətləndirilənlər";
break;
case "evaluationsskill":
FilterDictionary.Add("EvaluationsSkillID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "Qiymətləndirilənlər";
break;
case "services":
FilterDictionary.Add("ApplicationsPersonsServicesID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "Xidmətlərdən istifadə edənlər";
break;
case "case":
FilterDictionary.Add("ApplicationsCaseID", "IS NOT NULL");
((Literal)Master.FindControl("LtrTitle")).Text = "CASE açılanlar";
break;
default:
break;
}
}
int PageNum;
int RowNumber = 20;
if (!int.TryParse(Config._GetQueryString("p"), out PageNum))
{
PageNum = 1;
}
HdnPageNumber.Value = PageNum.ToString();
DALC.DataTableResult FilterList = DALC.GetFilterList(_TableName, FilterDictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/applicationspersons/?p={0}", PageNum - 1));
}
LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", FilterList.Count);
int Total_Count = 0;
if (FilterList.Count % RowNumber > 0)
{
Total_Count = (FilterList.Count / RowNumber) + 1;
}
else
{
Total_Count = FilterList.Count / RowNumber;
}
HdnTotalCount.Value = Total_Count.ToString();
PnlPager.Visible = FilterList.Count > RowNumber;
GrdApplicationsPersons.DataSource = FilterList.Dt;
GrdApplicationsPersons.DataBind();
}
private void loadEnterpriseFields()
{
Guid siteGuid = SPContext.Current.Site.ID;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = SPContext.Current.Site)
{
try
{
WebSvcCustomFields.CustomFields cf = new WebSvcCustomFields.CustomFields();
cf.Url = SPContext.Current.Site.Url + "/_vti_bin/PSI/customfields.asmx";
cf.UseDefaultCredentials = true;
WebSvcCustomFields.CustomFieldDataSet dsF = cf.ReadCustomFieldsByEntity(new Guid(PSLibrary.EntityCollection.Entities.TaskEntity.UniqueId));
ddlAssignedToField.Items.Add(new ListItem("[Not Specified]", ""));
ddlTimesheet.Items.Add(new ListItem("[Select Field]", ""));
ddlTimesheetHours.Items.Add(new ListItem("[Select Field]", ""));
foreach (DataRow dr in dsF.Tables[0].Select("MD_PROP_TYPE_ENUM = 21"))
{
ListItem li = new ListItem(dr["MD_PROP_NAME"].ToString(), dr["MD_PROP_UID"].ToString());
ddlAssignedToField.Items.Add(li);
}
foreach (DataRow dr in dsF.Tables[0].Select("MD_PROP_TYPE_ENUM = 15"))
{
ListItem li = new ListItem(dr["MD_PROP_NAME"].ToString(), dr["MD_PROP_ID"].ToString());
ddlTimesheetHours.Items.Add(li);
}
foreach (DataRow dr in dsF.Tables[0].Select("MD_PROP_TYPE_ENUM = 17"))
{
ListItem li = new ListItem(dr["MD_PROP_NAME"].ToString(), dr["MD_PROP_UID"].ToString());
ddlTimesheet.Items.Add(li);
}
ddlTimesheetHours.Items.Add(new ListItem("Actual Work", "251658250"));
using (var connection = new SqlConnection(CoreFunctions.getConnectionString(site.WebApplication.Id)))
{
connection.Open();
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='AssignedToField'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
ddlAssignedToField.SelectedValue = reader.GetString(0);
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='TimesheetField'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
ddlTimesheet.SelectedValue = reader.GetString(0);
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='TimesheetHoursField'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
ddlTimesheetHours.SelectedValue = reader.GetString(0);
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='LockSynch'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
chkLockSynch.Checked = bool.Parse(reader.GetString(0));
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='ForceWS'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
chkForceWS.Checked = bool.Parse(reader.GetString(0));
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='ValidTemplates'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
loadTemplates(reader.GetString(0));
}
else
{
loadTemplates(string.Empty);
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='CrossSite'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
chkCrossSite.Checked = bool.Parse(reader.GetString(0));
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='DefaultURL'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
txtDefaultURL.Text = reader.GetString(0);
}
}
using (var command = new SqlCommand("SELECT config_value FROM ECONFIG where config_name='ConnectedURLs'", connection))
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
txtUrls.Text = reader.GetString(0);
}
}
}
lblError.Visible = false;
WebSvcEvents.Events events = new EPMLiveEnterprise.WebSvcEvents.Events();
events.Url = SPContext.Current.Site.Url + "/_vti_bin/psi/events.asmx";
events.UseDefaultCredentials = true;
WebSvcEvents.EventHandlersDataSet ds = events.ReadEventHandlerAssociations();
if (ds.EventHandlers.Select("EventId = 53 and name = 'EPMLivePublisher'").Length <= 0)
{
lblProjectPublished.Text = "Not Installed";
}
else
{
lblProjectPublished.Text = "Installed";
}
if (ds.EventHandlers.Select("EventId = 133 and name = 'EPMLiveStatusing'").Length <= 0)
{
lblStatusingApplied.Text = "Not Installed";
}
else
{
lblStatusingApplied.Text = "Installed";
}
if (ds.EventHandlers.Select("EventId = 95 and name = 'EPMLiveResUpdated'").Length <= 0)
{
lblResUpdated.Text = "Not Installed";
}
else
{
lblResUpdated.Text = "Installed";
}
if (ds.EventHandlers.Select("EventId = 89 and name = 'EPMLiveResCreated'").Length <= 0)
{
lblResCreated.Text = "Not Installed";
}
else
{
lblResCreated.Text = "Installed";
}
if (ds.EventHandlers.Select("EventId = 92 and name = 'EPMLiveResDeleting'").Length <= 0)
{
lblResDeleted.Text = "Not Installed";
}
else
{
lblResDeleted.Text = "Installed";
}
}
catch (Exception ex)
{
if (ex.Message.Contains("401"))
{
lblError.Text = "Error: 401 Unauthorized<br>This usually means the service account that is current running your SharePoint Application Pool does not have access to the Project Server Site.";
lblError.Visible = true;
}
else
{
Response.Write("Error: " + ex.Message + "<br>Current User: " + HttpContext.Current.User.Identity.Name);
}
}
}
});
}
protected void Page_Load(object sender, EventArgs e)
{
this.TxtImageText.Columns = DataConverter.CLng(base.Settings[0]);
this.m_ShowUploadFilePath = base.BasePath;
this.m_ShowUploadFilePath = this.Page.Request.Url.Scheme + "://" + this.Page.Request.Url.Authority + this.m_ShowUploadFilePath;
if (base.IsAdminManage || PEContext.Current.User.Identity.IsAuthenticated)
{
if (base.IsAdminManage)
{
this.m_ShowUploadFilePath = this.m_ShowUploadFilePath + SiteConfig.SiteOption.ManageDir;
}
else
{
this.m_ShowUploadFilePath = this.m_ShowUploadFilePath + "User";
}
this.m_JSPrefix = this.ClientID.Replace("$", "").Replace("_", "");
this.m_FieldName = base.FieldName;
if (DataConverter.CBoolean(base.Settings[3]) && base.IsAdminManage)
{
this.LblIsFromSelected.Text = "<input type=\"button\" class=\"button\" value=\"从已上传文件中选择\" onclick=\"" + this.m_JSPrefix + "SelectFiles();\" /><br />";
}
StringBuilder builder = new StringBuilder();
if ((base.Settings.Count < 7) || (DataConverter.CBoolean(base.Settings[6]) && this.Visible))
{
builder.Append("<tr class='tdbg'><td valign=\"middle\" style=\"width: 12%;\" align=\"right\" >上传图片 ： </td>");
builder.Append("<td align=\"left\" style=\"width: 88%;\"><iframe id=\"" + this.m_JSPrefix + "Upload\" src=\"\" marginheight=\"0\" marginwidth=\"0\" frameborder=\"0\" width=\"80%\" height=\"30px\" scrolling=\"no\"></iframe></td></tr>");
StringBuilder builder2 = new StringBuilder();
builder2.Append("<script type=\"text/javascript\">");
builder2.Append(" var nodeId = document.getElementById(nodeIdClientId).value;");
builder2.Append(" document.getElementById('" + this.m_JSPrefix + "Upload').src = \"" + this.m_ShowUploadFilePath + "/Accessories/FileUpload.aspx?ReturnJSFunction=" + this.m_JSPrefix + "DealwithUpload&ModuleName=Node&NodeId=\"+nodeId+\"&ModelId=" + base.Request["ModelId"] + "&FieldName=" + this.m_FieldName + "\";");
builder2.Append("</script>");
this.Page.ClientScript.RegisterStartupScript(base.GetType(), this.m_JSPrefix + "Upload", builder2.ToString());
}
if ((base.Settings.Count > 6) && (base.FieldLevel == 0))
{
StringBuilder builder3 = new StringBuilder();
builder3.Append("<script type=\"text/javascript\">");
builder3.Append(" function homeImageAssignment(path){");
builder3.Append(" document.getElementById('" + this.TxtImageText.ClientID + "').value = path;");
builder3.Append(this.m_JSPrefix + "AddItem(path);");
builder3.Append(" }");
builder3.Append("</script>");
this.Page.ClientScript.RegisterStartupScript(base.GetType(), this.m_JSPrefix + "Assignment", builder3.ToString());
}
if ((base.Settings.Count > 7) && DataConverter.CBoolean(base.Settings[7]))
{
this.ShowUploadFiles.Style.Add("display", "");
StringBuilder builder4 = new StringBuilder();
builder4.Append("document.getElementById(\"" + this.TxtImageText.ClientID + "\").value =this.value;eImgPreview.src=((this.value == '') ? '../../../Images/nopic.gif' : '");
if (string.Compare(base.Request.ApplicationPath, "/", StringComparison.Ordinal) != 0)
{
builder4.Append(base.Request.ApplicationPath + "/" + this.m_UploadDir);
}
else
{
builder4.Append("/" + this.m_UploadDir);
}
builder4.Append("' + this.value);");
this.DropUploadFiles.Attributes.Add("onchange", builder4.ToString());
if (!string.IsNullOrEmpty(this.UploadFiles))
{
foreach (string str in this.UploadFiles.Split(new char[] { '|' }))
{
ListItem item = new ListItem(str, str);
this.DropUploadFiles.Items.Add(item);
if (str == this.FieldValue)
{
this.DropUploadFiles.SelectedValue = item.Value;
}
}
}
}
this.LblUpload.Text = builder.ToString();
}
if (!base.IsPostBack)
{
this.TxtImageText.Text = this.FieldValue;
}
else
{
this.FieldValue = this.TxtImageText.Text;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Get the user id for check state of sign in
HttpCookie myCookie = new HttpCookie("cook");
myCookie = Request.Cookies["cook"];
string userID = null;
try
{
userID = myCookie.Values["UserID"].Replace(" ", string.Empty);
}
catch (Exception exep)
{
//Response.Write(exep.ToString());
//Label1.Text = "尚未登入，無法進行投票";
//Label1.Visible = true;
exep.ToString();
//return;
}
topic_click = Request.QueryString["topic"];
if (topic_click == null)
{
return;
}
_Default.MySQLconnect();
Sqlconnect = _Default.GetSqlConnection();
string SQLquery = @"SELECT * FROM Online_Polling_DB.dbo.[vote] WHERE topic = '" + topic_click + "' ;";
SqlCommand MyCommand = new SqlCommand(SQLquery, Sqlconnect);
SqlDataReader MysqlDataReader = MyCommand.ExecuteReader();
MysqlDataReader.Read();
string option_IN;
string topic = MysqlDataReader["topic"].ToString().Replace(" ", string.Empty);
string description_IN = MysqlDataReader["description"].ToString().Replace(" ", string.Empty);
Label1.Text = "主題 : " + topic + "<br />";
Label1.Text += "敘述 : " + description_IN + "<br />";
//read all
do
{
if (MysqlDataReader["option"].ToString() != "")
{
option_IN = MysqlDataReader["option"].ToString().Replace(" ", string.Empty);
ListItem temp = new ListItem(option_IN);
if (topic_click.Equals(topic))
{
if (!CheckBoxList1.Items.Contains(temp))
{
CheckBoxList1.Items.Add(option_IN);
}
}
}
} while (MysqlDataReader.Read());
MysqlDataReader.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
DtDoj.MaxDate = DateTime.Now;
DtDOP.MaxDate = DateTime.Now;
if (!Page.IsPostBack)
{
try
{
var deplist = SPContext.Current.Web.Lists.TryGetList(Utilities.Department);
if (deplist != null)
{
DdlDep.Items.Clear();
DdlDep.Items.Add("--Select--");
var collection = deplist.GetItems();
foreach (SPListItem item in collection)
{
DdlDep.Items.Add(item["Department"].ToString());
}
}
var desiglist = SPContext.Current.Web.Lists.TryGetList(Utilities.Designation);
if (desiglist != null)
{
DdlDesignation.Items.Clear();
DdlDesignation.Items.Add("--Select--");
var collection = desiglist.GetItems();
foreach (SPListItem item in collection)
{
DdlDesignation.Items.Add(item["Designation"].ToString());
}
}
var leavetypelist = SPContext.Current.Web.Lists.TryGetList(Utilities.EmployeeType);
if (leavetypelist != null)
{
DdlEmptype.Items.Clear();
DdlEmptype.Items.Add("--Select--");
var collection = leavetypelist.GetItems();
foreach (SPListItem item in collection)
{
DdlEmptype.Items.Add(item["Title"].ToString());
}
}
var managerlist = SPContext.Current.Web.Lists.TryGetList(Utilities.ReportingTo);
var Activemanager = GetListItemCollection(managerlist, "Manager Status", "Active");
if (Activemanager != null)
{
ddlReportingTo.Items.Clear();
ddlReportingTo.Items.Add("--Select--");
foreach (SPListItem item in Activemanager)
{
var spv = new SPFieldLookupValue(item["Reporting Managers"].ToString());
var listItem = new ListItem(spv.LookupValue,
item["Reporting Managers"].ToString());
ddlReportingTo.Items.Add(listItem);
}
}
var empid = System.Web.HttpContext.Current.Request.QueryString["EmpId"];
var inActivemanagerlist = SPContext.Current.Web.Lists.TryGetList(Utilities.EmployeeScreen);
var empitem = inActivemanagerlist.GetItemById(Convert.ToInt16(empid));
empSPid.Value = empid;
txtempid.Text = empitem["Title"].ToString();
var curemp = txtempid.Text;
var InActivemanager = GetListItemCollection(inActivemanagerlist, "Employee ID", curemp, "Status", "In Active");
if (InActivemanager.Count > 0)
{
ddlReportingTo.Enabled = false;
}
var currentYear = SPContext.Current.Web.Lists.TryGetList(Utilities.CurrentYear).GetItems();
foreach (SPListItem currentYearValue in currentYear)
{
hdnCurrentYear.Value = currentYearValue["Title"].ToString();
}
var financialStartMont = SPContext.Current.Web.Lists.TryGetList(Utilities.Financialstartmonth).GetItems();
foreach (SPListItem finStrtmonth in financialStartMont)
{
hdnStrtFnclMnth.Value = finStrtmonth["Title"].ToString();
}
EmployeeDetails();
}
catch (Exception ex)
{
LblError.Text = ex.Message;
}
}
}
/// <summary>
/// Method to add Answers to the answer list box. This button will also work
/// in combination with the edit button to resubmit and edited answer.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddAnswer_Click(object sender, EventArgs e)
{
ansEditIndex = Convert.ToInt32(Session["ansEditIndex"]);
// regular expression to enure only numbers are entered in the rank text field.
Regex reg = new Regex(@"^[-10123456789]+$");
if (tbAnswer.Text.Equals(string.Empty) || tbScore.Text.Equals(string.Empty) || (!reg.IsMatch(tbScore.Text))) {
lblErrorAdd.Visible = true;
}
else {
lblErrorAdd.Visible = false;
//
if (tbQuestion.Enabled == false) {
lbAnswerList.Items[ansEditIndex].Text = tbAnswer.Text + " [" + tbScore.Text + "]";
tbQualDesc.Enabled = true;
tbQuestion.Enabled = true;
lbAnswerList.Enabled = true;
btnRemove.Enabled = true;
btnClear.Enabled = true;
btnEdit.Enabled = true;
btnContinue.Enabled = true;
btnFinished.Enabled = true;
ansEditIndex = 0;
}
else {
//the -1 should be the answer id if it has one
ListItem item = new ListItem(tbAnswer.Text + " [" + tbScore.Text + "]", ((lbAnswerList.Items.Count+1)*-1).ToString());
lbAnswerList.Items.Add(item);
}
tbAnswer.Text = string.Empty;
tbScore.Text = string.Empty;
}
}
