public static void DeleteAllSupplier()
{
try
{
QueryAgent agent = new QueryAgent();
try
{
string queryString = "select top 1 a.ContractName, b.SupplierName from Contract a, Supplier b where a.SupplierCode = b.SupplierCode";
DataSet set = agent.ExecSqlForDataSet(queryString);
try
{
if (set.Tables[0].Rows.Count > 0)
{
throw new Exception(string.Format("供应商“{0}”已生成合同，不能删除", ConvertRule.ToString(set.Tables[0].Rows[0]["SupplierName"])));
}
}
finally
{
set.Dispose();
}
agent.ExecuteSql("delete SupplierSubjectSet");
agent.ExecuteSql("delete Supplier");
}
finally
{
agent.Dispose();
}
}
catch (Exception exception)
{
throw exception;
}
}
public static void ClearDtsPay(string ProjectCode)
{
QueryAgent agent = new QueryAgent();
try
{
try
{
agent.ExecuteSql("exec sp_dts_clear_pay '" + ProjectCode + "'");
string projectCode = ProjectRule.GetSalProjectCode(ProjectCode);
if ((projectCode != "") || (ProjectCode == ""))
{
new SalService().ClearSalImpFlag(projectCode);
}
}
catch (Exception exception)
{
throw exception;
}
}
finally
{
agent.Dispose();
}
}
/// <summary>
/// 载入数据
/// </summary>
private void LoadData()
{
string strIsAll = "0";
EntityData entityNotice = RemindDAO.GetNoticeByCode(strNoticeCode);
if (entityNotice.HasRecord())
{
if (entityNotice.GetInt("status").ToString() != "0")
{
if (entityNotice.GetInt("Type") == 99)
{
trNotice.Visible = false;
}
this.lblNoticeClass.Text = Server.HtmlEncode(entityNotice.GetString("NoticeClass"));//新加通知类型（测试正确删除此注释）
this.lblTitle.Text = Server.HtmlEncode(entityNotice.GetString("Title"));
this.lbSubmitname.Text = RmsPM.BLL.SystemRule.GetUserName(entityNotice.GetString("SubmitPerson").ToString()).ToString();
this.lblSubmitDate.Text = entityNotice.GetDateTimeOnlyDate("SubmitDate");
this.divContent.InnerHtml = entityNotice.GetString("Content").Replace("\n", "<br>").Replace("\r", " ");
strIsAll = entityNotice.GetString("IsAll");
//待修改
this.lbLastUpdate.Text = RmsPM.BLL.SystemRule.GetUserName(entityNotice.GetString("UserCode").ToString()).ToString() + " 于 " + entityNotice.GetDateTimeOnlyDate("UpdateDate") + "修改";
}
else
{
Response.Write(JavaScript.ScriptStart);
Response.Write("window.alert('通知已删除');");
Response.Write("window.close();");
Response.Write(JavaScript.ScriptEnd);
}
}
if (strIsAll == "0")
{
string strUsers = "";
string strUserNames = "";
string strStations = "";
string strStationNames = "";
BLL.ResourceRule.GetAccessRange(this.strNoticeCode, "0801", "080104", ref strUsers, ref strUserNames, ref strStations, ref strStationNames);
this.lblUser.Text = strUserNames + "，" + strStationNames;
this.lblUser.Text = BLL.StringRule.CutRepeat(this.lblUser.Text);
}
else
{
this.lblUser.Text = "全体人员";
}
//记录该用户已经读了该信息
User u = (User)Session["User"];
string strSelect = "select * from UserLookedNotice where noticecode='" + strNoticeCode + "' and usercode='" + u.UserCode + "'";
string strInsert = "insert into UserLookedNotice (noticecode,usercode) values ('" + strNoticeCode + "','" + u.UserCode + "')";
string strDelete = "Delete from UserLookedNotice where noticecode='" + strNoticeCode + "' and usercode='" + u.UserCode + "'";
QueryAgent qa = new QueryAgent();
DataSet ds = qa.ExecSqlForDataSet(strSelect);
if (ds.Tables[0].Rows.Count <= 0)
{
qa.ExecuteSql(strInsert);
}
qa.Dispose();
entityNotice.Dispose();
}
public void Delete(IncomeBugetModel ibModel)
{
string format = "DELETE FROM RptFinIn WHERE SYSTEMID='{0}'";
QueryAgent agent = new QueryAgent();
agent.ExecuteSql(string.Format(format, ibModel.ID));
agent.Dispose();
}
public void UpDate(IncomeBugetModel ibModel)
{
string format = "UPDATE RptFinIn SET MONEY={0} WHERE SYSTEMID='{1}'";
QueryAgent agent = new QueryAgent();
agent.ExecuteSql(string.Format(format, ibModel.Money * 10000M, ibModel.ID));
agent.Dispose();
}
protected void btnSave_ServerClick(object sender, System.EventArgs e)
{
try
{
string Hint = "";
if (!CheckValid(ref Hint))
{
Response.Write(Rms.Web.JavaScript.Alert(true, Hint));
return;
}
EntityData entity = DAL.EntityDAO.PaymentDAO.GetVoucherTypeByCode(this.txtOldCode.Value);
DataRow dr = null;
bool isNew = !entity.HasRecord();
if (entity.HasRecord())
{
dr = entity.CurrentRow;
}
else
{
dr = entity.GetNewRecord();
dr["Code"] = this.txtCode.Value;
entity.AddNewRecord(dr);
}
// dr["Code"] = this.txtCode.Value;
dr["Name"] = this.txtName.Value;
DAL.EntityDAO.PaymentDAO.SubmitAllVoucherType(entity);
entity.Dispose();
//修改凭证编号
if ((!isNew) && (this.txtCode.Value != this.txtOldCode.Value))
{
string sql = string.Format("update VoucherType set Code = '{0}' where Code = '{1}'", this.txtCode.Value, this.txtOldCode.Value);
QueryAgent qa = new QueryAgent();
try
{
qa.ExecuteSql(sql);
}
finally
{
qa.Dispose();
}
}
this.txtOldCode.Value = this.txtCode.Value;
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "保存出错：" + ex.Message));
return;
}
CloseWindow();
}
public static void ExecuteSqlFromDB(string sql)
{
QueryAgent agent = new QueryAgent();
try
{
agent.ExecuteSql(sql);
}
catch (Exception exception)
{
throw exception;
}
}
public static void InsertDepartMent(string BiddingPrejudicationCode, string BiddingSupplierCode)
{
try
{
QueryAgent agent = new QueryAgent();
string queryString = "insert Bidding_SupplierDepartmentIdea(BiddingSupplierCode,BiddingPrejudicationCode) values ('" + BiddingSupplierCode + "','" + BiddingPrejudicationCode + "')";
agent.ExecuteSql(queryString);
agent.Dispose();
}
catch (Exception exception)
{
throw exception;
}
}
public static void UpDataPrejudicationCode(string newBiddingPrejudicationCode, string olBiddingPrejudicationCode)
{
try
{
string queryString = "update Bidding_SupplierDepartmentIdea set BiddingPrejudicationCode='" + newBiddingPrejudicationCode + "' where BiddingPrejudicationCode='" + olBiddingPrejudicationCode + "'";
QueryAgent agent = new QueryAgent();
agent.ExecuteSql(queryString);
agent.Dispose();
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 保存邮件发送历史记录
/// </summary>
/// <param name="EmailType">邮件类型</param>
/// <param name="MasterCode">相关主键</param>
/// <param name="EmailTitle">邮件主题</param>
/// <param name="Receiver">接受者</param>
/// <param name="Sender">发送者</param>
/// <param name="EmailContent">邮件内容</param>
/// <param name="SendDate">发送日期</param>
private static void EmailHistoryInsert(string EmailType, string MasterCode, string EmailTitle, string Receiver, string Sender, string EmailContent, DateTime SendDate)
{
string SqlStr = "";
SqlStr = "Insert into EmailHistory values (";
SqlStr += "'" + DAL.EntityDAO.SystemManageDAO.GetNewSysCode("EmailHistory") + "'";
SqlStr += ",'" + EmailType + "','" + MasterCode + "','" + EmailTitle + "'";
SqlStr += ",'" + Receiver + "','" + Sender + "','" + EmailContent + "','" + DateTime.Now + "'";
SqlStr += ")";
QueryAgent qa = new QueryAgent();
qa.ExecuteSql(SqlStr);
qa.Dispose();
}
public void Insert(IncomeBugetModel ibModel)
{
if (string.IsNullOrEmpty(ibModel.ID))
{
if (!string.IsNullOrEmpty(ibModel.Money.ToString()))
{
string format = "INSERT INTO RptFinIn(SYSTEMID,VERID,IYEAR,IMONTH,MONEY,PROJECTCODE) VALUES('{0}',1,{1},{2},{3},'{4}')";
string newSysCode = SystemManageDAO.GetNewSysCode("RptFinIn");
QueryAgent agent = new QueryAgent();
agent.ExecuteSql(string.Format(format, new object[] { newSysCode, ibModel.Year, ibModel.Month, ibModel.Money * 10000M, ibModel.ProjectCode }));
agent.Dispose();
}
}
else
{
this.UpDate(ibModel);
}
}
public static void DeleteAllSubjectBySet(string subjectSetCode)
{
try
{
QueryAgent agent = new QueryAgent();
try
{
agent.ExecuteSql(string.Format("delete Subject where SubjectSetCode = '{0}'", subjectSetCode));
}
finally
{
agent.Dispose();
}
}
catch (Exception exception)
{
throw exception;
}
}
public static void DeleteAllMaterialCost()
{
try
{
QueryAgent agent = new QueryAgent();
try
{
agent.ExecuteSql("delete MaterialCost");
}
finally
{
agent.Dispose();
}
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 重新生成序列号、密码并邮件通知供应商
/// </summary>
/// <param name="BiddingEmitCode">发标编号</param>
/// <param name="EmailTemplateFileName">邮件模板XML文件名</param>
/// <returns></returns>
public static void Emit_LastSend(string BiddingEmitCode, string EmailTemplateFileName)
{
QueryAgent qa = new QueryAgent();
string SqlStr = "";
SqlStr = string.Format("select BiddingEmitToCode from BiddingEmitTo where BiddingEmitCode={0}", BiddingEmitCode);
DataTable dt = qa.ExecSqlForDataSet(SqlStr).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string pwd = NewPassword();
string sn = NewBiddingSN();
string sql = string.Format("Update BiddingEmitTo set SerialNum='" + sn + "',SuppPwd='" + pwd + "' where BiddingEmitToCode={0}", dt.Rows[i]["BiddingEmitToCode"].ToString());
qa.ExecuteSql(sql);
}
}
dt.Dispose();
Emit_SendMail(BiddingEmitCode, EmailTemplateFileName);
}
public static void InsertDepartMent(string BiddingPrejudicationCode)
{
try
{
DataTable table = Get_V_BiddingSupplier(BiddingPrejudicationCode);
DataTable table2 = Get_Bidding_SupplierDepartmentIdea(BiddingPrejudicationCode);
DataView view = new DataView(table);
QueryAgent agent = new QueryAgent();
StringBuilder builder = new StringBuilder();
foreach (DataRowView view2 in view)
{
builder.Append("insert Bidding_SupplierDepartmentIdea(BiddingSupplierCode,BiddingPrejudicationCode) values ('" + view2["BiddingSupplierCode"].ToString() + "','" + view2["BiddingPrejudicationCode"].ToString() + "') ");
}
agent.ExecuteSql(builder.ToString());
table2 = Get_Bidding_SupplierDepartmentIdea(BiddingPrejudicationCode);
agent.Dispose();
}
catch (Exception exception)
{
throw exception;
}
}
public static void DeleteSubject(string subjectCode, string subjectSetCode)
{
try
{
EntityData entity = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode);
SubjectDAO.DeleteSubject(entity);
entity.Dispose();
QueryAgent agent = new QueryAgent();
try
{
agent.ExecuteSql(string.Format("delete Subject where SubjectSetCode = '{0}' and SubjectCode like '{1}%'", subjectSetCode, subjectCode));
}
finally
{
agent.Dispose();
}
}
catch (Exception exception)
{
throw exception;
}
}
//更新数据
private bool UpdataData()
{
//保存通知
EntityData entityNotice = RemindDAO.GetNoticeByCode(this.strNoticeCode);
DataRow dr;
if (entityNotice.HasRecord())
{
dr = entityNotice.CurrentRow;
if (this.txtTitle.Value.Trim() == "")
{
return(false);
}
if (this.taContent.Value.Trim() == string.Empty)
{
return(false);
}
dr["NoticeCode"] = this.strNoticeCode;
//新加通知类型（测试正确后删除此注释）
if (this.up_sPMNameLower == "tianyangoa")
{
dr["NoticeClass"] = this.DDLNoticeClass.Value.Trim();
dr["Title"] = this.txtTitle.Value.Trim();
if (entityNotice.GetInt("Type") != 99)
{
if (this.DDLNoticeClass.Value.Trim() == "")
{
return(false);
}
}
}
dr["Title"] = this.txtTitle.Value.Trim();
dr["UpdateDate"] = DateTime.Now;
dr["UserCode"] = this.user.UserCode;
//dr["EnableDate"] = this.dtbShowDate.Value;
// dr["SubmitPerson"] = base.user.UserCode;
// dr["SubmitDate"] = DateTime.Now.ToShortDateString();
dr["Content"] = this.taContent.Value.ToString();
// 保存资源，保存权限
string strUser = this.txtUsers.Value.Trim();
string strStation = this.txtStations.Value.Trim();
// 没有选择人员则向全体发布
if (strUser.Length < 1 && strStation.Length < 1)
{
strUser = this.GetAllUser();
dr["IsAll"] = "1";
}
else
{
dr["IsAll"] = "0";
}
dr["status"] = "1";
ArrayList arOperator = new ArrayList();
this.SaveRS(arOperator, RmsPM.BLL.StringRule.CutRepeat(strUser), RmsPM.BLL.StringRule.CutRepeat(strStation), "080104"); // 一般通知查看权限
this.SaveRS(arOperator, base.user.UserCode, "", "080102,080103,080104"); // 修改和删除
if (arOperator.Count > 0)
{
RmsPM.BLL.ResourceRule.SetResourceAccessRange(this.strNoticeCode, "0801", "", arOperator, false);
}
}
RemindDAO.UpdateNotice(entityNotice);
entityNotice.Dispose();
// 保存附件
this.myAttachMentAdd.SaveAttachMent(this.strNoticeCode);
//修改保存后这条信息又成为新信息，就是没有读过的信息
User u = (User)Session["User"];
string strDelete = "Delete from UserLookedNotice where noticecode='" + this.strNoticeCode + "' and usercode='" + u.UserCode + "'";
QueryAgent qa = new QueryAgent();
qa.ExecuteSql(strDelete);
qa.Dispose();
return(true);
}
