练习:Winform中对数据的增删改查
还是改成了在DGV中直接操作
对ADO.NET不熟，以前都是直接用写好的SQLHelper类，要好好补补
想起以前做多关键词查询时，不知道有<string>.Split(' ')这个方法可以拆分
当时自己写了方法来拆分关键字，存在返回的DataTable：
/// <summary>
/// 添加所有的关键词到DataTable中
/// </summary>
/// <param name="str">关键词字符串</param>
/// <returns></returns>
public DataTable DTKeyWords(string str)
{
DataTable dt = new DataTable();
dt.Columns.Add("KW");
DataRow dr = dt.NewRow();
string a = str;
while (_start < str.Length)
{
dr[0] = GetKeyWord(str);
dt.Rows.Add(dr.ItemArray);
}
return dt;
}
/// <summary>
/// 获取/拆分关键词
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public String GetKeyWord(string str)
{
int i = 0;
if (str.Substring(_start, str.Length - _start).Contains(" "))
{
while (str.IndexOf(" ", _start) == _start)
{
_start++;
}
int a = str.IndexOf(" ", _start);
if (a > 0)
{
string b = str.Substring(_start, a - _start);
_start = a + 1;
return b;
}
else
{
i = _start;
_start = str.Length;
return str.Substring(i, str.Length - i);
}
}
else
{
i = _start;
_start = str.Length;
return str.Substring(i, str.Length - i);
}
}
功能倒是实现了。。。不过还是冷汗下。。。
继续，都贴出来好了，类似的还有下面这个静态方法
当初为了视觉上的效果，要统一长度，结果也写了个方法
我也是最近看了c#入门，才知道有<string>.PadLeft/PadRight 这些方法。。。
暴汗。。。
/// <summary>
/// 统一字符串的长度[注:大于length值时 返回原值(String)]
/// </summary>
/// <param name="obj">泛型</param>
/// <param name="length">字符串总长度 (最大40)</param>
/// <param name="str">左对齐:L 右对齐:R (默认左对齐)</param>
/// <returns>obj</returns>
public static String ToStringStyle(object obj, int length, string str)
{
string i = " "; // 这里直接打上40个空格- -#，
int l = obj.ToString().Trim().Length;
int a = length - l;
if (a < 0)
{
return obj.ToString();
}
else
{
i = i.Substring(0, a);
if (str == "R")
{
obj = i + obj;
}
else
{
obj = obj + i;
}
return obj.ToString();
}
}
继续继续。。。四舍五入的方法
ps 那个时候从来没有用过double类型。。 XD
/// <summary>
/// 四舍五入方法[支持整数、负数]
/// </summary>
/// <param name="obj">obj</param>
public static Decimal ToCutDecimal(object obj)
{
if (obj != null)
{
string s = obj.ToString().Trim() == String.Empty ? "0.00" : obj.ToString().Trim();
string i = string.Empty;
if (s != string.Empty)
{
if (s.Contains("."))
{
if (Convert.ToDecimal(s) < Convert.ToDecimal(0))
{
i = (Convert.ToDecimal(s) - Convert.ToDecimal("0.005")).ToString();
}
else
{
i = (Convert.ToDecimal(s) + Convert.ToDecimal("0.005")).ToString();
}
int l = i.IndexOf(".");
s = i.Substring(0, l + 3);
return Convert.ToDecimal(s);
}
else
{
s = s + ".00";
return Convert.ToDecimal(s);
}
}
else
{
s = "0.00";
return Convert.ToDecimal(s);
}
}
else
{
return Convert.ToDecimal("0.00");
}
}
以前的世道好乱，0-0 。。。
在附上一个以前网上载下来的汉字转拼音的类，我有加了一两个方法(很多余的，不知道有转大小写的方法)
网上载的
/// <summary>
/// 汉字转拼音、大小写字母转换
/// </summary>
public class SplitWord
{
// 用C#实现汉字转化为拼音
// 实现的原理就是先将汉字转化成为内码，然后通过内码和拼音的对照来查找。
/// <summary>
///将所有的汉字转换成为拼音（小写）
/// </summary>
//static Regex MyRegex = new Regex("^[一-龥]$"); //汉字的正则表达式.eg: if(MyRegex.IsMatch(chrstr.ToString()))
static Regex MyRegex = new Regex("^[\u4e00-\u9fa5]$");//汉字的正则表达式.eg: if(MyRegex.IsMatch(chrstr.ToString()))
private static int[] pyvalue = new int[]{-20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257,-20242,-20230,-20051,-20036,-20032,-20026,
-20002,-19990,-19986,-19982,-19976,-19805,-19784,-19775,-19774,-19763,-19756,-19751,-19746,-19741,-19739,-19728,
-19725,-19715,-19540,-19531,-19525,-19515,-19500,-19484,-19479,-19467,-19289,-19288,-19281,-19275,-19270,-19263,
-19261,-19249,-19243,-19242,-19238,-19235,-19227,-19224,-19218,-19212,-19038,-19023,-19018,-19006,-19003,-18996,
-18977,-18961,-18952,-18783,-18774,-18773,-18763,-18756,-18741,-18735,-18731,-18722,-18710,-18697,-18696,-18526,
-18518,-18501,-18490,-18478,-18463,-18448,-18447,-18446,-18239,-18237,-18231,-18220,-18211,-18201,-18184,-18183,
-18181,-18012,-17997,-17988,-17970,-17964,-17961,-17950,-17947,-17931,-17928,-17922,-17759,-17752,-17733,-17730,
-17721,-17703,-17701,-17697,-17692,-17683,-17676,-17496,-17487,-17482,-17468,-17454,-17433,-17427,-17417,-17202,
-17185,-16983,-16970,-16942,-16915,-16733,-16708,-16706,-16689,-16664,-16657,-16647,-16474,-16470,-16465,-16459,
-16452,-16448,-16433,-16429,-16427,-16423,-16419,-16412,-16407,-16403,-16401,-16393,-16220,-16216,-16212,-16205,
-16202,-16187,-16180,-16171,-16169,-16158,-16155,-15959,-15958,-15944,-15933,-15920,-15915,-15903,-15889,-15878,
-15707,-15701,-15681,-15667,-15661,-15659,-15652,-15640,-15631,-15625,-15454,-15448,-15436,-15435,-15419,-15416,
-15408,-15394,-15385,-15377,-15375,-15369,-15363,-15362,-15183,-15180,-15165,-15158,-15153,-15150,-15149,-15144,
-15143,-15141,-15140,-15139,-15128,-15121,-15119,-15117,-15110,-15109,-14941,-14937,-14933,-14930,-14929,-14928,
-14926,-14922,-14921,-14914,-14908,-14902,-14894,-14889,-14882,-14873,-14871,-14857,-14678,-14674,-14670,-14668,
-14663,-14654,-14645,-14630,-14594,-14429,-14407,-14399,-14384,-14379,-14368,-14355,-14353,-14345,-14170,-14159,
-14151,-14149,-14145,-14140,-14137,-14135,-14125,-14123,-14122,-14112,-14109,-14099,-14097,-14094,-14092,-14090,
-14087,-14083,-13917,-13914,-13910,-13907,-13906,-13905,-13896,-13894,-13878,-13870,-13859,-13847,-13831,-13658,
-13611,-13601,-13406,-13404,-13400,-13398,-13395,-13391,-13387,-13383,-13367,-13359,-13356,-13343,-13340,-13329,
-13326,-13318,-13147,-13138,-13120,-13107,-13096,-13095,-13091,-13076,-13068,-13063,-13060,-12888,-12875,-12871,
-12860,-12858,-12852,-12849,-12838,-12831,-12829,-12812,-12802,-12607,-12597,-12594,-12585,-12556,-12359,-12346,
-12320,-12300,-12120,-12099,-12089,-12074,-12067,-12058,-12039,-11867,-11861,-11847,-11831,-11798,-11781,-11604,
-11589,-11536,-11358,-11340,-11339,-11324,-11303,-11097,-11077,-11067,-11055,-11052,-11045,-11041,-11038,-11024,
-11020,-11019,-11018,-11014,-10838,-10832,-10815,-10800,-10790,-10780,-10764,-10587,-10544,-10533,-10519,-10331,
-10329,-10328,-10322,-10315,-10309,-10307,-10296,-10281,-10274,-10270,-10262,-10260,-10256,-10254};
private static string[] pystr = new string[]{"a","ai","an","ang","ao","ba","bai","ban","bang","bao","bei","ben","beng","bi","bian","biao",
"bie","bin","bing","bo","bu","ca","cai","can","cang","cao","ce","ceng","cha","chai","chan","chang","chao","che","chen",
"cheng","chi","chong","chou","chu","chuai","chuan","chuang","chui","chun","chuo","ci","cong","cou","cu","cuan","cui",
"cun","cuo","da","dai","dan","dang","dao","de","deng","di","dian","diao","die","ding","diu","dong","dou","du","duan",
"dui","dun","duo","e","en","er","fa","fan","fang","fei","fen","feng","fo","fou","fu","ga","gai","gan","gang","gao",
"ge","gei","gen","geng","gong","gou","gu","gua","guai","guan","guang","gui","gun","guo","ha","hai","han","hang",
"hao","he","hei","hen","heng","hong","hou","hu","hua","huai","huan","huang","hui","hun","huo","ji","jia","jian",
"jiang","jiao","jie","jin","jing","jiong","jiu","ju","juan","jue","jun","ka","kai","kan","kang","kao","ke","ken",
"keng","kong","kou","ku","kua","kuai","kuan","kuang","kui","kun","kuo","la","lai","lan","lang","lao","le","lei",
"leng","li","lia","lian","liang","liao","lie","lin","ling","liu","long","lou","lu","lv","luan","lue","lun","luo",
"ma","mai","man","mang","mao","me","mei","men","meng","mi","mian","miao","mie","min","ming","miu","mo","mou","mu",
"na","nai","nan","nang","nao","ne","nei","nen","neng","ni","nian","niang","niao","nie","nin","ning","niu","nong",
"nu","nv","nuan","nue","nuo","o","ou","pa","pai","pan","pang","pao","pei","pen","peng","pi","pian","piao","pie",
"pin","ping","po","pu","qi","qia","qian","qiang","qiao","qie","qin","qing","qiong","qiu","qu","quan","que","qun",
"ran","rang","rao","re","ren","reng","ri","rong","rou","ru","ruan","rui","run","ruo","sa","sai","san","sang",
"sao","se","sen","seng","sha","shai","shan","shang","shao","she","shen","sheng","shi","shou","shu","shua",
"shuai","shuan","shuang","shui","shun","shuo","si","song","sou","su","suan","sui","sun","suo","ta","tai",
"tan","tang","tao","te","teng","ti","tian","tiao","tie","ting","tong","tou","tu","tuan","tui","tun","tuo",
"wa","wai","wan","wang","wei","wen","weng","wo","wu","xi","xia","xian","xiang","xiao","xie","xin","xing",
"xiong","xiu","xu","xuan","xue","xun","ya","yan","yang","yao","ye","yi","yin","ying","yo","yong","you",
"yu","yuan","yue","yun","za","zai","zan","zang","zao","ze","zei","zen","zeng","zha","zhai","zhan","zhang",
"zhao","zhe","zhen","zheng","zhi","zhong","zhou","zhu","zhua","zhuai","zhuan","zhuang","zhui","zhun","zhuo",
"zi","zong","zou","zu","zuan","zui","zun","zuo"};
/**/
/// <summary>
/// 转化汉字的全部拼音(小写)(只针对汉字)
/// </summary>
/// <param name="chrstr"></param>
/// <returns></returns>
public static string ConvertAllSpell(string chrstr)
{
try
{
Regex MyRegex = new Regex("^[\u4e00-\u9fa5]$");
byte[] array = new byte[2];
string returnstr = "";
int chrasc = 0;
int i1 = 0;
int i2 = 0;
char[] nowchar = chrstr.ToCharArray();
for (int j = 0; j < nowchar.Length; j++)
{
if (MyRegex.IsMatch(nowchar[j].ToString()))
{
array = System.Text.Encoding.Default.GetBytes(nowchar[j].ToString());
i1 = (short)(array[0]);
i2 = (short)(array[1]);
chrasc = i1 * 256 + i2 - 65536;
if (chrasc > 0 && chrasc < 160)
{
returnstr += nowchar[j];
}
else
{
for (int i = (pyvalue.Length - 1); i >= 0; i--)
{
if (pyvalue[i] <= chrasc)
{
returnstr += pystr[i];
break;
}
}
}
}
else
{
returnstr += nowchar[j].ToString();
}
}
return returnstr;
}
catch
{
return chrstr;
}
}
//ChineseToPY
/**/
/// <summary>
/// 只转换每个汉字首字母(true小写)(false大写)(只针对汉字)
/// </summary>
/// <param name="strText"></param>
/// <returns></returns>
public static string GetChineseSpell(string strText, bool b)
{
try
{
int len = strText.Length;
string myStr = "";
for (int i = 0; i < len; i++)
{
if (b == true)
{
myStr += ToLower(getSpell(strText.Substring(i, 1)));
}
else
{
myStr += getSpell(strText.Substring(i, 1));
}
}
return myStr;
}
catch
{
return strText;
}
}
/// <summary>
/// 获得第一个汉字的首字母(大写)(只针对汉字)
/// </summary>
/// <param name="cnChar"></param>
/// <returns></returns>
public static string getSpell(string cnChar)
{
try
{
byte[] arrCN = Encoding.Default.GetBytes(cnChar);
if (arrCN.Length > 1)
{
int area = (short)arrCN[0];
int pos = (short)arrCN[1];
int code = (area << 8) + pos;
int[] areacode = { 45217, 45253, 45761, 46318, 46826, 47010, 47297, 47614, 48119, 48119, 49062, 49324, 49896, 50371, 50614, 50622, 50906, 51387, 51446, 52218, 52698, 52698, 52698, 52980, 53689, 54481 };
for (int i = 0; i < 26; i++)
{
int max = 55290;
if (i != 25) max = areacode[i + 1];
if (areacode[i] <= code && code < max)
{
return Encoding.Default.GetString(new byte[] { (byte)(65 + i) });
}
}
return "*";
}
else return cnChar;
}
catch
{
return cnChar;
}
}
/// <summary>
/// 大写转小写(只针对单个字符)
/// </summary>
/// <param name="strText"></param>
/// <returns></returns>
public static string ToLower(string strText)
{
if (strText.Length == 1)
{
try
{
char a = Convert.ToChar(strText);
if ((int)a >= 65 && (int)a <= 90)
{
return a.ToString().ToLower();
}
else
{
return strText;
}
}
catch (Exception ex)
{
return strText;
}
}
else
{
return strText;
}
}
/// <summary>
/// 将字符串的字母转小写 (只针对字母)
/// </summary>
/// <param name="strText"></param>
/// <returns></returns>
public static string StringToLower(string strText)
{
try
{
int len = strText.Length;
string myStr = "";
for (int i = 0; i < len; i++)
{
myStr += ToLower(strText.Substring(i, 1));
}
return myStr;
}
catch
{
return strText;
}
}
}
