private void button1_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(sectionstart.Value) >= Convert.ToInt32(sectionend.Value))
{
MessageBox.Show(SectionStartEndError, String4Report.GetString("Report"));
return;
}
if (Convert.ToInt32(tickstart.Value) >= Convert.ToInt32(tickend.Value))
{
MessageBox.Show(TickStartEndError, String4Report.GetString("Report"));
return;
}
_gauge.LineColor = linecolor.BackColor;
_gauge.FontColor = fontcolor.BackColor;
_gauge.TickColor = tickcolor.BackColor;
_gauge.SectionStart = Convert.ToInt32(sectionstart.Value);
_gauge.SectionEnd = Convert.ToInt32(sectionend.Value);
_gauge.TickStart = Convert.ToInt32(tickstart.Value);
_gauge.TickEnd = Convert.ToInt32(tickend.Value);
_gauge.TextLoc = Convert.ToInt32(textloc.Value);
_gauge.MaxTick = Convert.ToDouble(maxtick.Value);
//_gauge.MinTick = Convert.ToDouble(mintick.Value);
_gauge.GaugeColor = backcolor.BackColor;
_gauge.bSemiCircle = rbsemicircle.Checked;
this.DialogResult = DialogResult.OK;
this.Close();
}
private string GetDefaultName(string localeId)
{
return(string.Format(
"{0}({1})",
String4Report.GetString("未命名分组", localeId),
Util.GetTimeExtension(this._createTime, localeId)));
}
protected override string GetWhereBy(string field, string whereFromAuthSrv)
{
if (_bhandled)
{
return(null);
}
_bhandled = true;
//if (field.ToLower() == "cdepname"
// || field.ToLower() == String4Report.GetString("U8.AA.Report.0579").ToLower())
//return string.Format(
// " (Department.cDepCode in ({0}) or isnull(Department.cDepCode,'')='') ", whereFromAuthSrv);
if (field.ToLower() == "cdepname")
{
string wh = string.Format(
"select cdepname from department where cdepcode in ({0})",
whereFromAuthSrv);
return(string.Format(
"(cdepname in ({0}) or isnull(cdepname,'') = '')", wh));
}
//return string.Format(
// " (cDepCode in ({0}) or isnull(cDepCode,'')='') ", whereFromAuthSrv);
else if (field.ToLower() == String4Report.GetString("U8.AA.Report.0579").ToLower())
{
string wh = string.Format(
"select cdepname from department where cdepcode in ({0})",
whereFromAuthSrv);
return(string.Format(
"({0} in ({1}) or isnull({0},'') = '')", field, wh));
}
//return string.Format(
// " ({0} in ({1}) or isnull({0},'')='') ", String4Report.GetString("U8.AA.Report.0578").ToLower(), whereFromAuthSrv);
return(string.Format("({0} in ({1}) or isnull({0} ,'') ='' )", field, whereFromAuthSrv));
}
public RowAuthPickerDepartment()
{
this.Key = "Department";
this.AddHitKey(new string[] {
"cDepCode", "cAccDep", "cdept_id",
"cDept_Num",
"cDeptCode", "cDeptID", "DeptID", "sDeptNum", "sNum",
String4Report.GetString("U8.AA.Report.0579"), "cDepName",
String4Report.GetString("U8.AA.Report.0578"),
});
}
private string getDataSourceXml(object _object)
{
Report report = null;
if (_object is Cell)
{
(_object as Cell).GetReport();
report = (_object as Cell).Report;
}
else if (_object is Report)
{
report = _object as Report;
}
else
{
return(null);
}
if (report.GridDetailCells == null)
{
throw new Exception(String4Report.GetString("U8.UAP.Services.ReportColorSet.不支持操作"));
}
DataSources dss = report.DataSources;
//report.GridDetailCells.GetBySource(
XmlDocument doc = new XmlDocument();
XmlElement root = doc.CreateElement("cols");
XmlElement ele;
doc.AppendChild(root);
foreach (string name in dss.Keys)
{
DataSource ds = dss[name];
ele = doc.CreateElement("col");
ele.SetAttribute("id", "id");
//
// pengzhzh
//
//Cell c = report.GridDetailCells.GetBySource(ds.Name);
//if (c != null)
//{
// ele.SetAttribute("fld", c.Name);
//}
//else
//{
// ele.SetAttribute("fld", ds.Name);
//}
ele.SetAttribute("fld", ds.Name);
ele.SetAttribute("name", ds.Caption);
ele.SetAttribute("datatype", GetNodeType(ds.Type));
root.AppendChild(ele);
}
return(doc.InnerXml);
}
public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
{
IWindowsFormsEditorService edSvc = (IWindowsFormsEditorService)provider.GetService(typeof(IWindowsFormsEditorService));
if (edSvc == null)
{
return(value);
}
string datasourcexml;
try
{
datasourcexml = getDataSourceXml(context.Instance);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, String4Report.GetString("Report"));
return(value);
}
string colsxml = getColsXml(context.Instance);
string configXml = value.ToString();
//string errs = "";
//clsColorSet cs = new clsColorSet();
//if (!cs.ColorSet(ClientReportContext.Login.U8LoginClass, datasourcexml, colsxml, ref configXml, false, ref errs))
//{
// if (errs != "")
// {
// MessageBox.Show(errs);
// return "";
// }
// else
// return value;
//}
//return configXml;
//【pengzhzh】修改编辑类型为下拉列表
if (context != null && provider != null)
{
clsColorSet cs = new clsColorSet();
try
{
cs.ShowFormatCondition(edSvc, ClientReportContext.Login.U8LoginClass, datasourcexml, colsxml, ref configXml, false);
return(configXml);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, String4Report.GetString("Report"));
}
}
return(value);
}
/// <summary>
/// 获取过滤项信息的xml串
/// </summary>
/// <param name="filterMeta">过滤项元数据</param>
/// <returns>返回过滤项信息的xml串</returns>
public string GetFilterConditionXml()
{
string sql = string.Format(
@"select DataSourceID,FunctionName,DataSourceIdExtended
from uap_report where ID=N'{0}'" ,
this._reportId);
DataSet ds = SqlHelper.ExecuteDataSet(this._login.UfMetaCnnString, sql);
string dataSourceID = SqlHelper.GetStringFrom(ds.Tables[0].Rows[0]["DataSourceID"]);
string functionName = SqlHelper.GetStringFrom(ds.Tables[0].Rows[0]["FunctionName"]);
string dataSourceIdExtended = SqlHelper.GetStringFrom(ds.Tables[0].Rows[0]["DataSourceIdExtended"]);
this._xmlDoc = new XmlDataDocument();
XmlElement root = this._xmlDoc.CreateElement(FilterXmlService._xmlKeyDataSources);
this._xmlDoc.AppendChild(root);
this.AddClass(root, dataSourceID, String4Report.GetString("原数据源条件"), functionName, true);
this.AddClass(root, dataSourceIdExtended, String4Report.GetString("扩展后的数据源条件"), functionName, false);
return(this._xmlDoc.InnerXml);
}
private DataSet RetrieveData4Portal()
{
SqlCommand cmd = new SqlCommand("UAP_Report_ReportMeta4PublishRetrieve4Portal");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(SqlHelper.GetParameter("@ViewID", SqlDbType.NVarChar, 100, this.ViewId));
cmd.Parameters.Add(SqlHelper.GetParameter("@LocaleID", SqlDbType.NVarChar, 10, this.LogInfo.LocaleID));
cmd.Parameters.Add(SqlHelper.GetParameter("@UserID", SqlDbType.NVarChar, 100, this.LogInfo.UserID));
cmd.Parameters.Add(SqlHelper.GetParameter("@cAccId", SqlDbType.NVarChar, 3, this.LogInfo.cAccId));
cmd.Parameters.Add(SqlHelper.GetParameter("@cYear", SqlDbType.NVarChar, 4, this.LogInfo.cYear));
DataSet ds = SqlHelper.ExecuteDataSet(this.LogInfo.UfMetaCnnString, cmd);
if (ds.Tables[0].Rows.Count <= 0)
{
throw new Exception(String4Report.GetString("UAP报表系统中不存在任何监控报表或操作员没有监控报表的发布权限"));
}
this.FillViewInfos(ds.Tables[0], true);
this.CurrentViewInfo = this.ViewInfos[0];
return(ds);
}
/// <summary>
/// 处理打印情况
/// </summary>
/// <param name="action"></param>
private void HandlePrint(IAction action)
{
string reportId = this.ReportViewControl.ClientReportContext.GetReportId();
AbstractFormInput.ActionHashtable actions = UserToolbarStateManager.ReportActionsState[reportId];
string id = action.Id.Substring(7);
IAction bSetAction = UserToolbarStateManager.FindActionByKey(reportId, id);
string defaultText = "(" + String4Report.GetString("U8.UAP.Report.默认") + ")";
NetAction columnStyle = actions["PrintParent"] as NetAction;
foreach (NetAction ac in columnStyle.Actions)
{
if (ac.Text.Contains(defaultText))
{
ac.Text = ac.Text.Replace(defaultText, string.Empty);
}
}
if (bSetAction != null)
{
bSetAction.Text = bSetAction.Text + defaultText;
}
IAction setPrintDefault = UserToolbarStateManager.FindActionByKey(reportId, "SetPrintDefault");
if (setPrintDefault != null)
{
foreach (NetAction ac in ((NetAction)setPrintDefault).Actions)
{
if (ac.Id != action.Id)
{
ac.IsChecked = false;
}
else
{
ac.IsChecked = true;
}
}
}
SetPrintUserUIState(action);
}
public void FillDefaultView(DataTable dt)
{
try
{
ViewInfo4Publish defaultView = this._viewInfos[0];
if (dt.Rows.Count > 0)
{
string viewId = SqlHelper.GetStringFrom(dt.Rows[0]["ViewID"]);
defaultView = this.GetViewInfo(viewId);
}
if (defaultView != null)
{
defaultView.IsDefault = true;
this.CurrentViewInfo = defaultView;
}
else
{
this.CurrentViewInfo = this._viewInfos[0];
}
}
catch { throw new Exception(String4Report.GetString("当前操作的目标对象已被删除或操作员没有权限!")); }
}
private void btnok_Click(object sender, EventArgs e)
{
try
{
detailcompare.EndEdit();
}
catch (Exception ex)
{
//tabControl1.SelectedIndex =0;
MessageBox.Show(ex.Message, String4Report.GetString("Report"));
return;
}
try
{
totalcompare.EndEdit();
}
catch (Exception ex)
{
//tabControl1.SelectedIndex = 2;
MessageBox.Show(ex.Message, String4Report.GetString("Report"));
return;
}
try
{
summarycompare.EndEdit();
}
catch (Exception ex)
{
//tabControl1.SelectedIndex = 1;
MessageBox.Show(ex.Message, String4Report.GetString("Report"));
return;
}
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// 并发时需要控制不能另存相同的名称
/// </summary>
private void ExcuteStoreProc(
string ufMetaCnnString,
SqlCommand cmd,
ref bool isNameExisted)
{
SqlConnection cnn = new SqlConnection(ufMetaCnnString);
cnn.Open();
SqlTransaction sqlTransaction = cnn.BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(sqlTransaction, cmd);
if (Convert.ToBoolean(cmd.Parameters["@IsExistedName"].Value))
{
sqlTransaction.Rollback();
isNameExisted = true;
}
else
{
sqlTransaction.Commit();
}
}
catch (Exception e)
{
sqlTransaction.Rollback();
throw new Exception(
String4Report.GetString("执行另存操作时出错，原因可能是其他操作员也在执行的另存操作导致互斥,请稍后重试.")
+ "\r\n错误描述:\r\n" + e.Message);
}
finally
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
}
}
private void tlbrefresh_Click(object sender, EventArgs e)
{
if (MessageBox.Show(U8ResService.GetResStringEx("U8.UAP.Report.RefreshConfirm"), String4Report.GetString("Report"), MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (_context.FilterArgs != null)
{
_context.FilterArgs.Args.Add("RefreshInvoked", 1);
}
Refresh();
}
}
public string SaveCrossSchemasWithLock(U8LoginInfor login, string viewID, string crossSchemas, string actionType)
{
//1开一个新的连接，并开事务
SqlConnection cnn = new SqlConnection(login.UfMetaCnnString);
cnn.Open();
SqlTransaction tran = cnn.BeginTransaction();
string result = string.Empty;
try
{
//21 首先获取当前数据库的groupSchemas，并构造要保存的groupSchemas
XmlDocument doc = this.GetCrossSchemasWithXLock(viewID, tran); //tran
GroupSchemas haveSaveCrossSchemas = GroupSchemas.GetSchemas(doc, "");
GroupSchemas toSaveCrossSchemas = GroupSchemas.GetSchemasNoSetDefaultSchema(crossSchemas, "");
//3然后每一个groupSchema做对比
if (toSaveCrossSchemas.Count <= 0)
{
return(toSaveCrossSchemas.ToXml().InnerXml);
}
GroupSchema cs = toSaveCrossSchemas[0];//要更新的
foreach (GroupSchema group in toSaveCrossSchemas)
{
if (group.ID != NOGROUPID)
{
cs = group;
}
}
GroupSchema oldGs = GetGroupSchemaById(haveSaveCrossSchemas, cs.ID);//数据库中已经有的
switch (actionType.ToLower().Trim())
{
case "delete":
if (oldGs == null)
{
throw new ResourceReportException(String4Report.GetString("U8.UAP.Services.ReportData.ReportDataFacade.Delete.Ex", login.LocaleID)); //"没有权限"
//throw new Exception(String4Report.GetString("操作失败，别人已经删除"));
}
haveSaveCrossSchemas.Remove(oldGs);
break;
case "add":
if (HaveSameName(haveSaveCrossSchemas, cs))
{
throw new ResourceReportException(String4Report.GetString("U8.UAP.Services.ReportData.ReportDataFacade.Add.Ex", login.LocaleID));
//throw new Exception(String4Report.GetString("存在重名的分组/交叉，请再次打开报表后更改"));
}
cs.GuidVersion = Guid.NewGuid().ToString();
haveSaveCrossSchemas.Add(cs);
SetOtherSchemaBDefault(haveSaveCrossSchemas, cs);
break;
case "modify":
if (oldGs == null)
{
throw new ResourceReportException(String4Report.GetString("U8.UAP.Services.ReportData.ReportDataFacade.Delete.Ex", login.LocaleID)); //"没有权限"
//throw new Exception(String4Report.GetString("操作失败，别人已经删除"));
}
//表明同一个用户在操作，不校验并发
if (string.IsNullOrEmpty(oldGs.LastUserGuid) || oldGs.LastUserGuid == cs.LastUserGuid)
{
if (HaveSameName(haveSaveCrossSchemas, cs))
{
throw new ResourceReportException(String4Report.GetString("U8.UAP.Services.ReportData.ReportDataFacade.Modify.Ex2", login.LocaleID));
//throw new Exception(String4Report.GetString("存在重名的分组/交叉，请再次打开报表后更改"));
}
haveSaveCrossSchemas.Remove(oldGs);
cs.GuidVersion = Guid.NewGuid().ToString();
haveSaveCrossSchemas.Add(cs);
SetOtherSchemaBDefault(haveSaveCrossSchemas, cs);
}
//表明同一个用户在操作，不校验并发
else
{
if (oldGs.GuidVersion == cs.GuidVersion)
{
if (HaveSameName(haveSaveCrossSchemas, cs))
{
throw new ResourceReportException(String4Report.GetString("U8.UAP.Services.ReportData.ReportDataFacade.Modify.Ex2", login.LocaleID));
//throw new Exception(String4Report.GetString("存在重名的分组/交叉，请再次打开报表后更改"));
}
haveSaveCrossSchemas.Remove(oldGs);
cs.GuidVersion = Guid.NewGuid().ToString();
haveSaveCrossSchemas.Add(cs);
SetOtherSchemaBDefault(haveSaveCrossSchemas, cs);
}
else
{
throw new ResourceReportException(String4Report.GetString("U8.UAP.Services.ReportData.ReportDataFacade.Modify.Ex3", login.LocaleID));
//throw new Exception(String4Report.GetString("操作失败，别人已经修改"));
}
}
break;
default:
break;
}
result = haveSaveCrossSchemas.ToXml().InnerXml;
string sql = "UPDATE UAP_ReportView SET PreservedField = @CrossSchemas WHERE ID=@ViewID";
SqlCommand command = new SqlCommand(sql, cnn);
command.Parameters.Add(new SqlParameter("CrossSchemas", result));
command.Parameters.Add(new SqlParameter("ViewID", viewID));
SqlHelper.ExecuteNonQuery(tran, command);
tran.Commit();
}
catch (Exception e)
{
tran.Rollback();
throw e;
}
finally
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
}
return(result);
}
internal void Retrieve()
{
CheckDbCnnString();
SqlCommand cmd = new SqlCommand("UAP_Report_RuntimeExihibitonGetReportRelateInfor");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(SqlHelper.GetParameter("@ID", SqlDbType.NVarChar, 100, _InputID));
cmd.Parameters.Add(SqlHelper.GetParameter("@cAccId", SqlDbType.Char, 3, _cAccId));
cmd.Parameters.Add(SqlHelper.GetParameter("@cYear", SqlDbType.Char, 4, _cYear));
cmd.Parameters.Add(SqlHelper.GetParameter("@cUser", SqlDbType.NVarChar, 20, _UserID));
cmd.Parameters.Add(SqlHelper.GetParameter("@LocaleID", SqlDbType.NVarChar, 10, _LocaleID));
cmd.Parameters.Add(SqlHelper.GetParameter("@DefaultViewID", SqlDbType.NVarChar, 100));
cmd.Parameters.Add(SqlHelper.GetParameter("@ReportID", SqlDbType.NVarChar, 100));
DataSet ds = SqlHelper.ExecuteDataSet(_DbConnString, cmd);
if (ds.Tables.Count > 1)
{
string defaultviewid = cmd.Parameters["@DefaultViewID"].Value.ToString();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SimpleView view = new SimpleView();
view.ID = ds.Tables[0].Rows[i]["ViewGuid"].ToString();
view.Name = ds.Tables[0].Rows[i]["Name"].ToString();
view.ViewType = Convert.ToInt32(ds.Tables[0].Rows[i]["ViewType"]);
view.ViewClass = SqlHelper.GetStringFrom(ds.Tables[0].Rows[i]["ViewClass"]);
view.ReportMergeCell = SqlHelper.GetBooleanFrom(ds.Tables[0].Rows[i]["ReportMergeCell"], false);
view.RowsCount = SqlHelper.GetIntFrom(ds.Tables[0].Rows[i]["RowsCount"], 40);
view.bShowDetail = SqlHelper.GetBooleanFrom(ds.Tables[0].Rows[i]["bShowDetail"], false);
if (view.ID.ToLower() == defaultviewid.ToLower())
{
view.IsDefault = true;
}
_Views.Add(view);
}
DataRow dr = ds.Tables[1].Rows[0];
_ReportID = cmd.Parameters["@ReportID"].Value.ToString();
_ClassName = SqlHelper.GetStringFrom(dr["ClassName"]);
_FilterId = SqlHelper.GetStringFrom(dr["FilterId"]);
_FilterClass = SqlHelper.GetStringFrom(dr["FilterClass"]);
_rootReportId = SqlHelper.GetStringFrom(dr["RootReportId"]);
_bVB = SqlHelper.GetBooleanFrom(dr["bVB"], true);
if (defaultviewid == string.Empty)
{
if (_Views.Count <= 0)
{
throw new ResourceReportException(String4Report.GetString("操作员没有查询权限或视图权限!", _LocaleID));
}
_DefaultViewID = _Views[0].ID;
}
else
{
_DefaultViewID = defaultviewid;
}
}
}
