public projectTable GetEntityById(int Id)
{
SqlParameter param = new SqlParameter("@projectID", Id);
string strSQL = "select * from [projectTable] where projectID = @projectID ";
System.Data.SqlClient.SqlDataReader dr;
dr = SQLHelper.ExecuteReader(strSQL, param);
try
{
projectTable entity = new projectTable();
entity = SQLHelper.ReaderToList <projectTable>(dr)[0];
return(entity);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
return(null);
}
finally
{
if (!dr.IsClosed)
{
dr.Close();
}
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
projectTable entity = new projectTable();
if (tbProjID.Text != "")
{
entity.projectID = Convert.ToInt32(tbProjID.Text);
}
if (cmbProjectStatus.SelectedIndex > 0)
{
entity.projectStatus = Convert.ToInt32(cmbProjectStatus.SelectedValue);
}
if (cmbProjectType.SelectedIndex > 0)
{
entity.projectType = Convert.ToInt32(cmbProjectType.SelectedValue);
}
if (cmbProjectSite.SelectedIndex > 0)
{
entity.projectSite = Convert.ToInt32(cmbProjectSite.SelectedValue);
}
if (cmbPriority.SelectedIndex > 0)
{
entity.priority = Convert.ToInt32(cmbPriority.SelectedValue);
}
DataTable dt = projBLL.getDataTableByEntity(entity);
ViewState["GridProjData"] = dt;
GridProj.DataSource = dt;
GridProj.DataBind();
}
public bool Post4Testing(int all)
{
projectTable pt = new projectTable();
pt.projectid = 5;
pt.projectdesc = "Testing";
pt.priority = 12;
try
{
using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities())
{
if (pt.projectid > 0)
{
entities.projectTables.Add(pt);
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public HttpResponseMessage Post([FromBody] projectTable pt)
{
try
{
using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities())
{
if (pt.projectid > 0)
{
entities.projectTables.Add(pt);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, pt);
message.Headers.Location = new Uri(Request.RequestUri + "/" + pt.projectid.ToString());
return(message);
}
else
{
var message = Request.CreateResponse(HttpStatusCode.LengthRequired);
return(message);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public DataTable GetDataTableByEntity(projectTable entity, string startDate, string endDate)
{
string strSQL = "select * from projectTable where deleteStatus=1 ";
if (entity.contactName != null)
{
strSQL += string.Format(" and contactName='{0}' ", entity.contactName.ToString());
}
if (entity.projectStatus != null)
{
strSQL += " and projectStatus= " + entity.projectStatus.ToString();
}
if (entity.projectType != null)
{
strSQL += " and projectType= " + entity.projectType.ToString();
}
if (entity.projectSite != null)
{
strSQL += " and projectSite= " + entity.projectSite.ToString();
}
if (entity.priority != null)
{
strSQL += " and priority= " + entity.priority.ToString();
}
if (startDate != "")
{
strSQL += string.Format(" and createDate >= '{0}' ", startDate);
}
if (endDate != "")
{
strSQL += string.Format(" and createDate <= '{0}' ", endDate);
}
return(SQLHelper.ExecuteDataTable(strSQL, null));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
projectTable entity = new projectTable();
entity.projectID = -1;
entity.projectStatus = 0;
entity.hasDetail = 0;
entity.contactName = tbContactName.Text.Trim();
string contactPhone = tbContactPhone.Text.Trim();
if (contactPhone != "")
{
entity.contactPhone = contactPhone;
}
else
{
RadAjaxManager1.Alert("请填写联系方式。"); tbContactPhone.Focus(); return;
}
entity.priority = Convert.ToInt32(cmbPriority.SelectedValue);
if (cmbProjectType.SelectedIndex > 0)
{
entity.projectType = Convert.ToInt32(cmbProjectType.SelectedValue);
}
else
{
RadAjaxManager1.Alert("请选择报修类别。"); cmbProjectType.Focus(); return;
}
if (cmbProjectSite.SelectedIndex > 0)
{
entity.projectSite = Convert.ToInt32(cmbProjectSite.SelectedValue);
}
else
{
RadAjaxManager1.Alert("请选择报修地点。"); cmbProjectSite.Focus(); return;
}
string detailSite = tbSiteDetail.Text.Trim();
if (detailSite != "")
{
entity.siteDetail = detailSite;
}
else
{
RadAjaxManager1.Alert("请填写具体位置。"); tbSiteDetail.Focus(); return;
}
entity.projectDetail = tbProjectDetail.Text.Trim();
entity.projectID = pBLL.addNewRepairProject(entity);
if (entity.projectID > 0)
{
RadAjaxManager1.Alert("报修已提交。");
Global.InputReset(repairForm);
//Global.InputReset(queryForm, tbQueryID);
tbQueryID.Text = entity.projectID.ToString();
fillQueryForm(entity.projectID.ToString());
}
else
{
RadAjaxManager1.Alert("提交失败，请重试。");
}
}
public IList <projectDetailTable> getMyProjectByQuery(int rmID, projectTable projInfo)
{
string strSQL = @"
select * from projectDetailTable
where deleteStatus=1 and repairmanID={0}
and projectID in (select projectID from projectTable where deleteStatus=1 {1} )
";
string tempSQL = "";
// 将detail表的createDate字段放入project的updateDate字段中，方便传值
if (projInfo.updateDate > DateTime.MinValue)
{
strSQL += string.Format(" and DateDiff(dd, createDate, '{0}') = 0 ", projInfo.updateDate.Value.ToShortDateString());
}
if (projInfo.projectID > 0)
{
tempSQL += " and projectID= " + projInfo.projectID;
}
if (projInfo.projectStatus != null)
{
tempSQL += " and projectStatus=" + projInfo.projectStatus;
}
if (projInfo.projectType != null)
{
tempSQL += " and projectType= " + projInfo.projectType;
}
if (projInfo.projectSite != null)
{
tempSQL += " and projectSite= " + projInfo.projectSite;
}
strSQL = string.Format(strSQL, rmID, tempSQL);
System.Data.SqlClient.SqlDataReader dr = SQLHelper.ExecuteReader(strSQL, null);
return(SQLHelper.ReaderToList <projectDetailTable>(dr));
}
public int SaveEntity(projectTable entity)
{
List <SqlParameter> paramList = new List <SqlParameter>();
var projectID_parameter = new SqlParameter("@projectID", SqlDbType.Int);
if (entity.projectID > 0)
{
projectID_parameter.Value = entity.projectID;
}
else
{
projectID_parameter.Value = DBNull.Value;
}
var projectStatus_parameter = new SqlParameter("@projectStatus", entity.projectStatus);
paramList.Add(projectStatus_parameter);
var priority_parameter = new SqlParameter("@priority", entity.priority);
paramList.Add(priority_parameter);
var projectType_parameter = new SqlParameter("@projectType", entity.projectType);
paramList.Add(projectType_parameter);
var projectSite_parameter = new SqlParameter("@projectSite", entity.projectSite);
paramList.Add(projectSite_parameter);
SqlParameter contactName_parameter = new SqlParameter("@contactName", entity.contactName);
paramList.Add(contactName_parameter);
SqlParameter contactPhone_parameter = new SqlParameter("@contactPhone", entity.contactPhone);
paramList.Add(contactPhone_parameter);
SqlParameter projectDetail_parameter = new SqlParameter("@projectDetail", entity.projectDetail);
paramList.Add(projectDetail_parameter);
SqlParameter siteDetail_parameter = new SqlParameter("@siteDetail", entity.siteDetail);
paramList.Add(siteDetail_parameter);
SqlParameter hasDetail_parameter = new SqlParameter("@hasDetail", entity.hasDetail);
paramList.Add(hasDetail_parameter);
string sql = "";
SqlParameter identityParameter = new SqlParameter("@IdentityId", SqlDbType.Int);
if (entity.projectID == -1)
{
identityParameter.Direction = ParameterDirection.Output;
paramList.Add(identityParameter);
sql = "insert into projectTable(projectStatus,priority,projectType,projectSite,contactName,contactPhone,projectDetail,siteDetail,hasDetail,createDate,deleteStatus) ";
sql += "values(@projectStatus,@priority,@projectType,@projectSite,@contactName,@contactPhone,@projectDetail,@siteDetail,0,GETDATE(),1) Select @IdentityId = @@identity ";
}
else
{
paramList.Add(projectID_parameter);
sql = "update projectTable set projectStatus = @projectStatus,priority = @priority,projectType = @projectType,projectSite = @projectSite,contactName = @contactName,contactPhone = @contactPhone,projectDetail = @projectDetail,siteDetail = @siteDetail,hasDetail = @hasDetail,updateDate = GETDATE() where projectID =@projectID ";
}
int count = SQLHelper.ExecuteonQuery(sql, paramList.ToArray());
return(entity.projectID > 0 ? count : (identityParameter == null ? -1 : Convert.ToInt32(identityParameter.Value)));
}
public DataTable getDataTableByEntity(projectTable entity, string startDate = "", string endDate = "")
{
if (entity.projectID > 0 && (entity = getProjectInfoByID(entity.projectID)) != null)
{
return(SQLHelper.ToDataTable(new projectTable[] { entity }));
}
return(dal.GetDataTableByEntity(entity, startDate, endDate));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
projectTable entity = projBLL.getProjectInfoByID(Convert.ToInt32(tbProjectID.Text));
if (entity != null)
{
if (cmbProjectStatus.SelectedIndex > 0)
{
entity.projectStatus = Convert.ToInt32(cmbProjectStatus.SelectedValue);
}
if (cmbProjectType.SelectedIndex > 0)
{
entity.projectType = Convert.ToInt32(cmbProjectType.SelectedValue);
}
entity.priority = Convert.ToInt32(cmbPriority.SelectedValue);
if (dateCreate.SelectedDate.HasValue)
{
entity.createDate = dateCreate.SelectedDate.Value;
}
if (tbContactName.Text != "")
{
entity.contactName = tbContactName.Text.Trim();
}
if (tbContactPhone.Text != "")
{
entity.contactPhone = tbContactPhone.Text.Trim();
}
if (tbProjectDetail.Text != "")
{
entity.projectDetail = tbProjectDetail.Text;
}
if (cmbProjectSite.SelectedIndex > 0)
{
entity.projectSite = Convert.ToInt32(cmbProjectSite.SelectedValue);
}
if (tbSiteDetail.Text != "")
{
entity.siteDetail = tbSiteDetail.Text.Trim();
}
if (dateUpdate.SelectedDate.HasValue)
{
entity.updateDate = dateUpdate.SelectedDate.Value;
}
if (projBLL.updateProjectInfo(entity))
{
RadAjaxManager1.Alert("更新成功");
setInputEnable(false);
getProjInfoByID(entity.projectID);
}
else
{
RadAjaxManager1.Alert("更新失败");
}
}
}
private void fillQueryForm(string strqueryID, string strQueryName = "")
{
projectTable info = new projectTable();
int queryID = 0;
if (!string.IsNullOrEmpty(strqueryID))
{
queryID = Convert.ToInt32(strqueryID);
info = pBLL.getProjectInfoByID(queryID);
}
else if (!string.IsNullOrEmpty(strQueryName))
{
info.contactName = strQueryName;
DataTable dt = pBLL.getDataTableByEntity(info);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
queryID = Convert.ToInt32(row["projectID"]);
info.projectID = queryID;
info.projectStatus = Convert.ToInt32(row["projectStatus"]);
info.projectDetail = row["projectDetail"] == null ? "" : row["projectDetail"].ToString();
info.updateDate = row["updateDate"] == null ? DateTime.MinValue : Convert.ToDateTime(row["updateDate"]);
}
}
if (queryID > 0)
{
tbProjectStatus.Text = paramBLL.getProjectStatusByValue(info.projectStatus.Value);
tbRepairMan.Text = dBLL.getProjectRepairMan(queryID);
if (info.projectDetail != null && info.projectDetail != "")
{
tbQueryDetail.Text = info.projectDetail;
}
if (info.updateDate != null && info.updateDate > DateTime.MinValue)
{
tbUpdateDate.Text = info.updateDate.Value.ToString("yyyy/MM/dd");
}
DataTable dt = dBLL.getDetailDataTableByProjID(queryID);
if (dt.Rows.Count > 0)
{
tbFaultDetail.Text = dt.Rows[0]["faultDetail"].ToString();
}
}
else
{
RadAjaxManager1.Alert("无对应项目，请检查报修单号后重试。");
}
}
public bool Put4Testing(int all)
{
projectTable pt = new projectTable();
pt.projectid = 5;
pt.priority = 19;
pt.startdate = new DateTime().Date;
try
{
using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities())
{
var entity = entities.projectTables.FirstOrDefault(proj => proj.projectid == pt.projectid);
if (entity == null)
{
return(false);
}
else
{
if (pt.projectdesc != null)
{
entity.projectdesc = pt.projectdesc;
}
if (pt.priority != null)
{
entity.priority = pt.priority;
}
if (pt.startdate != null)
{
entity.startdate = pt.startdate;
}
if (pt.enddate != null)
{
entity.enddate = pt.enddate;
}
entities.SaveChanges();
return(true);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public IList <projectDetailTable> getMyProjectByQuery(int rmID, projectTable projInfo)
{
var projCollection = MongoHelper.GetCollection <projectTable>("project");
var projQueryFilter = Builders <projectTable> .Filter.Eq(p => p.deleteStatus, (byte)1);
if (projInfo.projectID > 0)
{
projQueryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectID, projInfo.projectID);
}
if (projInfo.projectStatus != null)
{
projQueryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectStatus, projInfo.projectStatus);
}
if (projInfo.projectType != null)
{
projQueryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectType, projInfo.projectType);
}
if (projInfo.projectSite != null)
{
projQueryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectSite, projInfo.projectSite);
}
var projProjectFilter = Builders <projectTable> .Projection.Include(p => p.projectID);
//BsonArray idArr = new BsonArray();
List <int> idArr = new List <int>();
var cursor = projCollection.Find(projQueryFilter).Project(projProjectFilter).ToCursor(); // 查找集合中所有 并遍历
foreach (BsonDocument pdoc in cursor.ToEnumerable())
{
//idArr.Add(new BsonInt64(pdoc.GetValue("_id").AsInt32));
idArr.Add(pdoc.GetValue("_id").AsInt32);
}
var queryFilter = defaultFilter;
queryFilter &= Builders <projectDetailTable> .Filter.Eq(pd => pd.repairmanID, rmID);
queryFilter &= Builders <projectDetailTable> .Filter.In("projectID", idArr.AsEnumerable());
if (projInfo.updateDate > DateTime.MinValue)
{
// 将detail表的createDate字段放入project的updateDate字段中，方便传值
queryFilter &= (Builders <projectDetailTable> .Filter.Gte("createDate", projInfo.updateDate.Value)
& Builders <projectDetailTable> .Filter.Lt("createDate", projInfo.updateDate.Value.AddDays(1)));
}
var detailList = collection.Find(queryFilter).ToList();
return(detailList);
}
public HttpResponseMessage Put([FromBody] projectTable pt)
{
try
{
using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities())
{
var entity = entities.projectTables.FirstOrDefault(proj => proj.projectid == pt.projectid);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "ProjectID = " + pt.projectid.ToString() + " not found to update."));
}
else
{
if (pt.projectdesc != null)
{
entity.projectdesc = pt.projectdesc;
}
if (pt.priority != null)
{
entity.priority = pt.priority;
}
if (pt.startdate != null)
{
entity.startdate = pt.startdate;
}
if (pt.enddate != null)
{
entity.enddate = pt.enddate;
}
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public int assignRepairMan(int projID, int rmID)
{
projectDetailTable entity = new projectDetailTable();
entity.detailID = -1;
entity.projectID = projID;
entity.repairmanID = rmID;
entity.faultStatus = 2;
entity.severity = 0;
entity.faultType = 0;
if ((entity.detailID = dal.SaveEntity(entity)) > 1)
{
//projectTableDAL projDal = new projectTableDAO();
projectTableDAL projDal = new projectRepository();
projectTable projEntity = projDal.GetEntityById(entity.projectID.Value);
projEntity.hasDetail = 1;
entity.detailID = projDal.SaveEntity(projEntity) > 0 ? entity.detailID : 0;
}
return(entity.detailID);
}
public int SaveEntity(projectTable entity)
{
if (entity.projectID == -1)
{
entity.projectID = 1 + MongoHelper.GetMaxId(collection);
entity.createDate = DateTime.Now;
entity.deleteStatus = 1;
try
{
collection.InsertOne(entity);
return(1);
}
catch (Exception)
{
return(0);
}
}
else
{
var idFilter = Builders <projectTable> .Filter.Eq(p => p.projectID, entity.projectID);
var updateResult = collection.UpdateOne(idFilter,
Builders <projectTable> .Update.Set("projectStatus", entity.projectStatus)
.Set("priority", entity.priority)
.Set("projectType", entity.projectType)
.Set("projectSite", entity.projectSite)
.Set("contactName", entity.contactName)
.Set("contactPhone", entity.contactPhone)
.Set("projectDetail", entity.projectDetail)
.Set("siteDetail", entity.siteDetail)
.Set("hasDetail", entity.hasDetail)
//.Set("createDate", entity.createDate)
.Set("updateDate", DateTime.Now)
//.Set("deleteStatus", entity.deleteStatus)
);
return(updateResult.IsAcknowledged ? Convert.ToInt32(updateResult.ModifiedCount) : 0);
}
}
private void getProjInfoByID(int projID)
{
projectTable entity = projBLL.getProjectInfoByID(projID);
if (entity != null)
{
cmbProjectStatus.SelectedValue = entity.projectStatus.ToString();
cmbProjectType.SelectedValue = entity.projectType.ToString();
cmbPriority.SelectedValue = entity.priority.ToString();
dateCreate.SelectedDate = entity.createDate.Value;
tbContactName.Text = entity.contactName;
tbContactPhone.Text = entity.contactPhone;
tbProjectDetail.Text = entity.projectDetail;
cmbProjectSite.SelectedValue = entity.projectSite.ToString();
tbSiteDetail.Text = entity.siteDetail;
if (entity.updateDate.HasValue)
{
dateUpdate.SelectedDate = entity.updateDate.Value;
}
tbRepairman.Text = detailBLL.getProjectRepairMan(projID);
setDetailGridVisible(Convert.ToBoolean(entity.hasDetail));
}
}
public DataTable GetDataTableByEntity(projectTable entity, string startDate, string endDate)
{
FilterDefinition <projectTable> queryFilter = defaultFilter;
if (!string.IsNullOrEmpty(entity.contactName))
{
queryFilter &= Builders <projectTable> .Filter.Eq(p => p.contactName, entity.contactName);
}
if (entity.projectStatus != null)
{
queryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectStatus, entity.projectStatus);
}
if (entity.projectType != null)
{
queryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectType, entity.projectType);
}
if (entity.projectSite != null)
{
queryFilter &= Builders <projectTable> .Filter.Eq(p => p.projectSite, entity.projectSite);
}
if (entity.priority != null)
{
queryFilter &= Builders <projectTable> .Filter.Eq(p => p.priority, entity.priority);
}
if (!string.IsNullOrEmpty(startDate))
{
queryFilter &= Builders <projectTable> .Filter.Gte("createDate", DateTime.Parse(startDate));
}
if (!string.IsNullOrEmpty(endDate))
{
queryFilter &= Builders <projectTable> .Filter.Lte("createDate", DateTime.Parse(endDate));
}
var resultList = collection.Find(queryFilter).ToList();
return(SQLHelper.ToDataTable(resultList));
}
protected void btnQuery_Click(object sender, EventArgs e)
{
projectTable proj = new projectTable();
int rmID = (string.IsNullOrEmpty(hiddenRMID.Value)) ? 0 : Convert.ToInt32(hiddenRMID.Value);
if (tbProjectID.Text != "")
{
proj.projectID = Convert.ToInt32(tbProjectID.Text);
}
if (cmbProjectStatus.SelectedIndex > 0)
{
proj.projectStatus = Convert.ToInt32(cmbProjectStatus.SelectedValue);
}
if (cmbProjectType.SelectedIndex > 0)
{
proj.projectType = Convert.ToInt32(cmbProjectType.SelectedValue);
}
if (cmbProjectSite.SelectedIndex > 0)
{
proj.projectSite = Convert.ToInt32(cmbProjectSite.SelectedValue);
}
if (DateDetailCreate.SelectedDate.HasValue)
{
proj.updateDate = DateDetailCreate.SelectedDate.Value;
}
List <projectDetailTable> detailList = detailBLL.getMyRepairProjectIDList(rmID, proj).ToList();
if (detailList.Count > 0)
{
ViewState["isQuery"] = "true"; showDetailList(detailList);
}
else
{
RadAjaxManager1.Alert("没有查询到对应记录。"); ViewState["isQuery"] = "false";
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
projectTable entity = new projectTable();
if (cmbStatus.SelectedIndex > 0)
{
entity.projectStatus = Convert.ToInt32(cmbStatus.SelectedValue);
}
if (cmbType.SelectedIndex > 0)
{
entity.projectType = Convert.ToInt32(cmbType.SelectedValue);
}
if (cmbSite.SelectedIndex > 0)
{
entity.projectSite = Convert.ToInt32(cmbSite.SelectedValue);
}
if (cmbPriority.SelectedIndex > 0)
{
entity.priority = Convert.ToInt32(cmbPriority.SelectedValue);
}
string startDate = "", endDate = "";
if (dateStart.SelectedDate.HasValue)
{
startDate = dateStart.SelectedDate.Value.ToShortDateString();
}
if (dateEnd.SelectedDate.HasValue)
{
endDate = dateEnd.SelectedDate.Value.ToShortDateString();
}
DataTable dt = projBLL.getDataTableByEntity(entity, startDate, endDate);
ViewState["GridProjData"] = dt;
GridProject.DataSource = dt;
GridProject.DataBind();
}
public bool updateProjectInfo(projectTable entity)
{
return(entity.projectID > 0 && dal.SaveEntity(entity) > 0);
}
public int addNewRepairProject(projectTable entity)
{
entity.projectID = entity.projectID > 0 ? entity.projectID : -1;
return(dal.SaveEntity(entity) > 0 ? entity.projectID : 0);
}
public IList <projectDetailTable> getMyRepairProjectIDList(int rmID, projectTable queryProj = null)
{
return(queryProj == null?dal.getMyRepairProjectList(rmID) : dal.getMyProjectByQuery(rmID, queryProj));
}
private void createCard(int detailID, DateTime createDate, projectTable entity)
{
RadCard card = new RadCard();
// CardHeaderComponent
// CardTitleComponent: ProjectType
// CardSubtitleComponent: priority
// CardSubtitleComponent: CreateDate
CardHeaderComponent head = new CardHeaderComponent();
CardTitleComponent title = new CardTitleComponent();
title.Content = Global.CmbItem_parseToText(entity.projectType, "projectType");
head.Controls.Add(title);
CardSubtitleComponent subtitle1 = new CardSubtitleComponent();
subtitle1.Content = "优先级: " + Global.CmbItem_parseToText(entity.priority, "priority");
subtitle1.CssClass = "float-right";
head.Controls.Add(subtitle1);
CardSubtitleComponent subtitle2 = new CardSubtitleComponent();
subtitle2.Content = createDate > DateTime.MinValue ? "分配日期: " + createDate.ToShortDateString() : "报修时间: " + entity.createDate.Value.ToShortDateString();
head.Controls.Add(subtitle2);
card.Controls.Add(head);
// CardBodyComponent
// p: 项目号
// p: 联系人姓名、手机号
// p: 报修地点、具体位置
// p: 详细描述
CardBodyComponent body = new CardBodyComponent();
HtmlGenericControl p1 = new HtmlGenericControl();
p1.TagName = "p";
p1.Attributes.Add("class", "threecols");
p1.InnerHtml = string.Format("<span>项目号:</span><span class='span-col-2'>{0}</span>", entity.projectID);
//p1.InnerText = "项目号: " + entity.projectID.ToString();
body.Controls.Add(p1);
HtmlGenericControl p2 = new HtmlGenericControl();
p2.TagName = "p";
p2.Attributes.Add("class", "threecols");
p2.InnerHtml = string.Format("<span>联系人:</span><span>{0}</span><span>{1}</span>", entity.contactName, entity.contactPhone);
body.Controls.Add(p2);
HtmlGenericControl p3 = new HtmlGenericControl();
p3.TagName = "p";
p3.Attributes.Add("class", "threecols");
p3.InnerHtml = string.Format("<span>报修地点:</span><span>{0}</span><span>{1}</span>", Global.CmbItem_parseToText(entity.projectSite, "projectSite"), entity.siteDetail);
body.Controls.Add(p3);
HtmlGenericControl p4 = new HtmlGenericControl();
p4.TagName = "p";
p4.Attributes.Add("class", "threecols");
p4.InnerHtml = string.Format("<span>详细描述:</span><span class='span-col-2'>{0}</span>", entity.projectDetail);
//p4.InnerText = "详细描述: " + entity.projectDetail;
body.Controls.Add(p4);
card.Controls.Add(body);
// CardActionsContainerComponent
// CardActionComponent
// RadComboBox: cmbProjectStatus
// CardActionComponent
// RadButton: btnViewProj
// CardActionComponent
// RadButton: btnFillDetail
CardActionsContainerComponent btnContainer = new CardActionsContainerComponent();
btnContainer.CardActionsAlignment = CardActionsAlignmentType.Stretched;
btnContainer.Orientation = CardComponentOrientation.Vertical;
CardActionComponent action1 = new CardActionComponent();
RadComboBox cmb = new RadComboBox();
//cmb.ID = "cmbProjectStatus";
cmb.Attributes.Add("projectID", entity.projectID.ToString());
Global.ComboBox_BindParamData(cmb, Global.ProjectStatus);
cmb.Items[0].Enabled = false; cmb.Items[1].Enabled = false;
cmb.SelectedValue = entity.projectStatus.ToString();
cmb.AutoPostBack = true;
cmb.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(cmbProjectStatus_SelectedIndexChanged);
cmb.EnableEmbeddedSkins = false;
cmb.CssClass = "k-button k-flat k-primary";
cmb.Font.Size = FontUnit.Parse("14px");
action1.Controls.Add(cmb);
btnContainer.Controls.Add(action1);
CardActionComponent action2 = new CardActionComponent();
RadLinkButton btn1 = new RadLinkButton();
//btn1.ID = "btnViewProj";
btn1.Text = "项目详情";
btn1.NavigateUrl = Global.projectURL + "?projID=" + entity.projectID.ToString();
btn1.Target = "_blank";
btn1.EnableEmbeddedSkins = false;
btn1.CssClass = "k-button k-flat k-primary";
btn1.Font.Size = FontUnit.Parse("14px");
action2.Controls.Add(btn1);
btnContainer.Controls.Add(action2);
CardActionComponent action3 = new CardActionComponent();
RadLinkButton btn2 = new RadLinkButton();
//btn2.ID = "btnFillDetail";
btn2.Text = "填写维修记录";
btn2.NavigateUrl = Global.detailURL + "?detailID=" + detailID.ToString();
btn2.Target = "_blank";
btn2.EnableEmbeddedSkins = false;
btn2.CssClass = "k-button k-flat k-primary";
btn2.Font.Size = FontUnit.Parse("14px");
action3.Controls.Add(btn2);
btnContainer.Controls.Add(action3);
card.Controls.Add(btnContainer);
div_cards.Controls.Add(card);
}
