/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public ChartMain GetModel(string strCondition)
{
List<ChartMain> list = instance.GetListByWhere(strCondition);
ChartMain model = new ChartMain();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return model;
}
/// <summary>
/// 更新图表配置主表 ChartMain对象(即:一条记录
/// </summary>
public int Update(ChartMain chartMain)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE ChartMain SET ");
if(chartMain.CM_Module_IsChanged){sbParameter.Append("CM_Module=@CM_Module, ");}
if(chartMain.CM_Title_IsChanged){sbParameter.Append("CM_Title=@CM_Title, ");}
if(chartMain.CM_TitleLocation_IsChanged){sbParameter.Append("CM_TitleLocation=@CM_TitleLocation, ");}
if(chartMain.CM_ChartAreas_IsChanged){sbParameter.Append("CM_ChartAreas=@CM_ChartAreas, ");}
if(chartMain.CM_Legend_IsChanged){sbParameter.Append("CM_Legend=@CM_Legend, ");}
if(chartMain.CM_LegendDock_IsChanged){sbParameter.Append("CM_LegendDock=@CM_LegendDock, ");}
if(chartMain.CM_LegendLocation_IsChanged){sbParameter.Append("CM_LegendLocation=@CM_LegendLocation, ");}
if(chartMain.CM_Series_IsChanged){sbParameter.Append("CM_Series=@CM_Series, ");}
if(chartMain.CM_Width_IsChanged){sbParameter.Append("CM_Width=@CM_Width, ");}
if(chartMain.CM_Height_IsChanged){sbParameter.Append("CM_Height=@CM_Height, ");}
if(chartMain.CM_XLineColor_IsChanged){sbParameter.Append("CM_XLineColor=@CM_XLineColor, ");}
if(chartMain.CM_XMininum_IsChanged){sbParameter.Append("CM_XMininum=@CM_XMininum, ");}
if(chartMain.CM_XMaxinum_IsChanged){sbParameter.Append("CM_XMaxinum=@CM_XMaxinum, ");}
if(chartMain.CM_XIntervalOffset_IsChanged){sbParameter.Append("CM_XIntervalOffset=@CM_XIntervalOffset, ");}
if(chartMain.CM_XInterval_IsChanged){sbParameter.Append("CM_XInterval=@CM_XInterval, ");}
if(chartMain.CM_XIntervalType_IsChanged){sbParameter.Append("CM_XIntervalType=@CM_XIntervalType, ");}
if(chartMain.CM_XArrowStyle_IsChanged){sbParameter.Append("CM_XArrowStyle=@CM_XArrowStyle, ");}
if(chartMain.CM_XTitle_IsChanged){sbParameter.Append("CM_XTitle=@CM_XTitle, ");}
if(chartMain.CM_XTitleAlignment_IsChanged){sbParameter.Append("CM_XTitleAlignment=@CM_XTitleAlignment, ");}
if(chartMain.CM_XMajorGrid_IsChanged){sbParameter.Append("CM_XMajorGrid=@CM_XMajorGrid, ");}
if(chartMain.CM_XMajorGridLineColor_IsChanged){sbParameter.Append("CM_XMajorGridLineColor=@CM_XMajorGridLineColor, ");}
if(chartMain.CM_YLineColor_IsChanged){sbParameter.Append("CM_YLineColor=@CM_YLineColor, ");}
if(chartMain.CM_YMininum_IsChanged){sbParameter.Append("CM_YMininum=@CM_YMininum, ");}
if(chartMain.CM_YMaxinum_IsChanged){sbParameter.Append("CM_YMaxinum=@CM_YMaxinum, ");}
if(chartMain.CM_YIntervalOffset_IsChanged){sbParameter.Append("CM_YIntervalOffset=@CM_YIntervalOffset, ");}
if(chartMain.CM_YInterval_IsChanged){sbParameter.Append("CM_YInterval=@CM_YInterval, ");}
if(chartMain.CM_YIntervalType_IsChanged){sbParameter.Append("CM_YIntervalType=@CM_YIntervalType, ");}
if(chartMain.CM_YArrowStyle_IsChanged){sbParameter.Append("CM_YArrowStyle=@CM_YArrowStyle, ");}
if(chartMain.CM_YTitle_IsChanged){sbParameter.Append("CM_YTitle=@CM_YTitle, ");}
if(chartMain.CM_YTitleAlignment_IsChanged){sbParameter.Append("CM_YTitleAlignment=@CM_YTitleAlignment, ");}
if(chartMain.CM_YMajorGrid_IsChanged){sbParameter.Append("CM_YMajorGrid=@CM_YMajorGrid, ");}
if(chartMain.CM_YMajorGridLineColor_IsChanged){sbParameter.Append("CM_YMajorGridLineColor=@CM_YMajorGridLineColor, ");}
if(chartMain.CM_UDEF1_IsChanged){sbParameter.Append("CM_UDEF1=@CM_UDEF1, ");}
if(chartMain.CM_UDEF2_IsChanged){sbParameter.Append("CM_UDEF2=@CM_UDEF2, ");}
if(chartMain.CM_UDEF3_IsChanged){sbParameter.Append("CM_UDEF3=@CM_UDEF3, ");}
if(chartMain.CM_UDEF4_IsChanged){sbParameter.Append("CM_UDEF4=@CM_UDEF4, ");}
if(chartMain.CM_UDEF5_IsChanged){sbParameter.Append("CM_UDEF5=@CM_UDEF5, ");}
if(chartMain.CM_UDEF6_IsChanged){sbParameter.Append("CM_UDEF6=@CM_UDEF6, ");}
if(chartMain.CM_UDEF7_IsChanged){sbParameter.Append("CM_UDEF7=@CM_UDEF7, ");}
if(chartMain.CM_UDEF8_IsChanged){sbParameter.Append("CM_UDEF8=@CM_UDEF8, ");}
if(chartMain.CM_UDEF9_IsChanged){sbParameter.Append("CM_UDEF9=@CM_UDEF9, ");}
if(chartMain.CM_UDEF10_IsChanged){sbParameter.Append("CM_UDEF10=@CM_UDEF10, ");}
if(chartMain.Stat_IsChanged){sbParameter.Append("Stat=@Stat ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CM_ID=@CM_ID; " );
string sql=sb.ToString();
if(chartMain.CM_Module_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_Module))
{
idb.AddParameter("@CM_Module", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Module", chartMain.CM_Module);
}
}
if(chartMain.CM_Title_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_Title))
{
idb.AddParameter("@CM_Title", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Title", chartMain.CM_Title);
}
}
if(chartMain.CM_TitleLocation_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_TitleLocation))
{
idb.AddParameter("@CM_TitleLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_TitleLocation", chartMain.CM_TitleLocation);
}
}
if(chartMain.CM_ChartAreas_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_ChartAreas))
{
idb.AddParameter("@CM_ChartAreas", DBNull.Value);
}
else
{
idb.AddParameter("@CM_ChartAreas", chartMain.CM_ChartAreas);
}
}
if(chartMain.CM_Legend_IsChanged)
{
if (chartMain.CM_Legend == false)
{
idb.AddParameter("@CM_Legend", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Legend", chartMain.CM_Legend);
}
}
if(chartMain.CM_LegendDock_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_LegendDock))
{
idb.AddParameter("@CM_LegendDock", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendDock", chartMain.CM_LegendDock);
}
}
if(chartMain.CM_LegendLocation_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_LegendLocation))
{
idb.AddParameter("@CM_LegendLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendLocation", chartMain.CM_LegendLocation);
}
}
if(chartMain.CM_Series_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_Series))
{
idb.AddParameter("@CM_Series", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Series", chartMain.CM_Series);
}
}
if(chartMain.CM_Width_IsChanged)
{
if (chartMain.CM_Width == 0)
{
idb.AddParameter("@CM_Width", 0);
}
else
{
idb.AddParameter("@CM_Width", chartMain.CM_Width);
}
}
if(chartMain.CM_Height_IsChanged)
{
if (chartMain.CM_Height == 0)
{
idb.AddParameter("@CM_Height", 0);
}
else
{
idb.AddParameter("@CM_Height", chartMain.CM_Height);
}
}
if(chartMain.CM_XLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XLineColor))
{
idb.AddParameter("@CM_XLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XLineColor", chartMain.CM_XLineColor);
}
}
if(chartMain.CM_XMininum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XMininum))
{
idb.AddParameter("@CM_XMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMininum", chartMain.CM_XMininum);
}
}
if(chartMain.CM_XMaxinum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XMaxinum))
{
idb.AddParameter("@CM_XMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMaxinum", chartMain.CM_XMaxinum);
}
}
if(chartMain.CM_XIntervalOffset_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XIntervalOffset))
{
idb.AddParameter("@CM_XIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalOffset", chartMain.CM_XIntervalOffset);
}
}
if(chartMain.CM_XInterval_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XInterval))
{
idb.AddParameter("@CM_XInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XInterval", chartMain.CM_XInterval);
}
}
if(chartMain.CM_XIntervalType_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XIntervalType))
{
idb.AddParameter("@CM_XIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalType", chartMain.CM_XIntervalType);
}
}
if(chartMain.CM_XArrowStyle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XArrowStyle))
{
idb.AddParameter("@CM_XArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XArrowStyle", chartMain.CM_XArrowStyle);
}
}
if(chartMain.CM_XTitle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XTitle))
{
idb.AddParameter("@CM_XTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitle", chartMain.CM_XTitle);
}
}
if(chartMain.CM_XTitleAlignment_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XTitleAlignment))
{
idb.AddParameter("@CM_XTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitleAlignment", chartMain.CM_XTitleAlignment);
}
}
if(chartMain.CM_XMajorGrid_IsChanged)
{
if (chartMain.CM_XMajorGrid == 0)
{
idb.AddParameter("@CM_XMajorGrid", 0);
}
else
{
idb.AddParameter("@CM_XMajorGrid", chartMain.CM_XMajorGrid);
}
}
if(chartMain.CM_XMajorGridLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XMajorGridLineColor))
{
idb.AddParameter("@CM_XMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMajorGridLineColor", chartMain.CM_XMajorGridLineColor);
}
}
if(chartMain.CM_YLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YLineColor))
{
idb.AddParameter("@CM_YLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YLineColor", chartMain.CM_YLineColor);
}
}
if(chartMain.CM_YMininum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMininum))
{
idb.AddParameter("@CM_YMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMininum", chartMain.CM_YMininum);
}
}
if(chartMain.CM_YMaxinum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMaxinum))
{
idb.AddParameter("@CM_YMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMaxinum", chartMain.CM_YMaxinum);
}
}
if(chartMain.CM_YIntervalOffset_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YIntervalOffset))
{
idb.AddParameter("@CM_YIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalOffset", chartMain.CM_YIntervalOffset);
}
}
if(chartMain.CM_YInterval_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YInterval))
{
idb.AddParameter("@CM_YInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YInterval", chartMain.CM_YInterval);
}
}
if(chartMain.CM_YIntervalType_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YIntervalType))
{
idb.AddParameter("@CM_YIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalType", chartMain.CM_YIntervalType);
}
}
if(chartMain.CM_YArrowStyle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YArrowStyle))
{
idb.AddParameter("@CM_YArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YArrowStyle", chartMain.CM_YArrowStyle);
}
}
if(chartMain.CM_YTitle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YTitle))
{
idb.AddParameter("@CM_YTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitle", chartMain.CM_YTitle);
}
}
if(chartMain.CM_YTitleAlignment_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YTitleAlignment))
{
idb.AddParameter("@CM_YTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitleAlignment", chartMain.CM_YTitleAlignment);
}
}
if(chartMain.CM_YMajorGrid_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMajorGrid))
{
idb.AddParameter("@CM_YMajorGrid", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGrid", chartMain.CM_YMajorGrid);
}
}
if(chartMain.CM_YMajorGridLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMajorGridLineColor))
{
idb.AddParameter("@CM_YMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGridLineColor", chartMain.CM_YMajorGridLineColor);
}
}
if(chartMain.CM_UDEF1_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF1))
{
idb.AddParameter("@CM_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF1", chartMain.CM_UDEF1);
}
}
if(chartMain.CM_UDEF2_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF2))
{
idb.AddParameter("@CM_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF2", chartMain.CM_UDEF2);
}
}
if(chartMain.CM_UDEF3_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF3))
{
idb.AddParameter("@CM_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF3", chartMain.CM_UDEF3);
}
}
if(chartMain.CM_UDEF4_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF4))
{
idb.AddParameter("@CM_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF4", chartMain.CM_UDEF4);
}
}
if(chartMain.CM_UDEF5_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF5))
{
idb.AddParameter("@CM_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF5", chartMain.CM_UDEF5);
}
}
if(chartMain.CM_UDEF6_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF6))
{
idb.AddParameter("@CM_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF6", chartMain.CM_UDEF6);
}
}
if(chartMain.CM_UDEF7_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF7))
{
idb.AddParameter("@CM_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF7", chartMain.CM_UDEF7);
}
}
if(chartMain.CM_UDEF8_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF8))
{
idb.AddParameter("@CM_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF8", chartMain.CM_UDEF8);
}
}
if(chartMain.CM_UDEF9_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF9))
{
idb.AddParameter("@CM_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF9", chartMain.CM_UDEF9);
}
}
if(chartMain.CM_UDEF10_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF10))
{
idb.AddParameter("@CM_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF10", chartMain.CM_UDEF10);
}
}
if(chartMain.Stat_IsChanged)
{
if (chartMain.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", chartMain.Stat);
}
}
idb.AddParameter("@CM_ID", chartMain.CM_ID);
return idb.ExeCmd(sql);
/// <summary>
/// 获取指定的图表配置主表 ChartMain对象集合
/// </summary>
public List<ChartMain> GetListByWhere(string strCondition)
{
List<ChartMain> ret = new List<ChartMain>();
string sql = "SELECT CM_ID,CM_Module,CM_Title,CM_TitleLocation,CM_ChartAreas,CM_Legend,CM_LegendDock,CM_LegendLocation,CM_Series,CM_Width,CM_Height,CM_XLineColor,CM_XMininum,CM_XMaxinum,CM_XIntervalOffset,CM_XInterval,CM_XIntervalType,CM_XArrowStyle,CM_XTitle,CM_XTitleAlignment,CM_XMajorGrid,CM_XMajorGridLineColor,CM_YLineColor,CM_YMininum,CM_YMaxinum,CM_YIntervalOffset,CM_YInterval,CM_YIntervalType,CM_YArrowStyle,CM_YTitle,CM_YTitleAlignment,CM_YMajorGrid,CM_YMajorGridLineColor,CM_UDEF1,CM_UDEF2,CM_UDEF3,CM_UDEF4,CM_UDEF5,CM_UDEF6,CM_UDEF7,CM_UDEF8,CM_UDEF9,CM_UDEF10,Stat FROM ChartMain WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if(!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'','"'); //防sql注入
sql += strCondition ;
}
sql += " ORDER BY CM_ID DESC ";
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
ChartMain chartMain = new ChartMain();
if (dr["CM_ID"] != DBNull.Value) chartMain.CM_ID = Convert.ToDecimal(dr["CM_ID"]);
if (dr["CM_Module"] != DBNull.Value) chartMain.CM_Module = Convert.ToString(dr["CM_Module"]);
if (dr["CM_Title"] != DBNull.Value) chartMain.CM_Title = Convert.ToString(dr["CM_Title"]);
if (dr["CM_TitleLocation"] != DBNull.Value) chartMain.CM_TitleLocation = Convert.ToString(dr["CM_TitleLocation"]);
if (dr["CM_ChartAreas"] != DBNull.Value) chartMain.CM_ChartAreas = Convert.ToString(dr["CM_ChartAreas"]);
if (dr["CM_Legend"] != DBNull.Value) chartMain.CM_Legend = Convert.ToBoolean(dr["CM_Legend"]);
if (dr["CM_LegendDock"] != DBNull.Value) chartMain.CM_LegendDock = Convert.ToString(dr["CM_LegendDock"]);
if (dr["CM_LegendLocation"] != DBNull.Value) chartMain.CM_LegendLocation = Convert.ToString(dr["CM_LegendLocation"]);
if (dr["CM_Series"] != DBNull.Value) chartMain.CM_Series = Convert.ToString(dr["CM_Series"]);
if (dr["CM_Width"] != DBNull.Value) chartMain.CM_Width = Convert.ToInt32(dr["CM_Width"]);
if (dr["CM_Height"] != DBNull.Value) chartMain.CM_Height = Convert.ToInt32(dr["CM_Height"]);
if (dr["CM_XLineColor"] != DBNull.Value) chartMain.CM_XLineColor = Convert.ToString(dr["CM_XLineColor"]);
if (dr["CM_XMininum"] != DBNull.Value) chartMain.CM_XMininum = Convert.ToString(dr["CM_XMininum"]);
if (dr["CM_XMaxinum"] != DBNull.Value) chartMain.CM_XMaxinum = Convert.ToString(dr["CM_XMaxinum"]);
if (dr["CM_XIntervalOffset"] != DBNull.Value) chartMain.CM_XIntervalOffset = Convert.ToString(dr["CM_XIntervalOffset"]);
if (dr["CM_XInterval"] != DBNull.Value) chartMain.CM_XInterval = Convert.ToString(dr["CM_XInterval"]);
if (dr["CM_XIntervalType"] != DBNull.Value) chartMain.CM_XIntervalType = Convert.ToString(dr["CM_XIntervalType"]);
if (dr["CM_XArrowStyle"] != DBNull.Value) chartMain.CM_XArrowStyle = Convert.ToString(dr["CM_XArrowStyle"]);
if (dr["CM_XTitle"] != DBNull.Value) chartMain.CM_XTitle = Convert.ToString(dr["CM_XTitle"]);
if (dr["CM_XTitleAlignment"] != DBNull.Value) chartMain.CM_XTitleAlignment = Convert.ToString(dr["CM_XTitleAlignment"]);
if (dr["CM_XMajorGrid"] != DBNull.Value) chartMain.CM_XMajorGrid = Convert.ToInt32(dr["CM_XMajorGrid"]);
if (dr["CM_XMajorGridLineColor"] != DBNull.Value) chartMain.CM_XMajorGridLineColor = Convert.ToString(dr["CM_XMajorGridLineColor"]);
if (dr["CM_YLineColor"] != DBNull.Value) chartMain.CM_YLineColor = Convert.ToString(dr["CM_YLineColor"]);
if (dr["CM_YMininum"] != DBNull.Value) chartMain.CM_YMininum = Convert.ToString(dr["CM_YMininum"]);
if (dr["CM_YMaxinum"] != DBNull.Value) chartMain.CM_YMaxinum = Convert.ToString(dr["CM_YMaxinum"]);
if (dr["CM_YIntervalOffset"] != DBNull.Value) chartMain.CM_YIntervalOffset = Convert.ToString(dr["CM_YIntervalOffset"]);
if (dr["CM_YInterval"] != DBNull.Value) chartMain.CM_YInterval = Convert.ToString(dr["CM_YInterval"]);
if (dr["CM_YIntervalType"] != DBNull.Value) chartMain.CM_YIntervalType = Convert.ToString(dr["CM_YIntervalType"]);
if (dr["CM_YArrowStyle"] != DBNull.Value) chartMain.CM_YArrowStyle = Convert.ToString(dr["CM_YArrowStyle"]);
if (dr["CM_YTitle"] != DBNull.Value) chartMain.CM_YTitle = Convert.ToString(dr["CM_YTitle"]);
if (dr["CM_YTitleAlignment"] != DBNull.Value) chartMain.CM_YTitleAlignment = Convert.ToString(dr["CM_YTitleAlignment"]);
if (dr["CM_YMajorGrid"] != DBNull.Value) chartMain.CM_YMajorGrid = Convert.ToString(dr["CM_YMajorGrid"]);
if (dr["CM_YMajorGridLineColor"] != DBNull.Value) chartMain.CM_YMajorGridLineColor = Convert.ToString(dr["CM_YMajorGridLineColor"]);
if (dr["CM_UDEF1"] != DBNull.Value) chartMain.CM_UDEF1 = Convert.ToString(dr["CM_UDEF1"]);
if (dr["CM_UDEF2"] != DBNull.Value) chartMain.CM_UDEF2 = Convert.ToString(dr["CM_UDEF2"]);
if (dr["CM_UDEF3"] != DBNull.Value) chartMain.CM_UDEF3 = Convert.ToString(dr["CM_UDEF3"]);
if (dr["CM_UDEF4"] != DBNull.Value) chartMain.CM_UDEF4 = Convert.ToString(dr["CM_UDEF4"]);
if (dr["CM_UDEF5"] != DBNull.Value) chartMain.CM_UDEF5 = Convert.ToString(dr["CM_UDEF5"]);
if (dr["CM_UDEF6"] != DBNull.Value) chartMain.CM_UDEF6 = Convert.ToString(dr["CM_UDEF6"]);
if (dr["CM_UDEF7"] != DBNull.Value) chartMain.CM_UDEF7 = Convert.ToString(dr["CM_UDEF7"]);
if (dr["CM_UDEF8"] != DBNull.Value) chartMain.CM_UDEF8 = Convert.ToString(dr["CM_UDEF8"]);
if (dr["CM_UDEF9"] != DBNull.Value) chartMain.CM_UDEF9 = Convert.ToString(dr["CM_UDEF9"]);
if (dr["CM_UDEF10"] != DBNull.Value) chartMain.CM_UDEF10 = Convert.ToString(dr["CM_UDEF10"]);
if (dr["Stat"] != DBNull.Value) chartMain.Stat = Convert.ToInt32(dr["Stat"]);
ret.Add(chartMain);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return ret;
}
/// <summary>
/// 获取指定的图表配置主表 ChartMain对象(即:一条记录
/// </summary>
public ChartMain GetByKey(decimal cM_ID)
{
ChartMain chartMain = new ChartMain();
string sql = "SELECT CM_ID,CM_Module,CM_Title,CM_TitleLocation,CM_ChartAreas,CM_Legend,CM_LegendDock,CM_LegendLocation,CM_Series,CM_Width,CM_Height,CM_XLineColor,CM_XMininum,CM_XMaxinum,CM_XIntervalOffset,CM_XInterval,CM_XIntervalType,CM_XArrowStyle,CM_XTitle,CM_XTitleAlignment,CM_XMajorGrid,CM_XMajorGridLineColor,CM_YLineColor,CM_YMininum,CM_YMaxinum,CM_YIntervalOffset,CM_YInterval,CM_YIntervalType,CM_YArrowStyle,CM_YTitle,CM_YTitleAlignment,CM_YMajorGrid,CM_YMajorGridLineColor,CM_UDEF1,CM_UDEF2,CM_UDEF3,CM_UDEF4,CM_UDEF5,CM_UDEF6,CM_UDEF7,CM_UDEF8,CM_UDEF9,CM_UDEF10,Stat FROM ChartMain WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND CM_ID=@CM_ID ";
idb.AddParameter("@CM_ID", cM_ID);
SqlDataReader dr=null;
try {
dr=(SqlDataReader)idb.ReturnReader(sql);
while(dr.Read())
{
if (dr["CM_ID"] != DBNull.Value) chartMain.CM_ID = Convert.ToDecimal(dr["CM_ID"]);
if (dr["CM_Module"] != DBNull.Value) chartMain.CM_Module = Convert.ToString(dr["CM_Module"]);
if (dr["CM_Title"] != DBNull.Value) chartMain.CM_Title = Convert.ToString(dr["CM_Title"]);
if (dr["CM_TitleLocation"] != DBNull.Value) chartMain.CM_TitleLocation = Convert.ToString(dr["CM_TitleLocation"]);
if (dr["CM_ChartAreas"] != DBNull.Value) chartMain.CM_ChartAreas = Convert.ToString(dr["CM_ChartAreas"]);
if (dr["CM_Legend"] != DBNull.Value) chartMain.CM_Legend = Convert.ToBoolean(dr["CM_Legend"]);
if (dr["CM_LegendDock"] != DBNull.Value) chartMain.CM_LegendDock = Convert.ToString(dr["CM_LegendDock"]);
if (dr["CM_LegendLocation"] != DBNull.Value) chartMain.CM_LegendLocation = Convert.ToString(dr["CM_LegendLocation"]);
if (dr["CM_Series"] != DBNull.Value) chartMain.CM_Series = Convert.ToString(dr["CM_Series"]);
if (dr["CM_Width"] != DBNull.Value) chartMain.CM_Width = Convert.ToInt32(dr["CM_Width"]);
if (dr["CM_Height"] != DBNull.Value) chartMain.CM_Height = Convert.ToInt32(dr["CM_Height"]);
if (dr["CM_XLineColor"] != DBNull.Value) chartMain.CM_XLineColor = Convert.ToString(dr["CM_XLineColor"]);
if (dr["CM_XMininum"] != DBNull.Value) chartMain.CM_XMininum = Convert.ToString(dr["CM_XMininum"]);
if (dr["CM_XMaxinum"] != DBNull.Value) chartMain.CM_XMaxinum = Convert.ToString(dr["CM_XMaxinum"]);
if (dr["CM_XIntervalOffset"] != DBNull.Value) chartMain.CM_XIntervalOffset = Convert.ToString(dr["CM_XIntervalOffset"]);
if (dr["CM_XInterval"] != DBNull.Value) chartMain.CM_XInterval = Convert.ToString(dr["CM_XInterval"]);
if (dr["CM_XIntervalType"] != DBNull.Value) chartMain.CM_XIntervalType = Convert.ToString(dr["CM_XIntervalType"]);
if (dr["CM_XArrowStyle"] != DBNull.Value) chartMain.CM_XArrowStyle = Convert.ToString(dr["CM_XArrowStyle"]);
if (dr["CM_XTitle"] != DBNull.Value) chartMain.CM_XTitle = Convert.ToString(dr["CM_XTitle"]);
if (dr["CM_XTitleAlignment"] != DBNull.Value) chartMain.CM_XTitleAlignment = Convert.ToString(dr["CM_XTitleAlignment"]);
if (dr["CM_XMajorGrid"] != DBNull.Value) chartMain.CM_XMajorGrid = Convert.ToInt32(dr["CM_XMajorGrid"]);
if (dr["CM_XMajorGridLineColor"] != DBNull.Value) chartMain.CM_XMajorGridLineColor = Convert.ToString(dr["CM_XMajorGridLineColor"]);
if (dr["CM_YLineColor"] != DBNull.Value) chartMain.CM_YLineColor = Convert.ToString(dr["CM_YLineColor"]);
if (dr["CM_YMininum"] != DBNull.Value) chartMain.CM_YMininum = Convert.ToString(dr["CM_YMininum"]);
if (dr["CM_YMaxinum"] != DBNull.Value) chartMain.CM_YMaxinum = Convert.ToString(dr["CM_YMaxinum"]);
if (dr["CM_YIntervalOffset"] != DBNull.Value) chartMain.CM_YIntervalOffset = Convert.ToString(dr["CM_YIntervalOffset"]);
if (dr["CM_YInterval"] != DBNull.Value) chartMain.CM_YInterval = Convert.ToString(dr["CM_YInterval"]);
if (dr["CM_YIntervalType"] != DBNull.Value) chartMain.CM_YIntervalType = Convert.ToString(dr["CM_YIntervalType"]);
if (dr["CM_YArrowStyle"] != DBNull.Value) chartMain.CM_YArrowStyle = Convert.ToString(dr["CM_YArrowStyle"]);
if (dr["CM_YTitle"] != DBNull.Value) chartMain.CM_YTitle = Convert.ToString(dr["CM_YTitle"]);
if (dr["CM_YTitleAlignment"] != DBNull.Value) chartMain.CM_YTitleAlignment = Convert.ToString(dr["CM_YTitleAlignment"]);
if (dr["CM_YMajorGrid"] != DBNull.Value) chartMain.CM_YMajorGrid = Convert.ToString(dr["CM_YMajorGrid"]);
if (dr["CM_YMajorGridLineColor"] != DBNull.Value) chartMain.CM_YMajorGridLineColor = Convert.ToString(dr["CM_YMajorGridLineColor"]);
if (dr["CM_UDEF1"] != DBNull.Value) chartMain.CM_UDEF1 = Convert.ToString(dr["CM_UDEF1"]);
if (dr["CM_UDEF2"] != DBNull.Value) chartMain.CM_UDEF2 = Convert.ToString(dr["CM_UDEF2"]);
if (dr["CM_UDEF3"] != DBNull.Value) chartMain.CM_UDEF3 = Convert.ToString(dr["CM_UDEF3"]);
if (dr["CM_UDEF4"] != DBNull.Value) chartMain.CM_UDEF4 = Convert.ToString(dr["CM_UDEF4"]);
if (dr["CM_UDEF5"] != DBNull.Value) chartMain.CM_UDEF5 = Convert.ToString(dr["CM_UDEF5"]);
if (dr["CM_UDEF6"] != DBNull.Value) chartMain.CM_UDEF6 = Convert.ToString(dr["CM_UDEF6"]);
if (dr["CM_UDEF7"] != DBNull.Value) chartMain.CM_UDEF7 = Convert.ToString(dr["CM_UDEF7"]);
if (dr["CM_UDEF8"] != DBNull.Value) chartMain.CM_UDEF8 = Convert.ToString(dr["CM_UDEF8"]);
if (dr["CM_UDEF9"] != DBNull.Value) chartMain.CM_UDEF9 = Convert.ToString(dr["CM_UDEF9"]);
if (dr["CM_UDEF10"] != DBNull.Value) chartMain.CM_UDEF10 = Convert.ToString(dr["CM_UDEF10"]);
if (dr["Stat"] != DBNull.Value) chartMain.Stat = Convert.ToInt32(dr["Stat"]);
}
}catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } }
return chartMain;
}
/// <summary>
/// 添加图表配置主表 ChartMain对象(即:一条记录)
/// </summary>
public object AddWithReturn(ChartMain chartMain)
{
string sql = "INSERT INTO ChartMain (CM_Module,CM_Title,CM_TitleLocation,CM_ChartAreas,CM_Legend,CM_LegendDock,CM_LegendLocation,CM_Series,CM_Width,CM_Height,CM_XLineColor,CM_XMininum,CM_XMaxinum,CM_XIntervalOffset,CM_XInterval,CM_XIntervalType,CM_XArrowStyle,CM_XTitle,CM_XTitleAlignment,CM_XMajorGrid,CM_XMajorGridLineColor,CM_YLineColor,CM_YMininum,CM_YMaxinum,CM_YIntervalOffset,CM_YInterval,CM_YIntervalType,CM_YArrowStyle,CM_YTitle,CM_YTitleAlignment,CM_YMajorGrid,CM_YMajorGridLineColor,CM_UDEF1,CM_UDEF2,CM_UDEF3,CM_UDEF4,CM_UDEF5,CM_UDEF6,CM_UDEF7,CM_UDEF8,CM_UDEF9,CM_UDEF10,Stat) VALUES (@CM_Module,@CM_Title,@CM_TitleLocation,@CM_ChartAreas,@CM_Legend,@CM_LegendDock,@CM_LegendLocation,@CM_Series,@CM_Width,@CM_Height,@CM_XLineColor,@CM_XMininum,@CM_XMaxinum,@CM_XIntervalOffset,@CM_XInterval,@CM_XIntervalType,@CM_XArrowStyle,@CM_XTitle,@CM_XTitleAlignment,@CM_XMajorGrid,@CM_XMajorGridLineColor,@CM_YLineColor,@CM_YMininum,@CM_YMaxinum,@CM_YIntervalOffset,@CM_YInterval,@CM_YIntervalType,@CM_YArrowStyle,@CM_YTitle,@CM_YTitleAlignment,@CM_YMajorGrid,@CM_YMajorGridLineColor,@CM_UDEF1,@CM_UDEF2,@CM_UDEF3,@CM_UDEF4,@CM_UDEF5,@CM_UDEF6,@CM_UDEF7,@CM_UDEF8,@CM_UDEF9,@CM_UDEF10,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(chartMain.CM_Module))
{
idb.AddParameter("@CM_Module", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Module", chartMain.CM_Module);
}
if (string.IsNullOrEmpty(chartMain.CM_Title))
{
idb.AddParameter("@CM_Title", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Title", chartMain.CM_Title);
}
if (string.IsNullOrEmpty(chartMain.CM_TitleLocation))
{
idb.AddParameter("@CM_TitleLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_TitleLocation", chartMain.CM_TitleLocation);
}
if (string.IsNullOrEmpty(chartMain.CM_ChartAreas))
{
idb.AddParameter("@CM_ChartAreas", DBNull.Value);
}
else
{
idb.AddParameter("@CM_ChartAreas", chartMain.CM_ChartAreas);
}
if (chartMain.CM_Legend == false)
{
idb.AddParameter("@CM_Legend", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Legend", chartMain.CM_Legend);
}
if (string.IsNullOrEmpty(chartMain.CM_LegendDock))
{
idb.AddParameter("@CM_LegendDock", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendDock", chartMain.CM_LegendDock);
}
if (string.IsNullOrEmpty(chartMain.CM_LegendLocation))
{
idb.AddParameter("@CM_LegendLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendLocation", chartMain.CM_LegendLocation);
}
if (string.IsNullOrEmpty(chartMain.CM_Series))
{
idb.AddParameter("@CM_Series", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Series", chartMain.CM_Series);
}
if (chartMain.CM_Width == 0)
{
idb.AddParameter("@CM_Width", 0);
}
else
{
idb.AddParameter("@CM_Width", chartMain.CM_Width);
}
if (chartMain.CM_Height == 0)
{
idb.AddParameter("@CM_Height", 0);
}
else
{
idb.AddParameter("@CM_Height", chartMain.CM_Height);
}
if (string.IsNullOrEmpty(chartMain.CM_XLineColor))
{
idb.AddParameter("@CM_XLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XLineColor", chartMain.CM_XLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_XMininum))
{
idb.AddParameter("@CM_XMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMininum", chartMain.CM_XMininum);
}
if (string.IsNullOrEmpty(chartMain.CM_XMaxinum))
{
idb.AddParameter("@CM_XMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMaxinum", chartMain.CM_XMaxinum);
}
if (string.IsNullOrEmpty(chartMain.CM_XIntervalOffset))
{
idb.AddParameter("@CM_XIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalOffset", chartMain.CM_XIntervalOffset);
}
if (string.IsNullOrEmpty(chartMain.CM_XInterval))
{
idb.AddParameter("@CM_XInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XInterval", chartMain.CM_XInterval);
}
if (string.IsNullOrEmpty(chartMain.CM_XIntervalType))
{
idb.AddParameter("@CM_XIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalType", chartMain.CM_XIntervalType);
}
if (string.IsNullOrEmpty(chartMain.CM_XArrowStyle))
{
idb.AddParameter("@CM_XArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XArrowStyle", chartMain.CM_XArrowStyle);
}
if (string.IsNullOrEmpty(chartMain.CM_XTitle))
{
idb.AddParameter("@CM_XTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitle", chartMain.CM_XTitle);
}
if (string.IsNullOrEmpty(chartMain.CM_XTitleAlignment))
{
idb.AddParameter("@CM_XTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitleAlignment", chartMain.CM_XTitleAlignment);
}
if (chartMain.CM_XMajorGrid == 0)
{
idb.AddParameter("@CM_XMajorGrid", 0);
}
else
{
idb.AddParameter("@CM_XMajorGrid", chartMain.CM_XMajorGrid);
}
if (string.IsNullOrEmpty(chartMain.CM_XMajorGridLineColor))
{
idb.AddParameter("@CM_XMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMajorGridLineColor", chartMain.CM_XMajorGridLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_YLineColor))
{
idb.AddParameter("@CM_YLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YLineColor", chartMain.CM_YLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_YMininum))
{
idb.AddParameter("@CM_YMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMininum", chartMain.CM_YMininum);
}
if (string.IsNullOrEmpty(chartMain.CM_YMaxinum))
{
idb.AddParameter("@CM_YMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMaxinum", chartMain.CM_YMaxinum);
}
if (string.IsNullOrEmpty(chartMain.CM_YIntervalOffset))
{
idb.AddParameter("@CM_YIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalOffset", chartMain.CM_YIntervalOffset);
}
if (string.IsNullOrEmpty(chartMain.CM_YInterval))
{
idb.AddParameter("@CM_YInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YInterval", chartMain.CM_YInterval);
}
if (string.IsNullOrEmpty(chartMain.CM_YIntervalType))
{
idb.AddParameter("@CM_YIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalType", chartMain.CM_YIntervalType);
}
if (string.IsNullOrEmpty(chartMain.CM_YArrowStyle))
{
idb.AddParameter("@CM_YArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YArrowStyle", chartMain.CM_YArrowStyle);
}
if (string.IsNullOrEmpty(chartMain.CM_YTitle))
{
idb.AddParameter("@CM_YTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitle", chartMain.CM_YTitle);
}
if (string.IsNullOrEmpty(chartMain.CM_YTitleAlignment))
{
idb.AddParameter("@CM_YTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitleAlignment", chartMain.CM_YTitleAlignment);
}
if (string.IsNullOrEmpty(chartMain.CM_YMajorGrid))
{
idb.AddParameter("@CM_YMajorGrid", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGrid", chartMain.CM_YMajorGrid);
}
if (string.IsNullOrEmpty(chartMain.CM_YMajorGridLineColor))
{
idb.AddParameter("@CM_YMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGridLineColor", chartMain.CM_YMajorGridLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF1))
{
idb.AddParameter("@CM_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF1", chartMain.CM_UDEF1);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF2))
{
idb.AddParameter("@CM_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF2", chartMain.CM_UDEF2);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF3))
{
idb.AddParameter("@CM_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF3", chartMain.CM_UDEF3);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF4))
{
idb.AddParameter("@CM_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF4", chartMain.CM_UDEF4);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF5))
{
idb.AddParameter("@CM_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF5", chartMain.CM_UDEF5);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF6))
{
idb.AddParameter("@CM_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF6", chartMain.CM_UDEF6);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF7))
{
idb.AddParameter("@CM_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF7", chartMain.CM_UDEF7);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF8))
{
idb.AddParameter("@CM_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF8", chartMain.CM_UDEF8);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF9))
{
idb.AddParameter("@CM_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF9", chartMain.CM_UDEF9);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF10))
{
idb.AddParameter("@CM_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF10", chartMain.CM_UDEF10);
}
if (chartMain.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", chartMain.Stat);
}
return idb.ReturnValue(sql);
}
/// <summary>
/// 添加图表配置主表 ChartMain对象(即:一条记录)
/// </summary>
public object AddWithReturn(ChartMain chartMain)
{
string sql = "INSERT INTO ChartMain (CM_Module,CM_Title,CM_TitleLocation,CM_ChartAreas,CM_Legend,CM_LegendDock,CM_LegendLocation,CM_Series,CM_Width,CM_Height,CM_XLineColor,CM_XMininum,CM_XMaxinum,CM_XIntervalOffset,CM_XInterval,CM_XIntervalType,CM_XArrowStyle,CM_XTitle,CM_XTitleAlignment,CM_XMajorGrid,CM_XMajorGridLineColor,CM_YLineColor,CM_YMininum,CM_YMaxinum,CM_YIntervalOffset,CM_YInterval,CM_YIntervalType,CM_YArrowStyle,CM_YTitle,CM_YTitleAlignment,CM_YMajorGrid,CM_YMajorGridLineColor,CM_UDEF1,CM_UDEF2,CM_UDEF3,CM_UDEF4,CM_UDEF5,CM_UDEF6,CM_UDEF7,CM_UDEF8,CM_UDEF9,CM_UDEF10,Stat) VALUES (@CM_Module,@CM_Title,@CM_TitleLocation,@CM_ChartAreas,@CM_Legend,@CM_LegendDock,@CM_LegendLocation,@CM_Series,@CM_Width,@CM_Height,@CM_XLineColor,@CM_XMininum,@CM_XMaxinum,@CM_XIntervalOffset,@CM_XInterval,@CM_XIntervalType,@CM_XArrowStyle,@CM_XTitle,@CM_XTitleAlignment,@CM_XMajorGrid,@CM_XMajorGridLineColor,@CM_YLineColor,@CM_YMininum,@CM_YMaxinum,@CM_YIntervalOffset,@CM_YInterval,@CM_YIntervalType,@CM_YArrowStyle,@CM_YTitle,@CM_YTitleAlignment,@CM_YMajorGrid,@CM_YMajorGridLineColor,@CM_UDEF1,@CM_UDEF2,@CM_UDEF3,@CM_UDEF4,@CM_UDEF5,@CM_UDEF6,@CM_UDEF7,@CM_UDEF8,@CM_UDEF9,@CM_UDEF10,@Stat);SELECT @@IDENTITY AS ReturnID;";
if (string.IsNullOrEmpty(chartMain.CM_Module))
{
idb.AddParameter("@CM_Module", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Module", chartMain.CM_Module);
}
if (string.IsNullOrEmpty(chartMain.CM_Title))
{
idb.AddParameter("@CM_Title", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Title", chartMain.CM_Title);
}
if (string.IsNullOrEmpty(chartMain.CM_TitleLocation))
{
idb.AddParameter("@CM_TitleLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_TitleLocation", chartMain.CM_TitleLocation);
}
if (string.IsNullOrEmpty(chartMain.CM_ChartAreas))
{
idb.AddParameter("@CM_ChartAreas", DBNull.Value);
}
else
{
idb.AddParameter("@CM_ChartAreas", chartMain.CM_ChartAreas);
}
if (chartMain.CM_Legend == false)
{
idb.AddParameter("@CM_Legend", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Legend", chartMain.CM_Legend);
}
if (string.IsNullOrEmpty(chartMain.CM_LegendDock))
{
idb.AddParameter("@CM_LegendDock", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendDock", chartMain.CM_LegendDock);
}
if (string.IsNullOrEmpty(chartMain.CM_LegendLocation))
{
idb.AddParameter("@CM_LegendLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendLocation", chartMain.CM_LegendLocation);
}
if (string.IsNullOrEmpty(chartMain.CM_Series))
{
idb.AddParameter("@CM_Series", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Series", chartMain.CM_Series);
}
if (chartMain.CM_Width == 0)
{
idb.AddParameter("@CM_Width", 0);
}
else
{
idb.AddParameter("@CM_Width", chartMain.CM_Width);
}
if (chartMain.CM_Height == 0)
{
idb.AddParameter("@CM_Height", 0);
}
else
{
idb.AddParameter("@CM_Height", chartMain.CM_Height);
}
if (string.IsNullOrEmpty(chartMain.CM_XLineColor))
{
idb.AddParameter("@CM_XLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XLineColor", chartMain.CM_XLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_XMininum))
{
idb.AddParameter("@CM_XMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMininum", chartMain.CM_XMininum);
}
if (string.IsNullOrEmpty(chartMain.CM_XMaxinum))
{
idb.AddParameter("@CM_XMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMaxinum", chartMain.CM_XMaxinum);
}
if (string.IsNullOrEmpty(chartMain.CM_XIntervalOffset))
{
idb.AddParameter("@CM_XIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalOffset", chartMain.CM_XIntervalOffset);
}
if (string.IsNullOrEmpty(chartMain.CM_XInterval))
{
idb.AddParameter("@CM_XInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XInterval", chartMain.CM_XInterval);
}
if (string.IsNullOrEmpty(chartMain.CM_XIntervalType))
{
idb.AddParameter("@CM_XIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalType", chartMain.CM_XIntervalType);
}
if (string.IsNullOrEmpty(chartMain.CM_XArrowStyle))
{
idb.AddParameter("@CM_XArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XArrowStyle", chartMain.CM_XArrowStyle);
}
if (string.IsNullOrEmpty(chartMain.CM_XTitle))
{
idb.AddParameter("@CM_XTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitle", chartMain.CM_XTitle);
}
if (string.IsNullOrEmpty(chartMain.CM_XTitleAlignment))
{
idb.AddParameter("@CM_XTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitleAlignment", chartMain.CM_XTitleAlignment);
}
if (chartMain.CM_XMajorGrid == 0)
{
idb.AddParameter("@CM_XMajorGrid", 0);
}
else
{
idb.AddParameter("@CM_XMajorGrid", chartMain.CM_XMajorGrid);
}
if (string.IsNullOrEmpty(chartMain.CM_XMajorGridLineColor))
{
idb.AddParameter("@CM_XMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMajorGridLineColor", chartMain.CM_XMajorGridLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_YLineColor))
{
idb.AddParameter("@CM_YLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YLineColor", chartMain.CM_YLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_YMininum))
{
idb.AddParameter("@CM_YMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMininum", chartMain.CM_YMininum);
}
if (string.IsNullOrEmpty(chartMain.CM_YMaxinum))
{
idb.AddParameter("@CM_YMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMaxinum", chartMain.CM_YMaxinum);
}
if (string.IsNullOrEmpty(chartMain.CM_YIntervalOffset))
{
idb.AddParameter("@CM_YIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalOffset", chartMain.CM_YIntervalOffset);
}
if (string.IsNullOrEmpty(chartMain.CM_YInterval))
{
idb.AddParameter("@CM_YInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YInterval", chartMain.CM_YInterval);
}
if (string.IsNullOrEmpty(chartMain.CM_YIntervalType))
{
idb.AddParameter("@CM_YIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalType", chartMain.CM_YIntervalType);
}
if (string.IsNullOrEmpty(chartMain.CM_YArrowStyle))
{
idb.AddParameter("@CM_YArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YArrowStyle", chartMain.CM_YArrowStyle);
}
if (string.IsNullOrEmpty(chartMain.CM_YTitle))
{
idb.AddParameter("@CM_YTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitle", chartMain.CM_YTitle);
}
if (string.IsNullOrEmpty(chartMain.CM_YTitleAlignment))
{
idb.AddParameter("@CM_YTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitleAlignment", chartMain.CM_YTitleAlignment);
}
if (string.IsNullOrEmpty(chartMain.CM_YMajorGrid))
{
idb.AddParameter("@CM_YMajorGrid", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGrid", chartMain.CM_YMajorGrid);
}
if (string.IsNullOrEmpty(chartMain.CM_YMajorGridLineColor))
{
idb.AddParameter("@CM_YMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGridLineColor", chartMain.CM_YMajorGridLineColor);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF1))
{
idb.AddParameter("@CM_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF1", chartMain.CM_UDEF1);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF2))
{
idb.AddParameter("@CM_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF2", chartMain.CM_UDEF2);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF3))
{
idb.AddParameter("@CM_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF3", chartMain.CM_UDEF3);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF4))
{
idb.AddParameter("@CM_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF4", chartMain.CM_UDEF4);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF5))
{
idb.AddParameter("@CM_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF5", chartMain.CM_UDEF5);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF6))
{
idb.AddParameter("@CM_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF6", chartMain.CM_UDEF6);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF7))
{
idb.AddParameter("@CM_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF7", chartMain.CM_UDEF7);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF8))
{
idb.AddParameter("@CM_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF8", chartMain.CM_UDEF8);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF9))
{
idb.AddParameter("@CM_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF9", chartMain.CM_UDEF9);
}
if (string.IsNullOrEmpty(chartMain.CM_UDEF10))
{
idb.AddParameter("@CM_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF10", chartMain.CM_UDEF10);
}
if (chartMain.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", chartMain.Stat);
}
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
var Return = idb.ReturnValue(sql);
Ex = Return.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name,Ex);
return Re;
}
/// <summary>
/// 更新图表配置主表 ChartMain对象(即:一条记录
/// </summary>
public int Update(ChartMain chartMain)
{
StringBuilder sbParameter=new StringBuilder();
StringBuilder sb=new StringBuilder();
sb.Append(@"UPDATE ChartMain SET ");
if(chartMain.CM_Module_IsChanged){sbParameter.Append("CM_Module=@CM_Module, ");}
if(chartMain.CM_Title_IsChanged){sbParameter.Append("CM_Title=@CM_Title, ");}
if(chartMain.CM_TitleLocation_IsChanged){sbParameter.Append("CM_TitleLocation=@CM_TitleLocation, ");}
if(chartMain.CM_ChartAreas_IsChanged){sbParameter.Append("CM_ChartAreas=@CM_ChartAreas, ");}
if(chartMain.CM_Legend_IsChanged){sbParameter.Append("CM_Legend=@CM_Legend, ");}
if(chartMain.CM_LegendDock_IsChanged){sbParameter.Append("CM_LegendDock=@CM_LegendDock, ");}
if(chartMain.CM_LegendLocation_IsChanged){sbParameter.Append("CM_LegendLocation=@CM_LegendLocation, ");}
if(chartMain.CM_Series_IsChanged){sbParameter.Append("CM_Series=@CM_Series, ");}
if(chartMain.CM_Width_IsChanged){sbParameter.Append("CM_Width=@CM_Width, ");}
if(chartMain.CM_Height_IsChanged){sbParameter.Append("CM_Height=@CM_Height, ");}
if(chartMain.CM_XLineColor_IsChanged){sbParameter.Append("CM_XLineColor=@CM_XLineColor, ");}
if(chartMain.CM_XMininum_IsChanged){sbParameter.Append("CM_XMininum=@CM_XMininum, ");}
if(chartMain.CM_XMaxinum_IsChanged){sbParameter.Append("CM_XMaxinum=@CM_XMaxinum, ");}
if(chartMain.CM_XIntervalOffset_IsChanged){sbParameter.Append("CM_XIntervalOffset=@CM_XIntervalOffset, ");}
if(chartMain.CM_XInterval_IsChanged){sbParameter.Append("CM_XInterval=@CM_XInterval, ");}
if(chartMain.CM_XIntervalType_IsChanged){sbParameter.Append("CM_XIntervalType=@CM_XIntervalType, ");}
if(chartMain.CM_XArrowStyle_IsChanged){sbParameter.Append("CM_XArrowStyle=@CM_XArrowStyle, ");}
if(chartMain.CM_XTitle_IsChanged){sbParameter.Append("CM_XTitle=@CM_XTitle, ");}
if(chartMain.CM_XTitleAlignment_IsChanged){sbParameter.Append("CM_XTitleAlignment=@CM_XTitleAlignment, ");}
if(chartMain.CM_XMajorGrid_IsChanged){sbParameter.Append("CM_XMajorGrid=@CM_XMajorGrid, ");}
if(chartMain.CM_XMajorGridLineColor_IsChanged){sbParameter.Append("CM_XMajorGridLineColor=@CM_XMajorGridLineColor, ");}
if(chartMain.CM_YLineColor_IsChanged){sbParameter.Append("CM_YLineColor=@CM_YLineColor, ");}
if(chartMain.CM_YMininum_IsChanged){sbParameter.Append("CM_YMininum=@CM_YMininum, ");}
if(chartMain.CM_YMaxinum_IsChanged){sbParameter.Append("CM_YMaxinum=@CM_YMaxinum, ");}
if(chartMain.CM_YIntervalOffset_IsChanged){sbParameter.Append("CM_YIntervalOffset=@CM_YIntervalOffset, ");}
if(chartMain.CM_YInterval_IsChanged){sbParameter.Append("CM_YInterval=@CM_YInterval, ");}
if(chartMain.CM_YIntervalType_IsChanged){sbParameter.Append("CM_YIntervalType=@CM_YIntervalType, ");}
if(chartMain.CM_YArrowStyle_IsChanged){sbParameter.Append("CM_YArrowStyle=@CM_YArrowStyle, ");}
if(chartMain.CM_YTitle_IsChanged){sbParameter.Append("CM_YTitle=@CM_YTitle, ");}
if(chartMain.CM_YTitleAlignment_IsChanged){sbParameter.Append("CM_YTitleAlignment=@CM_YTitleAlignment, ");}
if(chartMain.CM_YMajorGrid_IsChanged){sbParameter.Append("CM_YMajorGrid=@CM_YMajorGrid, ");}
if(chartMain.CM_YMajorGridLineColor_IsChanged){sbParameter.Append("CM_YMajorGridLineColor=@CM_YMajorGridLineColor, ");}
if(chartMain.CM_UDEF1_IsChanged){sbParameter.Append("CM_UDEF1=@CM_UDEF1, ");}
if(chartMain.CM_UDEF2_IsChanged){sbParameter.Append("CM_UDEF2=@CM_UDEF2, ");}
if(chartMain.CM_UDEF3_IsChanged){sbParameter.Append("CM_UDEF3=@CM_UDEF3, ");}
if(chartMain.CM_UDEF4_IsChanged){sbParameter.Append("CM_UDEF4=@CM_UDEF4, ");}
if(chartMain.CM_UDEF5_IsChanged){sbParameter.Append("CM_UDEF5=@CM_UDEF5, ");}
if(chartMain.CM_UDEF6_IsChanged){sbParameter.Append("CM_UDEF6=@CM_UDEF6, ");}
if(chartMain.CM_UDEF7_IsChanged){sbParameter.Append("CM_UDEF7=@CM_UDEF7, ");}
if(chartMain.CM_UDEF8_IsChanged){sbParameter.Append("CM_UDEF8=@CM_UDEF8, ");}
if(chartMain.CM_UDEF9_IsChanged){sbParameter.Append("CM_UDEF9=@CM_UDEF9, ");}
if(chartMain.CM_UDEF10_IsChanged){sbParameter.Append("CM_UDEF10=@CM_UDEF10, ");}
if(chartMain.Stat_IsChanged){sbParameter.Append("Stat=@Stat ");}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CM_ID=@CM_ID; " );
string sql=sb.ToString();
if(chartMain.CM_Module_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_Module))
{
idb.AddParameter("@CM_Module", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Module", chartMain.CM_Module);
}
}
if(chartMain.CM_Title_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_Title))
{
idb.AddParameter("@CM_Title", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Title", chartMain.CM_Title);
}
}
if(chartMain.CM_TitleLocation_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_TitleLocation))
{
idb.AddParameter("@CM_TitleLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_TitleLocation", chartMain.CM_TitleLocation);
}
}
if(chartMain.CM_ChartAreas_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_ChartAreas))
{
idb.AddParameter("@CM_ChartAreas", DBNull.Value);
}
else
{
idb.AddParameter("@CM_ChartAreas", chartMain.CM_ChartAreas);
}
}
if(chartMain.CM_Legend_IsChanged)
{
if (chartMain.CM_Legend == false)
{
idb.AddParameter("@CM_Legend", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Legend", chartMain.CM_Legend);
}
}
if(chartMain.CM_LegendDock_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_LegendDock))
{
idb.AddParameter("@CM_LegendDock", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendDock", chartMain.CM_LegendDock);
}
}
if(chartMain.CM_LegendLocation_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_LegendLocation))
{
idb.AddParameter("@CM_LegendLocation", DBNull.Value);
}
else
{
idb.AddParameter("@CM_LegendLocation", chartMain.CM_LegendLocation);
}
}
if(chartMain.CM_Series_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_Series))
{
idb.AddParameter("@CM_Series", DBNull.Value);
}
else
{
idb.AddParameter("@CM_Series", chartMain.CM_Series);
}
}
if(chartMain.CM_Width_IsChanged)
{
if (chartMain.CM_Width == 0)
{
idb.AddParameter("@CM_Width", 0);
}
else
{
idb.AddParameter("@CM_Width", chartMain.CM_Width);
}
}
if(chartMain.CM_Height_IsChanged)
{
if (chartMain.CM_Height == 0)
{
idb.AddParameter("@CM_Height", 0);
}
else
{
idb.AddParameter("@CM_Height", chartMain.CM_Height);
}
}
if(chartMain.CM_XLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XLineColor))
{
idb.AddParameter("@CM_XLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XLineColor", chartMain.CM_XLineColor);
}
}
if(chartMain.CM_XMininum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XMininum))
{
idb.AddParameter("@CM_XMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMininum", chartMain.CM_XMininum);
}
}
if(chartMain.CM_XMaxinum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XMaxinum))
{
idb.AddParameter("@CM_XMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMaxinum", chartMain.CM_XMaxinum);
}
}
if(chartMain.CM_XIntervalOffset_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XIntervalOffset))
{
idb.AddParameter("@CM_XIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalOffset", chartMain.CM_XIntervalOffset);
}
}
if(chartMain.CM_XInterval_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XInterval))
{
idb.AddParameter("@CM_XInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XInterval", chartMain.CM_XInterval);
}
}
if(chartMain.CM_XIntervalType_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XIntervalType))
{
idb.AddParameter("@CM_XIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XIntervalType", chartMain.CM_XIntervalType);
}
}
if(chartMain.CM_XArrowStyle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XArrowStyle))
{
idb.AddParameter("@CM_XArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XArrowStyle", chartMain.CM_XArrowStyle);
}
}
if(chartMain.CM_XTitle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XTitle))
{
idb.AddParameter("@CM_XTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitle", chartMain.CM_XTitle);
}
}
if(chartMain.CM_XTitleAlignment_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XTitleAlignment))
{
idb.AddParameter("@CM_XTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XTitleAlignment", chartMain.CM_XTitleAlignment);
}
}
if(chartMain.CM_XMajorGrid_IsChanged)
{
if (chartMain.CM_XMajorGrid == 0)
{
idb.AddParameter("@CM_XMajorGrid", 0);
}
else
{
idb.AddParameter("@CM_XMajorGrid", chartMain.CM_XMajorGrid);
}
}
if(chartMain.CM_XMajorGridLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_XMajorGridLineColor))
{
idb.AddParameter("@CM_XMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_XMajorGridLineColor", chartMain.CM_XMajorGridLineColor);
}
}
if(chartMain.CM_YLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YLineColor))
{
idb.AddParameter("@CM_YLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YLineColor", chartMain.CM_YLineColor);
}
}
if(chartMain.CM_YMininum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMininum))
{
idb.AddParameter("@CM_YMininum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMininum", chartMain.CM_YMininum);
}
}
if(chartMain.CM_YMaxinum_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMaxinum))
{
idb.AddParameter("@CM_YMaxinum", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMaxinum", chartMain.CM_YMaxinum);
}
}
if(chartMain.CM_YIntervalOffset_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YIntervalOffset))
{
idb.AddParameter("@CM_YIntervalOffset", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalOffset", chartMain.CM_YIntervalOffset);
}
}
if(chartMain.CM_YInterval_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YInterval))
{
idb.AddParameter("@CM_YInterval", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YInterval", chartMain.CM_YInterval);
}
}
if(chartMain.CM_YIntervalType_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YIntervalType))
{
idb.AddParameter("@CM_YIntervalType", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YIntervalType", chartMain.CM_YIntervalType);
}
}
if(chartMain.CM_YArrowStyle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YArrowStyle))
{
idb.AddParameter("@CM_YArrowStyle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YArrowStyle", chartMain.CM_YArrowStyle);
}
}
if(chartMain.CM_YTitle_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YTitle))
{
idb.AddParameter("@CM_YTitle", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitle", chartMain.CM_YTitle);
}
}
if(chartMain.CM_YTitleAlignment_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YTitleAlignment))
{
idb.AddParameter("@CM_YTitleAlignment", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YTitleAlignment", chartMain.CM_YTitleAlignment);
}
}
if(chartMain.CM_YMajorGrid_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMajorGrid))
{
idb.AddParameter("@CM_YMajorGrid", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGrid", chartMain.CM_YMajorGrid);
}
}
if(chartMain.CM_YMajorGridLineColor_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_YMajorGridLineColor))
{
idb.AddParameter("@CM_YMajorGridLineColor", DBNull.Value);
}
else
{
idb.AddParameter("@CM_YMajorGridLineColor", chartMain.CM_YMajorGridLineColor);
}
}
if(chartMain.CM_UDEF1_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF1))
{
idb.AddParameter("@CM_UDEF1", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF1", chartMain.CM_UDEF1);
}
}
if(chartMain.CM_UDEF2_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF2))
{
idb.AddParameter("@CM_UDEF2", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF2", chartMain.CM_UDEF2);
}
}
if(chartMain.CM_UDEF3_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF3))
{
idb.AddParameter("@CM_UDEF3", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF3", chartMain.CM_UDEF3);
}
}
if(chartMain.CM_UDEF4_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF4))
{
idb.AddParameter("@CM_UDEF4", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF4", chartMain.CM_UDEF4);
}
}
if(chartMain.CM_UDEF5_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF5))
{
idb.AddParameter("@CM_UDEF5", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF5", chartMain.CM_UDEF5);
}
}
if(chartMain.CM_UDEF6_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF6))
{
idb.AddParameter("@CM_UDEF6", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF6", chartMain.CM_UDEF6);
}
}
if(chartMain.CM_UDEF7_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF7))
{
idb.AddParameter("@CM_UDEF7", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF7", chartMain.CM_UDEF7);
}
}
if(chartMain.CM_UDEF8_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF8))
{
idb.AddParameter("@CM_UDEF8", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF8", chartMain.CM_UDEF8);
}
}
if(chartMain.CM_UDEF9_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF9))
{
idb.AddParameter("@CM_UDEF9", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF9", chartMain.CM_UDEF9);
}
}
if(chartMain.CM_UDEF10_IsChanged)
{
if (string.IsNullOrEmpty(chartMain.CM_UDEF10))
{
idb.AddParameter("@CM_UDEF10", DBNull.Value);
}
else
{
idb.AddParameter("@CM_UDEF10", chartMain.CM_UDEF10);
}
}
if(chartMain.Stat_IsChanged)
{
if (chartMain.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", chartMain.Stat);
}
}
idb.AddParameter("@CM_ID", chartMain.CM_ID);
int Re = 0;
//SQL日志记录
var RunMethod = System.Reflection.MethodBase.GetCurrentMethod();
System.Collections.Hashtable param = new System.Collections.Hashtable();
string Ex = "0";
foreach (System.Collections.DictionaryEntry item in idb.GetParameters())
{
param.Add(item.Key, item.Value);
}
try
{
Re = idb.ExeCmd(sql);
Ex = Re.ToString();
}
catch (Exception ex)
{
Ex = ex.Message;
}
SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType + "." + RunMethod.Name,Ex);
return Re;
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(ChartMain model,bool IsValid)
{
bool result = false;
var e = new ModelExceptions();
if(e.IsValid && IsValid){
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(ChartMain model,bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(ChartMain model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
