/// <summary> /// 返回节点的属性值 /// </summary> /// <param name="childNode">节点</param> /// <param name="Name">属性名称</param> /// <param name="value">默认值</param> /// <returns>如果属性值存在,返回属性值,如果不存在,返回默认值</returns> public static float GetValFromDT(DataTable dt, string Name, int irow, float sValue) { try { if (dt == null) { return(sValue); } string ss = ""; if (dt.Columns.Contains(Name)) { ss = dt.Rows[irow][Name].ToString(); } if (CABCSTR.IsFloat(ss) || CABCSTR.IsNum(ss)) { return(Convert.ToSingle(ss)); } else { return(sValue); } } catch { return(sValue); } }
/// <summary> /// 返回单元格值,如果没有返回默认值 /// </summary> /// <param name="ncell">单元格</param> /// <param name="s0">默认值</param> /// <returns>返回值</returns> public static int GetValueFromCell(DataGridViewCell ncell, int s0) { string s1 = GetValueFromCell(ncell, "0"); if (CABCSTR.IsNum(s1)) { return(Convert.ToInt32(s1)); } else { return(0); } }
/// <summary> /// 返回单元格值,如果没有返回默认值 /// </summary> /// <param name="ncell">单元格</param> /// <param name="s0">默认值</param> /// <returns>返回值</returns> public static float GetValueFromCell(DataGridViewCell ncell, float s0) { string s1 = GetValueFromCell(ncell, "0"); if (CABCSTR.IsFloat(s1)) { return(Convert.ToSingle(s1)); } else { return(0); } }
/// <summary> /// 返回节点的属性值 /// </summary> /// <param name="childNode">节点</param> /// <param name="Name">属性名称</param> /// <param name="value">默认值</param> /// <returns>如果属性值存在,返回属性值,如果不存在,返回默认值</returns> public static int GetValFromDT(DataSet ds, int index, string Name, int irow, int sValue) { try { DataTable dt; if (index < ds.Tables.Count) { dt = ds.Tables[index]; } else { dt = ds.Tables[0]; } if (dt == null) { return(sValue); } string ss = ""; if (ds.Tables[0].Columns.Contains(Name)) { ss = ds.Tables[0].Rows[irow][Name].ToString(); } if (CABCSTR.IsFloat(ss) || CABCSTR.IsNum(ss)) { return((int)Convert.ToSingle(ss)); } else { return(sValue); } } catch { return(sValue); } }
/// <summary> /// 按规律设定表格单元格 /// </summary> /// <param name="dGV">表格名称</param> /// <param name="iCRC">循环行数</param> /// <param name="bAdd">是否递增</param> public static bool dGVSetByCrc(DataGridView dGV, int iCRC, bool bAdd) { try { List <int> LsRow = CABCDGV.GetSelRow(dGV); List <int> LsCol = CABCDGV.GetSelCol(dGV); if (LsRow.Count < iCRC + 1) { return(false); } for (int n = 0; n < iCRC; n++) { for (int i = 0; i < LsCol.Count; i++) { string sHead = dGV.Columns[LsCol[i]].HeaderText; string str0 = ""; if (dGV.Rows[LsRow[n]].Cells[LsCol[i]].Value != null) { str0 = dGV.Rows[LsRow[n]].Cells[LsCol[i]].Value.ToString(); } string str1 = ""; if (bAdd && dGV.Rows[LsRow[n + iCRC]].Cells[LsCol[i]].Value != null) { str1 = dGV.Rows[LsRow[n + iCRC]].Cells[LsCol[i]].Value.ToString(); } else { str1 = str0; } double dStart = 0, dAdd = 0; int iStart = 0, iLen = 0; string sChar = ""; int iRes = CABCSTR.Get2StrChange(str0, str1, ref dStart, ref dAdd, ref sChar, ref iStart, ref iLen); if (iRes == 0) { return(false); } int kStart = 1; if (bAdd) { kStart = 2; } for (int k = kStart; k < Math.Ceiling(((LsRow.Count / (double)iCRC))); k++) { if (n + k * iCRC >= LsRow.Count) { continue; } double dVal = dStart + dAdd * k; string sValue = ""; if (iRes == 1) { sValue = dVal.ToString(); } else if (iRes == 2) { string sVal = new String('0', iLen) + dVal.ToString(); sValue = sChar.Insert(iStart, sVal.Substring(sVal.Length - iLen, iLen)); } else if (iRes == 3) { sValue = str0; } dGV.Rows[LsRow[n + k * iCRC]].Cells[LsCol[i]].Value = sValue; } } } return(true); } catch (Exception ex) { return(false); } }