protected void btnAddSection_Click(object sender, EventArgs e)
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
if (ValidSection() == true)
{
if (SaveQuestionnaire(trans) == true) {
QuestionnaireSectionPara para = new QuestionnaireSectionPara();
para.ID = Convert.ToInt64(txtQuestionSectionID.Text);
para.QUESTIONNAIRE_ID = Convert.ToInt64(txtID.Text);
para.SECTION_NAME = txtSectionName.Text.Trim();
para.DESCRIPTION = txtSectionDesc.Text.Trim();
para.SECTION_TYPE_ID = Convert.ToInt64(cmbSectionTypeID.SelectedValue);
para.CHOICE_QTY = (txtChoiceQty.Text.Trim()=="" ? 0 : Convert.ToInt64(txtChoiceQty.Text));
QuestionnaireENG eng = new QuestionnaireENG();
bool ret = eng.SaveQuestionnaireSection(para, trans, Config.GetUserName());
if (ret == true)
{
trans.CommitTransaction();
txtQuestionSectionID.Text = eng.QUESTIONNAIRE_SECTION_ID.ToString();
SetQuestionnaireForm(Convert.ToInt64(txtID.Text));
SetSectionList();
Config.SetAlert("บันทึกข้อมูลเรียบร้อย", this);
}
else
{
trans.RollbackTransaction();
Config.SetAlert(eng.ErrorMessage, this);
}
}
}
}
/// <summary>
/// 处理qString;
/// </summary>
/// <param name="dbProvider"></param>
/// <param name="dbTran"></param>
void IProvider.SetDbProvider(DbProvider dbProvider, DbTrans dbTran)
{
if (creator != null)
{
var query = GetQuery(creator);
query.SetDbProvider(dbProvider, dbTran);
qString = query.GetTop(1).QueryString;
}
}
public DataTable GetQuestionnaireSectionList(long QuestionnaireID,DbTrans trans) {
QuestionnaireSectionLinq lnq = new QuestionnaireSectionLinq();
string sql = "";
sql += "select qs.id, qs.questionnaire_id, qs.section_name, qs.description, qs.section_type_id, ";
sql += " st.section_type_name, qs.choice_qty";
sql += " from questionnaire_section qs ";
sql += " inner join section_type st on st.id=qs.section_type_id ";
sql += " where qs.questionnaire_id = " + QuestionnaireID;
sql += " order by qs.id ";
return lnq.GetListBySql(sql, trans.Trans);
}
/// <summary>
/// 保存用户
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool SaveExt(Mes_Sys_User obj)
{
int result = -1;
try
{
using (DbTrans trans = this.CurDbSession.BeginTransaction())
{
//1.保存用户
if (obj.ID > 0)
{
result = trans.Update <Mes_Sys_User>(obj);
}
else
{
result = trans.Insert <Mes_Sys_User>(obj);
}
if (result <= 0)
{
trans.Rollback();
return(false);
}
//2.保存用户角色、部门关系表
string sql = @"DELETE FROM Mes_Sys_Map WHERE UserID ='{0}';
INSERT INTO Mes_Sys_Map(UserID,RoleID,OrgID,RecordStatus,Creater,CreatedTime)VALUES('{0}',{1},{2},1,'{3}',GETDATE())";
sql = string.Format(sql, obj.UserID, obj.RoleID, obj.OrgID, obj.Creater);
result = trans.FromSql(sql).ExecuteNonQuery();
if (result <= 0)
{
trans.Rollback();
return(false);
}
//提交事务
trans.Commit();
}
}
catch (System.Exception ex)
{
throw ex;
}
return(true);
}
//样品导入
public bool Import(List <Mes_Tec_ProcessBom> bomList, List <Mes_Tec_ProcessBomItem> list, IList <ImportMessageModel> resultList)
{
try
{
int result = 0;
using (DbTrans trans = this.CurDbSession.BeginTransaction())
{
//1.保存主表
foreach (var item in bomList)
{
result = this.CurDbSession.Insert <Mes_Tec_ProcessBom>(item);
if (result <= 0)
{
trans.Rollback();
return(false);
}
list.ForEach(p =>
{
if (p.MaterialProNo == item.MaterialProNo && p.Version == item.Version)
{
p.ProcessBomID = result;
}
});
}
//2.保存明细
result = this.CurDbSession.Insert <Mes_Tec_ProcessBomItem>(list);
if (result <= 0)
{
trans.Rollback();
return(false);
}
//提交事务
trans.Commit();
}
return(true);
}
catch (Exception ex)
{
resultList.Add(new ImportMessageModel {
RowData = "导入失败", RowMessage = "导入出错，错误信息：" + ex.Message
});
}
return(false);
}
/// <summary>
/// 修改机构信息
/// </summary>
/// <param name="entity">业务实体</param>
public void OrganSave(Organization entity)
{
if (entity.Org_ID < 1)
{
return;
}
//解析地址
WeiSha.Common.Param.Method.Position posi = WeiSha.Common.Request.Position(entity.Org_Longitude, entity.Org_Latitude);
entity.Org_Province = posi.Province;
entity.Org_City = posi.City;
entity.Org_District = posi.District;
entity.Org_Street = posi.Street;
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Save <Organization>(entity);
//员工所属机构名称
tran.Update <EmpAccount>(new Field[] { EmpAccount._.Org_Name }, new object[] { entity.Org_Name }, EmpAccount._.Org_ID == entity.Org_ID);
tran.Update <Depart>(new Field[] { Depart._.Org_Name }, new object[] { entity.Org_Name }, Depart._.Org_ID == entity.Org_ID);
//专业、课程、试卷，考试
tran.Update <Subject>(new Field[] { Subject._.Org_Name }, new object[] { entity.Org_Name }, Subject._.Org_ID == entity.Org_ID);
tran.Update <Course>(new Field[] { Course._.Org_Name }, new object[] { entity.Org_Name }, Course._.Org_ID == entity.Org_ID);
tran.Update <TestPaper>(new Field[] { TestPaper._.Org_Name }, new object[] { entity.Org_Name }, TestPaper._.Org_ID == entity.Org_ID);
tran.Update <Examination>(new Field[] { Examination._.Org_Name }, new object[] { entity.Org_Name }, Examination._.Org_ID == entity.Org_ID);
//学员与教师
tran.Update <StudentSort>(new Field[] { StudentSort._.Org_Name }, new object[] { entity.Org_Name }, StudentSort._.Org_ID == entity.Org_ID);
tran.Update <Teacher>(new Field[] { Teacher._.Org_Name }, new object[] { entity.Org_Name }, Teacher._.Org_ID == entity.Org_ID);
tran.Update <TeacherSort>(new Field[] { TeacherSort._.Org_Name }, new object[] { entity.Org_Name }, TeacherSort._.Org_ID == entity.Org_ID);
tran.Commit();
this.OrganBuildCache();
}
catch
{
tran.Rollback();
throw;
}
finally
{
tran.Close();
}
}
this.OrganBuildQrCode(entity);
this.OrganBuildCache(); //重新构建缓存
}
public int Add(string newsId)
{
int ret = 0;
DateTime dt = DateTime.Now;
cmsNews n = ns.GetModel(newsId);
if (n == null)
{
throw new Exception("文章不存在！");
}
using (DbTrans t = ns.BeginTransaction())
{
n.Attach();
n.Hits += 1;
ns.UpdateModel(n);
SetTransaction(t);
cmsNewsHit h = GetModelWithWhere(
cmsNewsHit._.NewsId == newsId && (
cmsNewsHit._.HitDate.Year == dt.Year &&
cmsNewsHit._.HitDate.Month == dt.Month &&
cmsNewsHit._.HitDate.Day == dt.Day)
);
if (h == null)
{
h = new cmsNewsHit();
h.NewsId = newsId;
h.HitDate = DateTime.Now.Date;
h.Hits = 1;
ret = AddModel(h);
}
else
{
h.Attach();
h.Hits += 1;
ret = UpdateModel(h);
}
t.Commit();
}
return(ret);
}
/// <summary>
/// 删除，按主键ID；
/// </summary>
/// <param name="identify">实体的主键</param>
public void Delete(int identify)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
try
{
this._Delete(identify, tran);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
finally
{
tran.Close();
}
}
/// <summary>
/// 新增数据
/// </summary>
public AjaxResult Insert(TbRawMaterialMonthDemandSupplyPlan model, List <TbRawMaterialMonthDemandSupplyPlanDetail> items)
{
if (model == null)
{
return(AjaxResult.Warning("参数错误"));
}
var anyRetType = AnyInfoType(model.DemandPlanCode, model.ID);
if (anyRetType.state.ToString() != ResultType.success.ToString())
{
return(anyRetType);
}
model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode;
//var RawDemandPlan = Repository<TbRawMaterialMonthDemandPlan>.First(p => p.DemandPlanCode==model.DemandPlanCode);
//if (RawDemandPlan!=null)
//{
// if (RawDemandPlan.RebarType == "SectionSteel")
// {
// model.Examinestatus = "审核完成";
// }
// else
// {
model.Examinestatus = "未发起";
// }
//}
try
{
using (DbTrans trans = Db.Context.BeginTransaction())
{
//添加信息
var id = Repository <TbRawMaterialMonthDemandSupplyPlan> .Insert(trans, model);
//添加明细信息
Repository <TbRawMaterialMonthDemandSupplyPlanDetail> .Insert(trans, items);
trans.Commit();
return(AjaxResult.Success(id));
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
public bool Commit()
{
DbTrans trans = Db.Context.BeginTransaction();
try
{
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message.ToString());
}
finally
{
trans.Close();
}
}
/// <summary>
/// 修改院系排序
/// </summary>
/// <param name="xml"></param>
public void SaveOrder(string xml)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
XmlDocument resXml = new XmlDocument();
resXml.XmlResolver = null;
resXml.LoadXml(xml, false);
XmlNodeList nodeList = resXml.SelectSingleNode("nodes").ChildNodes;
//取rootid
XmlNode nodes = resXml.SelectSingleNode("nodes");
XmlElement xenodes = (XmlElement)nodes;
//遍历所有子节点
foreach (XmlNode xn in nodeList)
{
XmlElement xe = (XmlElement)xn;
int id = Convert.ToInt32(xe.Attributes["id"].Value);
int pid = Convert.ToInt32(xe.Attributes["pid"].Value);
int tax = Convert.ToInt32(xe.Attributes["tax"].Value);
bool state = Convert.ToBoolean(xe.Attributes["state"].Value);
Song.Entities.Depart dep = this.GetSingle(id);
if (dep != null)
{
dep.Dep_PatId = pid;
dep.Dep_Tax = tax;
dep.Dep_State = state;
tran.Save <Depart>(dep);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
/// <summary>
/// 修改数据
/// </summary>
public AjaxResult Update(TbRawMaterialMonthDemandSupplyPlan model, List <TbRawMaterialMonthDemandSupplyPlanDetail> items)
{
if (model == null)
{
return(AjaxResult.Warning("参数错误"));
}
var anyRet = AnyInfo(model.ID);
if (anyRet.state.ToString() != ResultType.success.ToString())
{
return(anyRet);
}
var anyRetType = AnyInfoType(model.DemandPlanCode, model.ID);
if (anyRetType.state.ToString() != ResultType.success.ToString())
{
return(anyRetType);
}
try
{
using (DbTrans trans = Db.Context.BeginTransaction())//使用事务
{
//修改信息
Repository <TbRawMaterialMonthDemandSupplyPlan> .Update(trans, model, p => p.ID == model.ID);
if (items.Count > 0)
{
//删除历史明细信息
Repository <TbRawMaterialMonthDemandSupplyPlanDetail> .Delete(trans, p => p.SupplyPlanCode == model.SupplyPlanCode);
//添加明细信息
Repository <TbRawMaterialMonthDemandSupplyPlanDetail> .Insert(trans, items);
}
trans.Commit();//提交事务
return(AjaxResult.Success(model.ID));
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
public AjaxResult Add(TbFlowDefine request)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
DbTrans trans = null;
using (trans = Db.Context.BeginTransaction())
{
//判断流程编号是否重复
var isAnyNumber = Repository <TbFlowDefine> .Any(p => p.FlowCode == request.FlowCode);
if (isAnyNumber)
{
return(AjaxResult.Warning("流程编号已存在"));
}
var name = Repository <TbFlowDefine> .Any(p => p.FlowName == request.FlowName && p.FormCode == request.FormCode);
if (name)
{
return(AjaxResult.Warning("该表单已存在该流程名称"));
}
request.FlowType = "New";
var count = Repository <TbFlowDefine> .Insert(request);
if (count > 0)
{
string sql = "update TbFlowCode set CodeValue=CodeValue+1 where CodeType='FlowCode'";
Db.Context.FromSql(sql).ExecuteNonQuery();
new FlowNodeLogic().LoadingNode(request.FlowCode);
return(AjaxResult.Success());
}
return(AjaxResult.Error("操作失败"));
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="orgid">机构id</param>
/// <param name="colid">栏目分类id</param>
public void ProductDeleteAll(int orgid, int colid)
{
WhereClip wc = new WhereClip();
if (orgid > 0)
{
wc.And(Product._.Org_ID == orgid);
}
if (colid > 0)
{
wc.And(Product._.Col_Id == colid);
}
Song.Entities.Product[] entities = Gateway.Default.From <Product>().Where(wc).ToArray <Product>();
DbTrans tran = Gateway.Default.BeginTrans();
foreach (Song.Entities.Product entity in entities)
{
_ProductDelete(entity, tran);
}
}
public void SortSaveOrder(string xml)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
XmlDocument resXml = new XmlDocument();
resXml.XmlResolver = null;
resXml.LoadXml(xml, false);
XmlNodeList nodeList = resXml.SelectSingleNode("nodes").ChildNodes;
//取rootid
XmlNode nodes = resXml.SelectSingleNode("nodes");
XmlElement xenodes = (XmlElement)nodes;
//遍历所有子节点
foreach (XmlNode xn in nodeList)
{
XmlElement xe = (XmlElement)xn;
int id = Convert.ToInt32(xe.Attributes["id"].Value);
int pid = Convert.ToInt32(xe.Attributes["pid"].Value);
int tax = Convert.ToInt32(xe.Attributes["tax"].Value);
Song.Entities.KnowledgeSort nc = this.SortSingle(id);
if (nc != null)
{
nc.Kns_PID = pid;
nc.Kns_Tax = tax;
tran.Save <KnowledgeSort>(nc);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
/// <summary>
/// 新增数据
/// </summary>
public AjaxResult Insert(TbMonthCostHeSuan model, TbMonthCostHeSuanIncome incomeModel, List <TbMonthCostHeSuanCost> costModel, List <TbMonthCostHeSuanOtherCost> otherCostModel)
{
if (model == null)
{
return(AjaxResult.Warning("参数错误"));
}
//判断信息是否存在
var anyRet = AnyInfoType(model.HeSuanMonth, model.ProcessFactoryCode, model.HeSuanCode);
if (anyRet.state.ToString() != ResultType.success.ToString())
{
return(anyRet);
}
model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode;
try
{
using (DbTrans trans = Db.Context.BeginTransaction())
{
//添加信息
Repository <TbMonthCostHeSuan> .Insert(trans, model);
//添加信息
Repository <TbMonthCostHeSuanIncome> .Insert(trans, incomeModel);
//添加明细信息
Repository <TbMonthCostHeSuanCost> .Insert(trans, costModel);
if (otherCostModel.Count > 0)
{
//添加明细信息
Repository <TbMonthCostHeSuanOtherCost> .Insert(trans, otherCostModel);
}
trans.Commit();
return(AjaxResult.Success());
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
public bool LinksRemoveDown(int id)
{
//当前对象
Links current = Gateway.Default.From <Links>().Where(Links._.Lk_Id == id).ToFirst <Links>();
//当前对象父节点id;
int lsId = (int)current.Ls_Id;
//当前对象排序号
int orderValue = (int)current.Lk_Tax;
//下一个对象，即弟弟对象；弟弟不存则直接返回false;
Links next = Gateway.Default.From <Links>()
.Where(Links._.Lk_Tax > orderValue && Links._.Org_ID == current.Org_ID && Links._.Ls_Id == lsId)
.OrderBy(Links._.Lk_Tax.Asc).ToFirst <Links>();
if (next == null)
{
//如果弟对象不存在，则表示当前节点在兄弟中是老幺；即是最底端；
return(false);
}
//交换排序号
current.Lk_Tax = next.Lk_Tax;
next.Lk_Tax = orderValue;
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Save <Links>(current);
tran.Save <Links>(next);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
finally
{
tran.Close();
}
}
return(true);
}
/// <suPsary>
/// 修改
/// </suPsary>
/// <param name="entity">业务实体</param>
public void SortSave(LinksSort entity)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Save <LinksSort>(entity);
tran.Update <Links>(new Field[] { Links._.Ls_Name }, new object[] { entity.Ls_Name }, Links._.Ls_Id == entity.Ls_Id);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
finally
{
tran.Close();
}
}
}
public void ProductDelete(int identify)
{
Song.Entities.Product entity = this.ProductSingle(identify);
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
_ProductDelete(entity, tran);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="entity">业务实体</param>
private void _ProductDelete(Product entity, DbTrans tran)
{
//删除产品的留言
tran.Delete <ProductMessage>(ProductMessage._.Pd_Id == entity.Pd_Id);
// 删除产品图片
//Song.Entities.ProductPicture[] pps = this.PictureAll(entity.Pd_Id, null);
//foreach (ProductPicture p in pps)
//{
// this._PictureDelete(p);
//}
//删除产品主信息
string resPath = WeiSha.Common.Upload.Get["Product"].Physics;
WeiSha.WebControl.FileUpload.Delete("Product", entity.Pd_Logo);
//删除二维码文件
if (System.IO.File.Exists(resPath + entity.Pd_QrCode))
{
System.IO.File.Delete(resPath + entity.Pd_QrCode);
}
tran.Delete <Product>(Product._.Pd_Id == entity.Pd_Id);
}
public void SpecialDelete(int identify)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Delete <Special>(Special._.Sp_Id == identify);
tran.Delete <Special_Article>(Special_Article._.Sp_Id == identify);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity">业务实体</param>
public void TitleSave(EmpTitle entity)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Save <EmpTitle>(entity);
tran.Update <EmpAccount>(new Field[] { EmpAccount._.Title_Name }, new object[] { entity.Title_Name }, EmpAccount._.Title_Id == entity.Title_Id);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity">业务实体</param>
public void DownloadTypeSave(DownloadType entity)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Save <DownloadType>(entity);
tran.Update <Download>(new Field[] { Download._.Dty_Type }, new object[] { entity.Dty_Name }, Download._.Dty_Id == entity.Dty_Id);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
public void SortSetDefault(int orgid, int identify)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Update <TeacherSort>(new Field[] { TeacherSort._.Ths_IsDefault }, new object[] { false }, TeacherSort._.Org_ID == orgid);
tran.Update <TeacherSort>(new Field[] { TeacherSort._.Ths_IsDefault }, new object[] { true }, TeacherSort._.Ths_ID == identify);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
public void PictureSetCover(string uid, int pid)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
try
{
//去除当前相册的封面
tran.Update <Picture>(new Field[] { Picture._.Pic_IsCover }, new object[] { false }, Picture._.Pic_Uid == uid);
//设置当前图片封面
tran.Update <Picture>(new Field[] { Picture._.Pic_IsCover }, new object[] { true }, Picture._.Pic_Id == pid);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity">业务实体</param>
public void SortSave(AddressSort entity)
{
using (DbTrans trans = Gateway.Default.BeginTrans())
{
try
{
trans.Save <AddressSort>(entity);
trans.Update <AddressList>(new Field[] { AddressList._.Ads_Name }, new object[] { entity.Ads_Name }, AddressList._.Ads_Id == entity.Ads_Id);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
trans.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteRoleAndPurviews(string id)
{
try
{
BaseService <cmsRolePurview> rps = new BaseService <cmsRolePurview>();
DbTrans trans = BeginTransaction();
DeleteModel(id);
rps.SetTransaction(trans);
rps.DeleteModels(cmsRolePurview._.RoleId == id);
Commit();
CloseTransaction();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除，按主键ID；
/// </summary>
/// <param name="identify">实体的主键</param>
public void ThemeDelete(int identify)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Delete <ProfitSharing>(ProfitSharing._.Ps_ID == identify);
tran.Delete <ProfitSharing>(ProfitSharing._.Ps_PID == identify);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
finally
{
tran.Close();
}
}
}
/// <summary>
/// 创建人：李沈杰
/// 描 述：修改密码
/// </summary>
/// <param name="UserID">用户名</param>
/// <returns></returns>
public bool UpdateProjectInfo(string UserID, string UserPassword)
{
ProjectInfo opjson = new ProjectInfo();
opjson.UserPassword = UserPassword;
//事务定义执行
DbTrans trans = DB_Conn1.Context.BeginTransaction();
try
{
DB_Conn1.Context.Update(trans, opjson, ProjectInfo._.UserID == UserID);
trans.Commit();
return(true);
}
catch
{
trans.Rollback();
return(false);
}
}
/// <suPsary>
/// 删除
/// </suPsary>
/// <param name="entity">业务实体</param>
public void SortDelete(LinksSort entity)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Delete <LinksSort>(LinksSort._.Ls_Id == entity.Ls_Id);
tran.Delete <Links>(Links._.Ls_Id == entity.Ls_Id);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
finally
{
tran.Close();
}
}
}
public void TrpDelete(string uid)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Delete <ExamGroup>(ExamGroup._.Exam_UID == uid);
tran.Delete <TrPlan>(TrPlan._.TrP_UID == uid);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
public void SortSave(KnowledgeSort entity)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
tran.Save <KnowledgeSort>(entity);
tran.Update <Knowledge>(new Field[] { Knowledge._.Kns_Name }, new object[] { entity.Kns_Name }, Knowledge._.Kns_ID == entity.Kns_ID);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
public AjaxResult Insert(IEnumerable <TbFlowNode> list)
{
DbTrans trans = null;
try
{
using (trans = Db.Context.BeginTransaction())
{
FlowNodeDA.Insert(trans, list);
trans.Commit();
return(AjaxResult.Success());
}
}
catch (Exception)
{
if (trans != null)
{
trans.Rollback();
}
return(AjaxResult.Error());
}
}
protected void btnAddQuestion_Click(object sender, EventArgs e)
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
if (ValidQuestion() == true) {
if (SaveQuestionnaire(trans) == true){
QuestionnaireQuestionsPara para = new QuestionnaireQuestionsPara();
para.ID = Convert.ToInt64(txtQuestionID.Text);
para.QUESTIONNAIRE_SECTION_ID = Convert.ToInt64(cmbSectionID.SelectedValue);
para.QUESTION_NAME = txtQuestionName.Text.Trim();
para.CHOICE_TYPE_ID = Convert.ToInt64(cmbChoiceTypeID.SelectedValue);
para.QUESTION_POINT = Convert.ToDouble(txtPoint.Text.Trim());
para.IS_REQUIRE = (chkRequire.Checked ? 'Y' : 'N');
QuestionnaireENG eng = new QuestionnaireENG();
bool ret = eng.SaveQuestion(para, trans, Config.GetUserName());
if (ret == true)
{
if (SaveQuestionChoice(eng.QUESTION_ID, trans) == true)
{
trans.CommitTransaction();
txtQuestionID.Text = eng.QUESTION_ID.ToString();
SetQuestionnaireForm(Convert.ToInt64(txtID.Text));
ClearQuestionForm();
Config.SetAlert("บันทึกข้อมูลเรียบร้อย", this);
}
else {
trans.RollbackTransaction();
Config.SetAlert(eng.ErrorMessage, this);
}
}
else {
trans.RollbackTransaction();
Config.SetAlert(eng.ErrorMessage, this);
}
}
}
}
public DataTable GetQuestionListDT(long vID, DbTrans trans) {
VQuestionListLinq lnq = new VQuestionListLinq();
DataTable dt = lnq.GetDataList("id = '" + vID + "'", "questionnaire_section_id, questionnaire_question_id", trans.Trans);
return dt;
}
public bool SaveQuestionnaire(QuestionnairePara para, DbTrans trans, string UserID) {
bool ret = false;
QuestionnaireLinq lnq = new QuestionnaireLinq();
if (para.ID != 0)
lnq.GetDataByPK(para.ID, trans.Trans);
lnq.QUESTIONNAIRE_NAME = para.QUESTIONNAIRE_NAME;
lnq.OBJECTIVE = para.OBJECTIVE;
lnq.DESCRIPTION = para.DESCRIPTION;
lnq.ACTIVE = para.ACTIVE;
if (lnq.ID != 0)
ret = lnq.UpdateByPK(UserID, trans.Trans);
else
ret = lnq.InsertData(UserID, trans.Trans);
if (ret == false)
_err = lnq.ErrorMessage;
else
_questionnaire_id = lnq.ID;
return ret;
}
public SectionTypePara GetSectionTypePara(long SectionID, DbTrans trans) {
SectionTypeLinq lnq = new SectionTypeLinq();
return lnq.GetParameter(SectionID, trans.Trans);
}
public bool SaveAnswer(AnswerPara para, string UserID, DbTrans trans) {
bool ret = false;
try{
AnswerLinq lnq = new AnswerLinq();
if(para.ID != 0){
lnq.GetDataByPK(para.ID,trans.Trans);
}
lnq.ANSWER_NAME=para.ANSWER_NAME;
lnq.QUESTIONNAIRE_ID=para.QUESTIONNAIRE_ID;
lnq.ANSWER_DATE = para.ANSWER_DATE;
lnq.SESSION_ID = para.SESSION_ID;
if (lnq.ID != 0)
{
ret = lnq.UpdateByPK(UserID, trans.Trans);
}
else {
ret = lnq.InsertData(UserID, trans.Trans);
}
if (ret == false)
{
_err = lnq.ErrorMessage;
}
else {
_answer_id = lnq.ID;
}
}catch (Exception ex){
_err=ex.Message;
}
return ret;
}
public ChoiceTypePara GetChoiceTypePara(long ChoiceTypeID, DbTrans trans) {
ChoiceTypeLinq lnq = new ChoiceTypeLinq();
ChoiceTypePara para = lnq.GetParameter(ChoiceTypeID, trans.Trans);
return para;
}
public object ExecuteScalar(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null) cmd.Transaction = t.Transaction;
try
{
object ret = cmd.ExecuteScalar();
if (ret == DBNull.Value) ret = null;
return ret;
}
catch
{
throw;
}
}
public DbDataReader ExecuteReader(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null) cmd.Transaction = t.Transaction;
try
{
DbDataReader reader = cmd.ExecuteReader();
return reader;
}
catch
{
throw;
}
}
private void SetQuestionnaireForm(long vID)
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
QuestionnaireENG eng = new QuestionnaireENG();
QuestionnairePara para = eng.GetQuestionnarePara(vID, trans);
txtID.Text = para.ID.ToString();
txtQuestionnaireName.Text = para.QUESTIONNAIRE_NAME;
txtObjective.Text = para.OBJECTIVE;
txtDesc.Text = para.DESCRIPTION;
chkActive.Checked = (para.ACTIVE == 'Y');
if (para.ID != 0){
TabContainer1.Visible = true;
}
DataTable dt = eng.GetQuestionListDT(vID, trans);
if (dt.Rows.Count > 0) {
gvQuestion.DataSource = dt;
gvQuestion.DataBind();
}
trans.CommitTransaction();
}
private bool SaveQuestionnaire(DbTrans trans)
{
bool ret = false;
QuestionnairePara para = new QuestionnairePara();
para.ID = Convert.ToInt64(txtID.Text);
para.QUESTIONNAIRE_NAME = txtQuestionnaireName.Text.Trim();
para.OBJECTIVE = txtObjective.Text.Trim();
para.DESCRIPTION = txtDesc.Text.Trim();
para.ACTIVE = (chkActive.Checked ? 'Y' : 'N');
QuestionnaireENG eng = new QuestionnaireENG();
if (eng.SaveQuestionnaire(para, trans, Config.GetUserName()) == true)
{
ret = true;
txtID.Text = eng.QUESTIONNAIRE_ID.ToString();
}
else
{
ret = false;
_err = eng.ErrorMessage;
}
return ret;
}
private bool SaveQuestionChoice(long QuestionID, DbTrans trans)
{
bool ret = true;
if (cmbChoiceTypeID.SelectedValue == "1" || cmbChoiceTypeID.SelectedValue == "2") {
if (Session[SessChoiceList] != null)
{
DataTable dt = (DataTable)Session[SessChoiceList];
QuestionnaireENG eng = new QuestionnaireENG();
ret = eng.SaveQuestionChoice(dt, trans, Config.GetUserName(), QuestionID);
}
else
ret = false;
}
return ret;
}
protected void cmbChoiceTypeID_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbChoiceTypeID.SelectedValue == "1" || cmbChoiceTypeID.SelectedValue == "2") {
Panel3.Visible = true;
lblChoceTypeText.Text = cmbChoiceTypeID.SelectedText;
DbTrans trans = new DbTrans();
trans.CreateTransaction();
QuestionnaireENG eng = new QuestionnaireENG();
DataTable dt = eng.GetChoiceList(Convert.ToInt64(txtQuestionID.Text), trans);
//DataTable dt = eng.GetChoiceList(1, trans);
if (dt.Rows.Count > 0) {
gvChoiceList.DataSource = dt;
gvChoiceList.DataBind();
}
trans.CommitTransaction();
}else
Panel3.Visible = false;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidQuestionnaire() == true) {
DbTrans trans = new DbTrans();
trans.CreateTransaction();
if (SaveQuestionnaire(trans) == true)
{
trans.CommitTransaction();
Config.SetAlert("บันทึกข้อมูลเรียบร้อย", this);
TabContainer1.Visible = true;
}
else {
trans.RollbackTransaction();
Config.SetAlert(_err, this);
}
}
}
public DataTable GetQuestionnaireQuestionList(long QuestionnaireSectionID, DbTrans trans) {
QuestionnaireQuestionsLinq lnq = new QuestionnaireQuestionsLinq();
return lnq.GetDataList("questionnaire_section_id = " + QuestionnaireSectionID, "id", trans.Trans);
}
public bool SaveAnswerResult(AnswerResultPara para, string UserID, DbTrans trans) {
bool ret = false;
try
{
AnswerResultLinq lnq = new AnswerResultLinq();
if(para.ID != 0){
lnq.GetDataByPK(para.ID,trans.Trans);
}
lnq.ANSWER_ID = para.ANSWER_ID;
lnq.QUESTIONNAIRE_QUESTION_ID = para.QUESTIONNAIRE_QUESTION_ID;
lnq.CHOICE_TYPE_ID = para.CHOICE_TYPE_ID;
lnq.RESULT_CHOICE_NAME = para.RESULT_CHOICE_NAME;
lnq.POINT = para.POINT;
if (lnq.ID != 0)
{
ret = lnq.UpdateByPK(UserID, trans.Trans);
}
else {
ret = lnq.InsertData(UserID, trans.Trans);
}
if (ret == false) {
_err = lnq.ErrorMessage;
}
}
catch (Exception ex) {
_err = ex.Message;
}
return ret;
}
public DataTable ExecuteDataTable(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null) cmd.Transaction = t.Transaction;
try
{
using (DbDataAdapter dbDataAdapter = dbFactory.CreateDataAdapter())
{
dbDataAdapter.SelectCommand = cmd;
DataTable dataTable = new DataTable();
dbDataAdapter.Fill(dataTable);
return dataTable;
}
}
catch
{
throw;
}
}
public DataTable GetQuestionConfig(long QuestionID, DbTrans trans) {
QuestionChoiceConfigLinq lnq = new QuestionChoiceConfigLinq();
return lnq.GetDataList("questionnaire_question_id = " + QuestionID, "id", trans.Trans);
}
public int ExecuteNonQuery(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null) cmd.Transaction = t.Transaction;
try
{
int ret = cmd.ExecuteNonQuery();
return ret;
}
catch
{
throw;
}
}
public QuestionnaireQuestionsChoicePara GetQuestionnaireQuestionChoicePara(long vID, DbTrans trans) {
QuestionnaireQuestionsChoiceLinq lnq = new QuestionnaireQuestionsChoiceLinq();
return lnq.GetParameter(vID, trans.Trans);
}
public QuestionnaireQuestionsPara GetQuestionQuestionPara(long QuestionID, DbTrans trans)
{
QuestionnaireQuestionsLinq lnq = new QuestionnaireQuestionsLinq();
return lnq.GetParameter(QuestionID, trans.Trans);
}
public bool SaveQuestionChoice(DataTable dt, DbTrans trans, string LoginName,long QuestionID) {
bool ret = false;
if (dt.Rows.Count > 0) {
foreach (DataRow dr in dt.Rows) {
QuestionnaireQuestionsChoiceLinq lnq = new QuestionnaireQuestionsChoiceLinq();
if (Convert.ToInt64(dr["id"]) != 0)
lnq.GetDataByPK(Convert.ToInt64(dr["id"]),trans.Trans);
lnq.QUESTIONNAIRE_QUESTIONS_ID = QuestionID;
lnq.CHOICE_NAME = dr["choice_name"].ToString();
lnq.IS_DEFAULT = Convert.ToChar(dr["is_default"]);
lnq.POINT = Convert.ToDouble(dr["point"]);
lnq.IS_OTHER = Convert.ToChar(dr["is_other"]);
if (lnq.ID != 0)
ret = lnq.UpdateByPK(LoginName, trans.Trans);
else
ret = lnq.InsertData(LoginName, trans.Trans);
if (ret == false)
{
_err = lnq.ErrorMessage;
break;
}
}
}
return ret;
}
public bool SaveQuestionnaireSection(QuestionnaireSectionPara para, DbTrans trans, string UserID) {
bool ret = false;
QuestionnaireSectionLinq lnq = new QuestionnaireSectionLinq();
if (para.ID != 0)
lnq.GetDataByPK(para.ID, trans.Trans);
lnq.QUESTIONNAIRE_ID = para.QUESTIONNAIRE_ID;
lnq.SECTION_NAME = para.SECTION_NAME;
lnq.DESCRIPTION = para.DESCRIPTION;
lnq.SECTION_TYPE_ID = para.SECTION_TYPE_ID;
lnq.CHOICE_QTY = para.CHOICE_QTY;
if (lnq.ID != 0)
ret = lnq.UpdateByPK(UserID, trans.Trans);
else
ret = lnq.InsertData(UserID, trans.Trans);
if (ret == false)
_err = lnq.ErrorMessage;
else
_questionnaire_section_id = lnq.ID;
return ret;
}
public bool SaveQuestion(QuestionnaireQuestionsPara para, DbTrans trans, string UserID) {
bool ret = false;
QuestionnaireQuestionsLinq lnq = new QuestionnaireQuestionsLinq();
if (para.ID != 0)
lnq.GetDataByPK(para.ID, trans.Trans);
lnq.QUESTIONNAIRE_SECTION_ID = para.QUESTIONNAIRE_SECTION_ID;
lnq.QUESTION_NAME = para.QUESTION_NAME;
lnq.CHOICE_TYPE_ID = para.CHOICE_TYPE_ID;
lnq.QUESTION_POINT = para.QUESTION_POINT;
lnq.IS_REQUIRE = para.IS_REQUIRE;
if (lnq.ID != 0)
ret = lnq.UpdateByPK(UserID, trans.Trans);
else
ret = lnq.InsertData(UserID, trans.Trans);
if (ret == false)
_err = lnq.ErrorMessage;
else
_question_id = lnq.ID;
return ret;
}
private void SetSectionList()
{
if (txtID.Text != "0")
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
QuestionnaireENG eng = new QuestionnaireENG();
DataTable dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(txtID.Text), trans);
if (dt.Rows.Count > 0) {
gvQuestionnaireSection.DataSource = dt;
gvQuestionnaireSection.DataBind();
}
trans.CommitTransaction();
}
}
public DataTable GetSectionTypeList(long QuestionnaireID, DbTrans trans) {
SectionTypeLinq lnq = new SectionTypeLinq();
return lnq.GetDataList("1=1", "id", trans.Trans);
}
private void SetSectionTypeCombo()
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
QuestionnaireENG eng = new QuestionnaireENG();
DataTable dt = eng.GetSectionTypeList(Convert.ToInt64(txtID.Text), trans);
if (dt.Rows.Count > 0)
{
cmbSectionTypeID.SetItemList(dt, "section_type_name", "id");
}
trans.CommitTransaction();
}
public DataTable GetChoiceList(long QuestionID, DbTrans trans) {
QuestionnaireQuestionsChoiceLinq lnq = new QuestionnaireQuestionsChoiceLinq();
return lnq.GetDataList("questionnaire_questions_id = " + QuestionID, "id", trans.Trans);
}
