回滚与实践格式化

来源：互联网发布：less.min.js 无法加载编辑：程序博客网时间：2024/04/29 17:24

/* private void button1_Click(object sender, EventArgs e)

{

DataTable tab = sqldo("select * from P_Project").Tables[0];

foreach (DataRow dr in tab.Rows)

{

string str = dr["Pstart"].ToString();

if (str.Trim() != "")

{

dr["Pstart"] = str.Substring(str.LastIndexOf('/') + 1) + "年" + Convert.ToDouble(str.Substring(0, str.IndexOf('/'))).ToString("00") + "月" + Convert.ToDouble(str.Substring(str.IndexOf('/') + 1, str.LastIndexOf('/') - str.IndexOf('/') - 1)).ToString("00") + "日";

}

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "server=.;database=szgc;uid=sa;pwd=";

conn.Open();

SqlTransaction tran =conn.BeginTransaction();

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.Transaction = tran;

try

{

cmd.CommandText = "delete from P_Project";

cmd.ExecuteNonQuery();

for (int i = 0; i < tab.Rows.Count; i++)

{

cmd.CommandText = "insert into P_Project values('" + tab.Rows[i]["Pid"].ToString().Trim() + "','" + tab.Rows[i]["Pname"].ToString().Trim() + "','" + tab.Rows[i]["Pindex"].ToString().Trim() + "','" + tab.Rows[i]["Paddress"].ToString().Trim() + "','" + tab.Rows[i]["Pstart"].ToString().Trim() + "','" + tab.Rows[i]["Pend"].ToString().Trim() + "','" + tab.Rows[i]["investment"].ToString().Trim() + "','" + tab.Rows[i]["Pass"].ToString().Trim() + "')";

cmd.ExecuteNonQuery();

}

tran.Commit();

MessageBox.Show("成功");

}

catch (Exception ex)

{

tran.Rollback();

MessageBox.Show(ex.Message);

}

----------------------------------------------------------------------------------------------------------------------------------------------------

internal string rqformat(string Ss)

{

int j;

string rqs;

string szs;

char[] dgs;

szs = "";

rqs = "";

int i;

int k = Ss.Length;

for (i = 0; i < k; i++)

{

dgs = Ss.Substring(i, 1).ToCharArray();

j = (int)dgs[0];

if (j >= 48 && j <= 57)

szs = szs + Ss.Substring(i, 1);

else

{

if (szs.Length == 1) szs = "0" + szs;

rqs = rqs + szs;

rqs = rqs + Ss.Substring(i, 1);

szs = "";

}

if (szs.Length == 1) szs = "0" + szs;

rqs = rqs + szs;

if (rqs.Substring(4, 1) != "年")

{

rqs = rqs.Substring(0, 4) + "年" + rqs.Substring(5, 2) + "月" + rqs.Substring(8, 2) + "日";

}

return rqs;

}